Highly motivated, innovative and disciplined IT professional with extensive technical knowledge in OLTP, Data Warehouse and Data Lake. Successfully driven several database management and ETL projects with lead role from concept to implementation. Specialized in Oracle Database and Cloudera Big data platform. Highly recognized for great system performance improvement skills.
Design/Development of realtime & batch data processing
Logical/Physical data modeling
Optimizing and performance tuning
Oracle database administration
Strong collaboration ,communication & team management skill.
Design and development of
Oracle, PostgresSql, Greenplum, Hive, Sqoop, Sqlserver, Nosql (Hbase, mongodb), OLTP and data wareho
Senior Database Architect01/2015 to CurrentPRUDENTIAL FINANCIALNewark, NJ
Taken lead role in design and development of a data lake consisting of flexible schema architecture and real time data exchange between centralized database and business units; the purposes of data lake are to centralize business processes, facilitate cross marketing and do better analysis by studying customer behavior; Hence improve internal processes, reduce cost and enhance customer experience.
Designed and developed data flow/solution architecture with flexible schema to handle structured/unstructured data for real time and batch processing using Oracle , Mongo DB , Hive, Sqoop, Spark , shell script , Python ,Avro , Kafka etc.
in HDFS and Linux.
Collaborated with product team, application development team, analytics team and business units IT team for consolidating data and service requirements.
Prepared Logical and physical data model for OLTP and Data Lake.
Installed and setup IBM info sphere for real time data replication between Oracle and DB2.
Strategized development and integration plan among internal and external teams.
Identified suitable cost effective software products by exercising POC.
Planned and delegated work among team members; mentored development team and QA team by providing them technical and functional support.
Database Architect & Administrator01/2010 to 01/2015ATLANTIC CONTAINER LINE ACLWestfield, NJ
Strategized implementation & support of a shipment management platform by incorporating business functionality of legacy system, incorporating new EDI processes for live/ batch data exchange & incorporating new business functionality as required by business.
Designed relational/dimensional databases (logical/physical data model) & ETL processes.
Prepared coding standards and database performance improvements guidelines.
Coordinated with external (customers, vendors, partners in various countries) IT teams and internal departments to compile and document data requirement for supporting various business operations.
Communicated business requirements, data model & ETL architecture to development team.
Collaborated with finance/accounting team to extract data from SAP, prepare budgeting and planning report, design/develop Business intelligence interface using business objects.
Provided 24/7 on call support for various DBA activities including troubleshooting performance issues, CDC, golden gate replication, data guard, backup recovery etc.
Designed oracle database architecture to enhance performances that include partitioning, indexing, stats gathering etc.; Developed complex stored procedure.
Database Architect Consultant01/2006 to 01/2010SEI INVESTMENTOaks, PA
Designed and developed common services for activity management and a framework for scalable batch processing in global wealth management platform.
Designed and developed physical/logical data model and stored procedure to support workflow in the investment management platform.
Coordinated with other internal development team and data architects to integrate services and overall improvement of system performance.
Conducted knowledge sharing sessions to share best practices and performance improvement guidelines.
Assistant Consultant01/1999 to 01/2006TATA CONSULTANCY SERVICESNJ
Developed program to fetch and store real time stock market from data provider and to display those in various on air applications for CNBC.
Designed & developed data warehouse and ETL processes in NBC for Nielson data.
Coordinated between client and offshore development team.
Developed database component of an e-commerce platform for GE-Plastics.
Coordinated client visit, prepared request for proposal and project plan.
Education and Training
RUTGERS, THE STATE UNIVERSITY OF NEW JERSEYNewark, NJ
Master of Business Administration: Finance & StrategyMay 2017Rutgers Business SchoolGPA: GPA: 3.9Finance & Strategy GPA: 3.9
Bachelor of Engineering: Electrical EngineeringMay 1999NATIONAL INSTITUTE OF TECHNOLOGYDurgapur, INDIAElectrical Engineering Received merit scholarship in several semesters & award for final year project. Received first class honors degree. MBA Studies: Team Projects Financial Statement and cash flow analysis of an organization. Expedia, Orbitz Merger - Valuation analysis - Mergers and Acquisition Global Competitiveness Report - International Financial market Simulating Facebook-WhatsApp negotiation process Organization Behavior - Identify and analyze the underlying issues of a real organization/project team. Doing Business in Turkey - Cross Cultural Management Strategic Management at Tesla 13 2