SUMMARY:

• Over 7 years of IT experience in the designing and implementing of Data Warehousing and Data Integration including Requirement Gathering, Data Analysis, Design, Development, Testing and Production.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experienced in various Business Domains including Health Care, Finance and Casualty Insurance, Manufacturing.
• Experience in developing ETL applications for Extraction, Transformation, and Loading into Data Warehouse/Data mart. Used Informatica Power Center 10.1/9.x/8.x/7.x Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Workflow Manager Tools (Task Developer, Worklet and Workflow Designer).
• Using Informatica Power Exchange tool to read data source from heterogynous source system such as variable length VSAM file.
• Extensively used ETL processes to load data from various source systems such as Oracle, SQL Server, Flat Files, XML files into target system by applying business logic on transformation mapping for inserting and updating records when loaded.
• Experience in RDBMS databases systems like Oracle 12c/11g/10g/9i and SQL Server.
• Strong experience working on End - To-End implementation of Data warehouse and Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake , Data modeling experience using Normalization, FACT & Dimensions tables, Physical & logical database design and modelling.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Worked on generating BI Reports using Tableau & Cognos Reports.
• Familiar with getting requirements from Business users and having discussions with them to finalize requirements.
• Experience in preparing design documents and getting sign-off from Business users.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Experience in the On-Line Transaction Processing (OLTP) database designing strategies
• Knowledge of Informatica administration in windows and Linux environment.
• Involved in the development of Informatica mappings and mapplets and also tuned them for optimum performance.
• Experience in implementing business rules by creating re-usable transformations.
• A good team player with inter-personal, analytical and documentation skills
• Have good communication, analytical, interpersonal and presentation skills.

TECHNICAL SKILLS:

ORACLE DATABASE, MS SQL SERVER, MAPPINGS, SQL SERVER, INFORMATICA POWERCENTER, TABLEAU, EXCEL, VISIO, AGILE METHODLOGIES, POWERPOINT, MS PROJECTS, ERP, DB2, ETL, PL/SQL, Oracle11c, Teradata, Windows, and UNIX Shell scripting, IDQ 10.1.1/9.6.1, Autosys Scheduler.

PROFESSIONAL EXPERIENCE:

ETL / Informatica Developer

Confidential - Tampa, FL

Responsibilities:

• Worked along with the Business Analysts for requirements gathering, business analysis, and testing and project coordination.
• Created Process and Technical Design Documents for the mappings that is built to load the dimensions in the data warehouse.
• Involved in all the phase of the project development, acceptance and production.
• Optimization and Performance tuning of mappings to achieve high response times.
• Created reusable transformations and Mapplets and used them in various mappings.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted according to the business rules and technical specifications.
• Prepared Document for Root Cause Analysis (RCA).
• Extensively used ETL load data using PowerCenter from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Design and Development of ETL routines, using Informatica PowerCenter within the Informatica Mappings, usage of Lookups, Ranking, Stored procedures, functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers.
• Debugging and Trouble Shooting of Informatica Mappings.
• Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Assisted in knowledge transfer to client personal for maintaining the environment after implementation.
• Written Test scripts and Test cases for testing and enhancements which were used by QA for unit testing and user acceptance testing.
• Configure the workflow, Tables and indexes using Oracle Data warehouse Administration Console (DAC) and monitor the job runs for full and incremental loads.
• Coordinated User Acceptance Testing (UAT) with the business users.
• Written shell scripts in UNIX to execute the workflow, created Workflow, Worklets and Tasks to read parameters from parameter files.
• Documented the complete Mappings, System delivery specification, test scripts and technical systems design.

Environment: Informatica PowerCenter 10.x/9.x, ETL, PL/SQL, DB2, Oracle11c, DAC, Teradata, Windows, and UNIX Shell scripting.

ETL/ Informatica Developer

Confidential - saltlake city, ut

Responsibilities:

• Worked closely with multiple business units in requirement gathering, parsed high-level design spec and prepared LLD.
• Developed ETL processes for CCAR (Comprehensive Capital Analysis and Review) Implementation project.
• Created the reusable objects required for the mapping development and used them often in coding.
• Used best practices in coding and developed the mappings with high performance.
• Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Relational Tables (SQL Server and Oracle).
• Expertise in applying Performance Tuning techniques. Worked on ETL objects that were already in production and successfully modified to improve the performance.
• Performed technical walk-through as needed to communicate design/coded solution and to seek input from team members.
• Create mapping using Informatica IDQ (Data Quality) to cleanness data and feed into tables again.
• Use IDQ analyst tool to create rules and apply while running column profiling.
• Validated the current production data, existing data and the programming logic involved.
• Experience in debugging ETL jobs to check in for the errors and warnings associated with each Job run.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.
• Strong problem solving skills. Helped production support teams in case of any issues in daily or monthly loads as a Level 3 support team member.

Environment: Informatica Power Center 9.6.1, PL/SQL, IBM Infosphere DataStage 8.5, IDQ 9.6.1, MS SQL Server, MS Access, Windows 2000, Autosys Scheduler.

ETL/ Informatica Developer

Confidential - dallas, tx

Responsibilities:

• Conduct data research and analysis to resolve healthcare Medicare/Medicaid eligibility, enrollment and billing issues.
• Generate Quarterly Audit Reconciliation report for compliance department.
• Extract, Transform and Load - data for business users to manipulate into reports.
• Supported management team with reports generation and analysis using Excel and SQL.
• Analyzed invoice data against carrier contracts to alert of any discrepancies.
• Developed reporting and various dashboards across all areas of the client's business using Tableau in order to enable quick identify of claims issues.
• Use data analysis skills to query data warehouse to design new reporting and analytic tools to identify opportunities.
• Create and Execute SSRS reports and tools capabilities.
• Developed methodology to enhance development time of ETL process.
• Assisted in logical and physical data modeling, dimensional modeling, performance tuning of SQL, ETL processes.
• Performed Tuning of the ETL programs to increase the processing and loading efficiency.
• Ensure the quality of deliverables in terms of the technical design, implementation, testing and adherence to technical compliance standards.

Environment: Informatica Power Center 9.6.1, PL/SQL, IBM Infosphere DataStage 8.5, IDQ 9.6.1, MS SQL Server, MS Access, Windows 2000, Autosys Scheduler.

ETL/ Informatica Developer

Confidential

Responsibilities:

• Extensively used Informatica Power center, Power Exchange for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router in Mappings.
• Designed basic UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Scheduled Sessions and Batches on the Informatica Server using Informatica workflow Manager.
• Migrate Informatica objects and Database objects to Integration Environment and schedule using the Autosys
• Monitoring the ETL jobs and fixing the Bugs
• Involved in doing Unit Testing, Integration Testing and System Testing.
• Identified and created various classes and objects for report development.

Environment: Informatica Power Center 9.6, Oracle 9i, XML, Flat files, SQL, PL/SQL, Windows, UNIX, Business Intelligence.

ETL / Informatica Developer

Confidential

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplets Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update Transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplets designer in Informatica Power Center 6.1.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Center 8.x, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.