SUMMARY:

• Over sixteen years of leadership & hands - on experience in Data Warehousing and Business Intelligence area in the Capacity of Data Warehouse Architect, Data Modeler, Designer, Administrator, ETL Lead & Developer.
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved interactions with top management executives, business sponsors and IT department.
• Responsible for defining the information architecture and technology infrastructure along with the design of multi-dimensional data models and the Business Intelligence delivery solutions.
• Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• A unique mix of complete application/database development life cycle resulting from solid educational background/trainings and adapting to diverse roles inAnalysis, design, administration, development and implementation of data warehouse, ETL, client/server, transactional application & managing the offshore & onsite ETL team.
• Involved in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages and complex SQL queries for extracting the data to system
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2, netezza, SQL Server Databases & Siebel application .
• Strong Experience in ETL data from various sources in data warehouse using data stage designer & data stage director. Data stage quality stage & Data stage MDM.
• Scheduled jobs, alerts, DTS, SSIS Packages in SQL server
• Performance tuning: Expertise in session partitioning, session tuning by optimizing Source, target, mappings and transformations.
• Documentation: Expertise in preparing the ETL Design Documents like High Level and low level Design documents.
• Experience in bio-tech, Pharmaceutical, insurance, Financial, HR & Medical insurance domains.

KEY AREAS OF EXPERTISE:

• Data Architect
• Database administrator
• Executive Presentations
• Database modeling
• BI development Lead
• Customer & Production Support
• On shore & off shore ETL development lead
• Project analyst Lead
• Cross-functional team leadership
• Business analyst
• Integration
• MIS
• ETL administrator
• Performance tuning
• Technical training
• Implementation & Deployments
• Project Management
• ETL, Database & Report Developer

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

ETL Architect Lead/Lead Developer

Environment: Informatica (9.5 & 9.1), Microsoft Visio, IBM DB2 Database, SQL Server, Teradata, ORACLE 11G, Aix Unix shell scripting,netezza,Seibel for power exchange, PL/SQL, TSQL,COGNOS 10.

Responsibilities:

• The responsibilities involved Business analysis, Data Analysis, data Architecture, Data Integration, BI administrator, Developer Lead and Data Modeling.
• Developed 50+ mapping in informatica with the team.
• Responsible for Informatica administration.
• In corporate the Lab Corp different sources to the data warehouse (EGL). Sources include Siebel, oracle, netezza, DB2, Sql server, Flat file, Complex flat file & xml files.
• Managed the complete project with a team size of over 10 persons. Successfully managed the onshore & offshore ETL development team (around 5 people) for the development of data warehouse project. Analyzed the existing systems and the business user requirements for tactical and strategic needs.
• Defined the Architecture and the various phases to create the data warehouse.
• Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to corporate mergers.
• Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation.
• Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results.
• Informatica Data Quality (IDQ 8.6.1) is used here for data quality measurement.

Confidential

Environment: IBM Web Sphere Data Stage 8.5 & 11 Parallel Extender, Web Services, Quality Stage 8.1, (Designer, Director, Manager), Microsoft Visio, IBM DB2 Database, SQL Server, Teradata, ORACLE 11G, Unix, Windows. Informatica 9.1.

Responsibilities:

• Successfully manage the Confidential from Informatica to data stage for financial component.
• Created Data stage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages. Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Creation of jobs sequences.
• Experience in Tuning SQL queries and T-SQL queries & improving the performance of the Database.
• Developed the Job for Patient MDM using Data stage quality stage & Data stage MDM using data stage designer.
• Client Interface: United Health Care, Aetna & BCBS Results Interface is a system responsible for consolidating and delivery of monthly billing data with result details (from US Labs LMS) to respective payors. Us Labs are a subsidiary of Lab Corp. The source DB is in SQL Server and flat file structures and processing and delivery system is in Oracle DB. Successfully manage project with all different insurance company with same model & convert the data in xml & HL7 file & deliver to the clients. Product used for project is informatica 9.5, oracle 11g & fusion middleware.
• Migration: Successfully completed the migration process of software & data from Confidential data warehouse to Lab Corp data warehouse. I worked as a project lead & also did the migration of the informatica repository from HP UNIX 32 bit to Aix 64 bit server within timely manager. Handled the project as a BI administrator to set up the dev, qa, and UAT & production env for oracle, Informatica & cognos.

