SUMMARY:

• Over 9 years of IT industry experience in Healthcare, Insurance, Banking and Retail Business domains.
• Experienced working in Agile and Waterfall methodologies.
• Analysis, design, development, testing and deployment of mission critical software applications using Informatica, IBM DB2, Oracle, Microsoft Sql server, Tableau and SAP Business Objects
• Involved in functional and technical system analysis & Design, System Architectural design, Presentation, process data flow design, system impact analysis, Gap analysis and documentation.
• Extensive experience in Data warehousing, Data Analysis, Meta - data management, Data quality, Data Modeling, ETL tools and Reporting.
• Proficiently rendered services in Informatica 10.1.1/9.6.1/9.1/8.6 (Power Center, Power Exchange, Cloud and Data Quality), Oracle 11g/10g/9i/8i, Microsoft SSIS and SSRS.
• Hand’s on experience in creating complex Informatica mappings, transformation logic, sessions and workflows to extract data from various sources and load into targets and proficient in creating mapplets and worklets.
• Expertise in Database development skills using SQL, PL/SQL, stored procedures, functions, packages, and triggers.
• Proficient using IBM Data studio, TOAD, Sql Developer for system testing of the reports.
• Expertise in deriving Analytical, Logical, Physical, Dimensional and Statistical Data Models.
• Good knowledge of Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling using Erwin tool.
• Experienced in Developing Unix Shell Scripts and scheduling Shell scripts by using scheduling tools Control-M & Autosys.
• Involved in Unit testing, User acceptance testing, Integration testing, Performance testing and Production support.
• Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Excellent verbal and written communication skills, strong time management skills
• Strong skills on analyzing requirements & technical issues, and then designing technical solutions.
• Experienced with on/off-shore model and also have the ability to manage time efficiently and effectively, prioritizing efforts to handle multiple activities in parallel.

TECHNICAL SKILLS:

Operating Systems: AIX/Unix, GNU/Linux, Windows 10/8/7/Vista/XP/2000/98

RDBMS: Teradata, DB2 UDB, Oracle 11g/10g/9i/8i/, SQL Server, My SQL

Languages: UNIX, Pearl, Shell Scripting (Bourne, Korn), TSQL, SQL, PL/SQL, HTML, C++, C#, VB.NET, ASP.NET

Tools: IBM Data studio, Putty, MS-office & Visio, SharePoint, TOAD 8.5/9.0, Erwin, Control-M & Autosys, Visual studio 2013/08/05, Oracle Golden gate 11g/10g

ETL Tools: Informatica 10.1.1/9.6.1/9.1/8.6, OWB 10gR1/11gR2, MS-SSIS 2012/08r2

Reporting Tools: Tableau, SAP-Business Objects XI 3.1, Cognos, OBIEE 11.1/10.x, MS-SSRS 2012/08r2

PROFESSIONAL EXPERIENCE:

Confidential, PA

DW/ETL Informatica Developer

Responsibilities:

• Gathering the requirements by coordinating with the users, effort estimation, preparation of project timelines & design for ETL & reporting modules.
• Identification of source systems to data warehouse by coordinating with respective source teams.
• Analyzed the existing operational sources and involved in development of the conceptual, logical and physical data models for the newly built data warehouse.
• Identification of dimensions and measures per business needs and prepare the design of dimensions and facts in star schema model using ERWIN tool.
• Design walkthrough with team and made changes where required and got user sign-off approvals.
• Development of Informatica mappings to load DW tables and dimension and fact tables.
• Developed ETL objects for data warehousing purpose in local database and migrated into QA environment for testing purposes.
• Used workflows to schedule the ETL processes to run at periodic intervals for various period close operations.
• Developing Unix shell scripts to perform pre & post load activities and execution of parent and child ETL process cycles using PMCMD utility.
• Enhanced workflow performance by creating indexes, views, altering the cache sizes and maintained Informatica logs where required and also did Performance Tuning for better performance on SQL and Informatica side.
• Performed unit, system & end-to-end testing. Documented processing times for each module, developed test cases and used them to run through each process. Implemented and day-to-day supported the BI environment and mentoring to end users who are interacting with the data.
• Understanding the reporting requirements of users and design the Data Source and reporting layers.
• Assisted with Cognos reporting team to generate the reports for business users need.
• Guided reporting team on building, publishing interactive reports and dashboards, report scheduling using Tableau server.

Environment: Informatica 10.1.1, Oracle 11gR2, Erwin, Tableau and Cognos BI tool.

Confidential, MI

Senior Lead Informatica Developer

Responsibilities:

• Gap Analysis on the existing legacy system and other relational source systems.
• Did data profiling on the source system to confine and streamline the business requirements for ETL and reporting components.
• Involved in creation of data marts for design of Star schemas for Data warehouse.
• Coordinated with project manager to document the project planning and also bi-weekly updates.
• Daily status meetings with teams and provided guidance and mentoring in technical areas to the team of Developer/Analysts and then document and submit status reports to leadership.
• Coordinated with Business Analyst and prepared Table and column level Business/Transformation rules documents (STTM).
• Developed the several ETL processes, and created the Informatica mappings, workflows, sessions etc, and also tuned them for better performance.
• Enforcing coding best practices like naming conventions and Error Handling.
• Performance tuning of ETL code through session partitioning, incremental aggregation and push down optimization techniques.
• Database query cost analysis to identify the performance bottlenecks and fine tune the SQLs to achieve better performance
• Developing reusable code modules (ETL, Unix and database) for performing Audit, Balance and Control for any data that loads into EDBI warehouse & datamarts.
• Developed UNIX script to perform operations by bringing down the source files from a legacy mainframe source to the respective UNIX source directory, trigger necessary Informatica workflows, archiving the files and updating the necessary log files on the operations performed.
• Developed ETL objects for data warehousing purpose in local database and migrated into QA environment for testing purposes.
• Prepared test cases, test scripts & test data. UAT coordination with business and defect tracking using Quality Center tool. Defect fixes, support and follow up on necessary approvals for production deployment.
• Pre-production walk though and preparation of project artifacts such as Requirements Traceability Matrix, Low Level Design, High Level Design, Unit Test Results etc. involved at all phases of SDLC.
• Guiding team members, performing code reviews, mentoring new members and bringing them up to speed per the project needs.

