PROFESSIONAL SUMMARY:

• Overall 6 years of experience in IT and in multiple technologies especially Informatica, Tibco Spotfire5.5/4.0 and Oracle.
• Good working Experience in Software Development Life Cycle (SDLC) methodologies like Waterfall and Agile.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.
• Expert in ETL methodologies, Informatica data quality(IDQ), Informatica 8.x/9.x - Power Center, Client tools - Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager and power exchange.
• Strong experience in CDC Change data capture from mainframe IMS database and Z/OS DB2 using Informatica Power Exchange
• Expertise in Data Warehousing, Data Migration, Data Modeling, and Data Cleansing.
• Expert in Extracting, Transforming and Loading ( ETL ) data using Informatica; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Experience on Data modeling, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & DIMENSIONS tables, Physical & Logical data modeling and Oracle Designer.
• Data Analysis strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Developed several mappings in Informatica by using the transformations like Unconnected and Connected lookups, Source Qualifier, Expression, Router, Filter, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Rank, Sorter, Normalizer, Transaction Control etc.
• Experience in implementing Data Warehousing Applications using Informatica Power Center / Power Mart for designing and developing transformations, mappings, sessions, and for scheduling and configuring workflows.
• Developed Workflows, Worklets and Tasks by using Power Center Workflow Designer.
• Scheduled and monitored automated weekly jobs under UNIX environment.
• Designed and developed interactive data visualizations to give them consistent and professional looks using TIBCO Spotfire Professional.
• Experience in writing JCLs, COBOL programs, working on mainframe fixed length, variable length datasets and creating copybooks
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using Data Driven subscriptions.
• Excellent capability to explore, learn and understand newer business domains and technologies.
• Experienced in environments requiring direct Customer interaction during specifications, development and project implementation phases.
• Adept to delivering high-quality solutions, ensuring the client investment in technology is consistent with their business objectives.

TECHNICAL SKILLS:

ETL tools: Informatica Power Center 9.x/ 8.x/7.x/6.x (Informatica Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Work flow Monitor), Informatica Power Exchange, OLTP, OLAP.

Reporting Tools: TIBCO Spotfire,Cognos,OBIEE

Databases: MySQL, Oracle 9i/10g/11g,MS-Access

Programming Languages: C, C++, Core Java, SQL,Unix Shell Scripting,COBOL

Web Design: HTML, CSS3,JavaScript,XML

Operating Systems: Windows 98/NT/2000/XP/Vista/7/8, UNIX, LINUX, Mac OS

Other Relevant Tools: MS Office(MS-Excel, MS-PowerPoint, MS-Project 2013), Visual Studio 2013

PROFESSIONAL EXPERIENCE:

Informatica ETL Developer

Confidential - Bridgewater, NJ

Responsibilities:

• Involved in development of numerous mappings using Informatica Powercenter based on client requirement.
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target.
• Extracted data from various sources like Oracle, SQL Server, Flat Files and loaded to EDW (Oracle).
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Created complex reusable transformations and mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respective
• Implemented SCD Type 1 and SCD Type 2 mappings to update slowly Changing Dimension Tables.
• Responsible for taking ownership of tickets, and tracking all assigned tickets to development and migration completion
• Monitor jobs using Informatica Workflow Monitor to ensure successful completion of loads.
• Worked closely with reporting team and generated reports using Spotfire
• Modify and optimize current mappings for efficient data loads
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Involved in the Unit Testing and Integration testing of the workflows developed.
• Performed Business Analyst role interfacing with SME's to understand and define the functional and information requirements and documenting these in the Business Requirements Document (BRD).
• Involved with the users in the creation of test scripts for the user acceptance testing.

Informatica Developer

Confidential - Southfield, MI

Responsibilities:

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Created Design Specification Documents including source to target mappings.
• Extracted data from various source systems like Oracle, XML and flat files and loaded into relational data warehouse and flat files.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Captured the DQ metrics using the Profiles and Created scorecards to review data quality using IDQ.
• Assisted in troubleshooting the Production support problems, which are related with IDQ.
• Created IDQ transformations to convert data from pdf to xml.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and also helped to resolve various data issues.
• Maintained a very good interaction with analysts, Project Managers, architects and testers to have efficient and better results.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse.
• Provided 24x7 production supports for business users and documented problems and solutions for running the workflows.

Informatica Developer

Confidential - Boston, MA

Responsibilities:

• Frequent interaction with the expert user and team for understanding business requirements and to resolve issues related to Quality ETL Jobs.
• Daily interaction with business SME's to understand the requirement completely during the requirem-ent phase.
• Involved in integrating Gensuite and GL (finance) Data with Jaros Data warehouse through Informatica application. Involved in enhancing requirements as per User request.
• Developed Mappings, workflow sessions for the three Cognos dashboards QMS Audit Dashboard, RCA NCA Dashboard and CoQ Dashboard using Informatica Application.
• Develop mappings and workflows as per provided requirements.
• Test those mappings and prepare test cases, also ask for peer review and create doc for same.
• Involved in performing Unit Testing and Sanity checks of Jobs.
• Involved in Deployment activities after successful completion of UAT.
• Send daily updates to customer.

Senior Software Engineer

Confidential

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
• Involved in loading the data from Source Tables to ODS (Operational Data Source) and XML files using Transformation and Cleansing Logic using Informatica.
• Wrote JCLs for formatting and generating mainframe Flat file GDG version
• Unit Testing using mock data for different test scenarios
• Provided data loads for QA testing and worked on resolving the defects
• Involved in Bug Fixing for Test Defects
• Worked with code migration team for promoting codebase to QA, UAT and production deployment
• Scheduled Workflows using TWS Tivoli Workload Scheduler
• Scheduled mainframe jobs using JOBTRAC scheduler

Software Engineer

Confidential

Responsibilities:

• Analyzing the requirement by working closely with onsite Business Analyst
• Involving in the calls with the end user understand the complicated requirements better
• Prepare the project design documents and have a walk through with Business team to make them understand the functionality of the project.
• Review the code developed by offshore to make sure it's working as per the requirement
• Providing requirement to ETL team for the report tables needed if applicable.
• Developing the report in Spotfire
• Creating the high-level design document
• Hands on experience in administering, deploying, and maintaining Models, Reports
• Utilized features such as multiple tables, visualizations, drill down and other analytics reporting and analysis tools to deliver business insights.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Worked on the trouble shooting the code to improve the performance
• Excellent analytical and problem-solving skills to Resolves in-depth queries in a methodical manner independently to find appropriate resolutions.
• Validating the report against the source report
• Working on the bugs and finding the root cause
• Migrating the reports to various environment
• Refreshing the metrics which are not automated with the latest data
• Creating the refresh documents.