SUMMARY

• 9+ years of experience in Analysis, Design, Development, Testing, Implementation and Production support (24*7) in DW/BI applications with Roles Tech Lead, Senior Informatica and SAP Business Objects Developer.
• Experience with ETL process using Informatica Power Center 9.x/8.x/7.x Power Exchange, Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor, SSIS, SAP BOBJ 4.1/4.0/BOXI R3.1/R2/6.5, Universe Design Tool & Information Design tool, Designer, Desktop Intelligence, Web Intelligence Rich Client, BI Launch pad, InfoView, Live Office, upgrade management tool, Central Management Console, Crystal Reports, Xcelsius, Dashboard.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema, Also have vast experience in slowly changing Dimensions and Meta data management. Good Understanding of Data Modeling concepts, Erwin - Forward & Reverse Engineering, Dimensional Data Modeling - Bill Inman, Kimball.
• Proficient inETL (Extract - Transform - Load)using SQL Server Integration Services (SSIS) and Informatica Power Center tool.
• Vast experience in Understanding Business Requirements, Technical Design, Estimation and Project Management activities, Also have experience in Reqpro and Rational Tools
• Extensive experience in Preparing Flow Charts, Analysis Reports, Technical Design documents, Profiling.
• Proficient experience in designing SQL’s using Teradata, DB2, PL/SQL and working with flat files.
• Experience in using Informatica to populate the data into Teradata DWH. Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD, Teradata Parallel Transporter (TPT)
• Experience in understanding Fact Tables, Dimension Tables, Summary Tables
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server and Worked on integrating data from XML files, flat files like fixed width and delimited.
• Created UNIX shell scripts to run the Informatica workflows, FTP and controlling the ETL flow. Have worked and User scheduling tools like WLM, Control M.
• Development and Reporting experience in Business Objects Designer and Desktop Intelligence.
• Expertise in Teradata query tuning (Reduce skews), Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks. Query Rewrite, tuning Mappings and Sessions.
• Have expertise in Industry’s best practices, Coding standards. Preparing User Manuals, Presentations, Bug Fixing, Troubleshooting, Root Cause analysis and Solution Development.
• Extensive experience with analysis, design, development, customizations and implementation of software applications related to Ezetrieve, COBOL and DB2.
• Agile delivery of software using practices from SCRUM
• Experience in Peer-reviewing the Codes Results Transformations and Performance as part of System Integration Test (SIT) and User acceptance Test ( UAT)
• Have good experience in Managing Team Offshore and Onshore to Coordinate Work.
• Good communication skills, documentation skill interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.6.1/8.1.1/7.1.2

Reporting Tools: Business Objects XI 3.1/r2, r1/6.x/5.x,Desktop Intelligence, Designer, Info view, Business Objects Reporting and SDK, Web-Intelligence 6.0/2.7/2.6/2.5 , Dashboards, BO Set Analyzer.

Database: Oracle, DB2, UDB, Teradata v 13/v12/v2r5.

Database GUI: Teradata SQL assistant, TOAD, SQL Developer, Mainframe DB2.

Programming Languages: PL/SQL, UNIX Shell Script, JCL, COBOL, Ezetrieve, VSAM

Operating Systems: UNIX, Windows NT/2000/XP/7, OS/390, ZOS (Mainframes)

Development Tools: Endeavor, File manager, DVO and debugger

PROFESSIONAL EXPERIENCE

Confidential, Strongsville, OHIO

Senior Informatica Developer/Business Objects Developer

Responsibilities:

• Worked with business analysts for business requirements, analysis and technical specifications.
• Worked on Informatica power centre tool - source analyzer, Target designer, mapping designer, mapplet designer and reusable transformations.
• Imported data from various sources (Mainframe GDG files, fixed width flat files) transformed and loaded into targets.
• Using Informatica designer, developed mappings which populated the data into the target.
• Developed mappings using Informatica Power Center Transformations - Lookup (Unconnected, Connected), Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Design and developed complex Informatica mappings including all slowly changing dimensions.
• Created reusable transformations, mapplets, and shortcuts for Sources and targets to use across various Mappings.
• Worked extensively on TOAD to analyze data and fix errors and develop.
• Used parameters and variables at mapping and session levels to improve the performance and mappings.
• Involved in fixing in-valid mappings and testing of the PL/SQL stored procedures and the target data.
• Development, unit testing and migration in ETL Tool Informatica.
• Used SQL tools TOAD to run SQL queries and validate the data in warehouse.
• Created Shared folders, users and managed the privileges to users using Informatica Repository Manager.
• Created shell scripts using Informatica PMCMD command.
• Configured the sessions using workflow manager to have multiple partitions on Source data to improve the performance.
• Unit to check whether the data testing, User Acceptance Testing loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power center 9.6.1, Informatica Designer, Repository Manager, Workflow Manager, Informatica Data Quality (IDQ), Mainframe gdg files, Flat Files, XML, UNIX, Oracle 11g, DVO, DB2, SQL server, Teradata 12, SQL Server 2005, TOAD, PL/SQL, Control M and Windows XP.

Confidential, Madison, WI

Senior Informatica Developer/Business Objects Developer

Responsibilities:

• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Interacted with Business Users and Managers in gathering business requirements.
• Involved in the designing and Building of Universes, Classes and objects
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Customized Universe level Prompts as per Functional Requirements.
• Check the integrity of the Universes, and export the universes to Repository for making available to users
• The project involved in the development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.
• Created Standard Reports utilizing all the features on Web Intelligence in BO 3.1 like Optional Prompts, Functions, and Alerters etc.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked with formatting the reports according to the user requirements.

Environment: SAP Business Objects 3.1, Informatica 9.1, Oracle 11g, BO Universe Designer, Info View, Web Intelligence, DVO, DB2 and SQL server.

Confidential, Albany, NY

Senior Informatica Developer/Business Objects Developer

Responsibilities:

• Involved in Business Users Meetings, JAD sessions to understand client requirements.
• Transform the Business requirements into Technical requirements.
• Worked with Billions of Data as Enterprise Warehouse house Data for 14 States.
• Have prepared Project Plans, Estimates based on the Work effort and the Complexities.
• Develop Optimum Design and Conduct Design Review meetings with Architects for the Technical requirements and obtain their Design approval
• Transform the Design into Flow Charts, Workflows and Explain that to the Developers.
• Worked on Heterogeneous Source and Target Systems for Movement of Data
• Worked with FTP Teams and Vendor to establish the connectivity and the Transmission Protocols.
• Peer reviewed each Design and given suggestion for an Optimum design and Code based on Performance and Coding standards
• Designed SSIS Packages using several transformations to perform Dataprofiling, DataCleansingand Data Transformation.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica
• Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored
• Procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source
• Qualifiers and data flow management into multiple targets using Routers were extensively done.
• Worked on profiling the Data, Analyzing the Join conditions, Development of Mappings and write the Informatica code & UNIX scripts.
• Worked on code merge between two different development teams.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Wrote codes in Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process. Also wrote codes in FTP scripts and Post Process Scripts for Data Validation.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Created SSISJobsand scheduled Packages usingSQL Server Management Studiofor the Daily Load.
• Designing SSIS Packages using several transformations to perform Dataprofiling, DataCleansingand Data Transformation.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Coded BTEQ Teradata scripts to extract Data and Send it to the Vendor.
• Effectively worked on Onsite and Offshore work model. Conducted Project Health and Status meeting using SCRUM calls.
• Created and scheduled Sessions for different Job setups like on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Extensively worked with Scheduling Teams to setup the Job flows and Processes.
• Developed implementation and test plans, built software acceptance criteria, coordinated and worked with clients to oversee the acceptance and dissemination process.
• Performed Unit, Integration, System testing of Informatica mappings and Workflows.
• Created Test plans and Test cases and discussed with the Stakeholders for the things in scope and documented them in the rational tools.
• Performed analysis, design, develop, testing and Maintenance of UDT Universes.
• Creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Extensively used Calculations, Break points, Drill down, @Functions and Formulas, Filters and Alerts for creating Complex Web intelligence reports.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Developed complex reports inCrystalReports from data sources like Universes.
• Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decode functions, using Crystal reports.
• Developed Dashboards with Dashboard Design components using maps, Pie Charts, Staked Bar, List Views etc. creatively using best dash board components effects for better interaction.
• Used Dashboard to Visualize and to enhance the data presentation along with developing dynamic charts and graphics on top of Universe.
• Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems.

Environment: Informatica Power Center 9.5 Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor, SAP Business Objects 4.0(UDT,BI Launch Pad,CMC),Crystal reports, Dashboard Design Oracle 11g, Teradata V 13.0, SSIS, Fast load, Multiload, Teradata SQL Assistant, MS SQL Server 2012, SQL, PL/SQL, T-SQL, Unix, Cognos, Tidal.

Confidential, VA

Senior Informatica Developer/Senior Business Objects Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of Enterprise Data warehouse.
• Involved in ETL design and development for extracting data from the heterogeneous source systems Like DB2, UDB, MS SQL Server, Oracle, flat files, XML files and loading into Staging and Teradata Data Ware House
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Warehouse for reporting.
• Developed the logic for handling slowly changing dimension (Type1 and Type 2) table’s load by Flagging the record using update strategy for populating the desired. Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Design and Development of ETL routines within the Informatica Mappings, usage of Lookups, Aggregator, XML, Ranking, Mapplets, connected and unconnected lookup’s, stored Procedures / functions
• Configured workflows with Email Task, which would send mail with session, log for Failure of a Sessions and for Target Failed Rows.
• Build efficientSSIS packagesfor processingfactanddimensiontables with complex transforms and type 1 and type 2 changes.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
• Build tables, views, UPI, NUPI, USI and NUSI.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Extensively used Calculations, Break points, Drill down, @Functions and Formulas, Filters and Alerts for creating Complex Web intelligence reports.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Developed complex reports inCrystalReports from data sources like Universes.
• Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decode functions, using Crystal reports.
• Developed Dashboards with Dashboard Design components using maps, Pie Charts, Staked Bar, List Views etc. creatively using best dash board components effects for better interaction.
• Used Dashboard to Visualize and to enhance the data presentation along with developing dynamic charts and graphics on top of Universe.
• Provided Production Support.

Environment: Informatica Power Center 9.5 Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor, SAP Business Objects 4.0(UDT,BI Launch Pad,CMC),Crystal reports, Dashboard Design Oracle 11g, Teradata V 13.0, Fast load, Multiload, Teradata SQL Assistant, MS SQL Server 2012, SQL, PL/SQL, T-SQL, Unix.