Technologies Dissected: Informatica (9.1 & 9.5),data stage(8.5,11), data stage MDM, data stage quality stage, oracle (10g & 11g),Sqlserver (2000 & 2005), SQL,PL SQL,Siebel (8.5),netezza, DB2, Toad, Rapid sql, Oracle enterprise manager, xml spy (2008 & 2014) .Cognos (8.5,10), Erwin, visio, SharePoint & Microsoft office products. Hadoop eco system, Hiev, Pig, HDFS, flume, HBase & sqoop

Technologies Reconnoitered: Hadoop Map Reduce, green plum, & Oracle golden gate

Confidential, New York, NY

ETL Lead/Lead Developer

Responsibilities:

• Development & ETL Lead: successfully completed the Gedi data warehouse ETL development in timely manner. Managed the offshore & onshore team of ETL development (around 10). Developed around 150+ mappings (simple & complex), mapplets using informatica as a development tool. Worked at offshore location to speed up the development process in India with the deloitte (off shore resources). We developed the data warehouse using different sources like oracle, sql server, Siebel (business component) & flat files. Data warehouse has a module for clinical, billing, reimbursement, CRM & sales commission. Around 200 users were using the data warehouse. I also worked with dba to do the performance tuning of the database & queries.
• Requirements: Prepared Business Requirements Documents to manage analyze and convert business requirements into functional requirements and further creating use cases for crafting system requirements that facilitate system design and architecture.
• Data Modeling: Assisted in database modeling and Designed Data Flow Diagrams (DFD’s) and Entity Relationship diagrams (ERD’s) using various database modeling tools for Data Warehouse and Reporting.
• Business Continuity: Design, development and implementation of data warehouse for data and applications (Financial, Clinical, Sales, and Billing & Marketing).
• Customer support: Solved complex high severity problems related to application, development, system & database within the cutting SLA timeframes. Assist customer support & development team in tracing the development code for locating the error path.
• MIS/Planning: Prepared project scheduling, estimated time and resources, conducted interviews, proposed solutions, designed reports, created business cases, Business requirement documentation, statistical analysis and presentations to Executive Directors on an ongoing basis.
• Clinical Production Databases: Worked as oracle DBA & system architect to merge the entire Lab databases to a centralized database (CDB) & replication through Oracle stream (bi directional). We have implemented around 9 Confidential genetics sites with the streams & around 45 databases are merged into CDB.
• Clinical Data warehouse & Billing interface:
• Worked as a Senior ETL & Database developer to develop the billing interface with clinical production system & also did the ETL development for Clinical data warehouse & Confidential genetics clinical data.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages and DB triggers. & Development of domain logic using SQL, PL/SQL.
• Pro*C++ Coding to automate WAN Trans process for implementing Oracle Streams.
• Developed 30+ simple & complex mappings using Informatica Power Center tools Designer, Repository Manager, Workflow manager & workflow monitor.
• Worked on different tasks in Workflows such as sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Worked as Administrator of Informatica & cognos repository as a backup administrator.
• Tuned the Informatica mappings for optimal load performance.

Technologies Dissected: Informatica (8.0,8.5,9.1 ), oracle ( 7,8i,9i,10g ),Sqlserver (2000 & 2005), SQLPL SQL, Siebel (8.0), Toad, Rapid sql, Oracle enterprise manager, xml spy (2008) .Business objects (5.0), Cognos (8.0 & 8.5), Erwin, Visio, SharePoint & Microsoft office products. Hadoop eco system, Hive, Pig, HDFS, flumeHBase & sqoop