Environment: DB2, Informatica 9.6.1, Guidware, UNIX, TOAD for DB2, Flat file and XML Sources.

Confidential, CA

Lead Informatica Developer

Responsibilities:

• Involved in the Design, Development, Testing phases of ETL process for Auto and home policy data marts.
• Design of end user reports using SAP Business Objects which will be replacing the legacy based system reports
• Generating the reports from data warehouse and data marts and making them balanced against the reports from source systems.
• Close co-ordination with business users to analyze and elicit the requirements for building reports.
• Data profiling to confine and streamline the business requirements for generating the end reports.
• Following the PDLC process to move the code across the environments though proper approvals and source control environments.
• Develop the audit, balance and control process which will enable the control on history of ETL job statistics.
• Analysis on the existing legacy system to correlate it in Informatica based solution.
• Requirements gathering form business team and data profiling as per the same.
• Effort estimations& schedule planning for the given requirements
• Design the ETL process.
• Developing, Unit testing
• System testing and migration support
• Code defect fixes, support and follow up on system testing approval and client approvals on UAT.
• Preparing and reviewing deployment documents and support of production migration
• and testing.

Environment: DB2, Informatica 9.1, SAP BO, UNIX, TOAD, Flat file and XML Sources.

Confidential, CA

ETL / Informatica Developer

Responsibilities:

• Analyzed the existing operational data sources and involved in development of the logical and physical data models for the newly built data warehouse.
• Developed initial ETL (Informatica) objects in local repository folders, while using the shared objects for sources, targets and transformations.
• Involved in creation of data marts for design of Star schemas for Data warehouse application.
• Created several database objects like views, indexes, procedures etc., to resolve the performance issues.
• Developed the several ETL processes, and created the Informatica mappings, workflows, sessions etc, and also tuned them for better performance.
• Used stored procedures, functions, cursors etc. to load data from different sources i.e., ‘Infinity controlled’ to target area called ‘Finance Area - controlled’ databases.
• Developed ETL objects for data warehousing purpose in local database and migrated into QA environment for testing purposes.
• Assisted with reporting team to generate the reports for business users need.
• Used workflows to schedule the ETL processes to run at periodic intervals for various period close operations.
• Developed UNIX script to perform operations by bringing down the source files from a staging area (Infinity) to the respective UNIX source directory, trigger necessary Informatica workflows, archiving the files and updating the necessary log files on the operations performed.
• Prepared test cases, test scripts & test data.
• Did code walkthrough of all the designs with team and made changes where required.
• Coordinated with project manager to document the project planning, scheduling and also bi-weekly updates.
• Enhanced workflow performance by creating indexes, views, altering the cache sizes and maintained Informatica logs where required.
• Used Power Analyzer to generate data profiling reports & to monitor data quality during production run.
• Performed unit, system & end-to-end testing. Documented processing times for each module, developed test cases and used them to run through each process. Implemented and supported the BI environment and User Interface.
• Participated in and made presentations to the higher management on the developments made.

Environment: Oracle 10g/9i, Informatica 8.6, Business Objects, PL/SQL, ERWin, TOAD and HP Unix

Confidential, CA

ETL Developer

Responsibilities:

• Interacted with the investment brokers, advisors, analysts and account executives and understood the business requirements by analyzing and defining key issues related to the earlier work system.
• Involved in the design, data modeling, development and testing phases of various projects and enhancements.
• Analysis, requirements gathering, functional/technical specification, develop-ment, deploying and testing.
• Logical & Physical Database Layout Design. Created Informatica mappings for initial load and daily updates.
• Created Informatica mappings for initial load and daily updates.
• Developed mapplets and worklets.
• Generated flat files using Informatica power center and extracted XML and Flatfile Designed reusable transformations and shortcuts to share different mappings.
• Implemented Slowly Changing dimension Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Developed, tested procedures, Functions and packages in PL/SQL for Data ETL
• Generated Reports using Metadata Reporter
• Day-to-Day Production support.
• Involved in fixing, testing of store procedures and functions, unit and integration testing of Stored Procedures and the target data.
• Developing Unix shell scripts and scheduling Unix Scripts by using scheduling tools.
• Worked with end users to develop and collect feedbacks in the User Acceptance Testing (UAT)
• Involved in Production Deployment and Support.

Environment: Oracle 9i, Informatica 8.1, PL/SQL, ERWin, TOAD, XML and Flat file Source Data and HP UNIX, AIX

Confidential

Unix Consultant

Responsibilities:

• Developing Perl scripts for automating the scheduled backup process for all the programs and web pages those saved over sever.
• Creating of shell scripts to automate the user creation setup for the list of programmers in the organization.
• Scripts for automated monitoring and alter setup for disk overload and CPU overload on the server.
• Installation of apache web server on Ubuntu GNU/Linux server.
• Hardware and network setups for the Unix servers with the local area network.
• Setup of required programming platforms for users on the GNU/Linux servers.
• Understanding the requirements as per the business and technical need
• Developing the code and testing the same for meeting the requirement
• Handling maintenance and support for the production environment
• Guiding new trainees on the maintaining the environment

Environnent: PERL, GNU/Linux, UNIX, Shell Scripting (Bourne, Korn)