SUMMARY

• Over 8 years of experience in Analysis, Design, Development, Testing and Maintenance of Data warehouse and Business Intelligence implementations in Entertainment, Manufacturing and Healthcare Industries..
• Over 6 years of experience in data warehouse design and development using ETL tools like Informatica Power Center and Informatica Power Exchange.
• Over 2 years of experience in Business Intelligence reporting using Cognos 8.x, Framework Manager, Power play Transformer.
• Good knowledge on data warehouse methodologies Ralph Kimball, Bill Inmon , ODS, EDW.
• Good Understanding in RDBMS concepts and Data modelling concepts like Star/Snowflake schema, Dimension tables and Fact tables.
• Thorough understanding of system development life cycle SDLC experience from requirement analysis through design and development using modern programming languages.
• Experience in Data analysis, Data cleansing, Data transformation and relationships.
• Good experience working on various databases like Oracle, MS SQL Server, IBM DB2 UDB, Teradata and Sybase.
• Extensively worked on Informatica Power Center: Repository Manager, Workflow Manager, Mapping Designer and Workflow Monitor.
• Build ETL's based on Performance, Simplicity, Support and Reusability.
• Experience in UNIX shell scripts for automation.
• Automation and scheduling ETL jobs using Informatica and job schedulers.
• Experience in performance tuning techniques, data reconciliation and debugging complex ETL's.
• Developed and Published Packages using Framework Manager against relational model and dimensional models.
• Developed Multi-dimensional Cubes for corporate data using Impromptu Query Definition and other data sources in Power play Transformer.
• Extensively worked on Cognos Report Studio 8.x and created Dashboards and complex reports using Cognos Report Studio.
• Good experience working as a lead on Onsite Offshore development model.
• Team Player and well able to work independently with minimum supervision.
• Innovative, efficient and strong desire to keep pace with latest technologies.
• Exceptional verbal and written communication skills with ability to interact with individuals at all levels.
• Learning Knowledge on Big data and Hadoop.

TECHINICAL SKILLS

• ETL Tools: Informatica Power Center 7.2, 8.1, 8.6, 9.1, Informatica Power Exchange, Cognos8 Data Manager
• BI Tools: Cognos BI 10, Cognos BI 8.2/8.3/8.4, Power Play Transformer 7.1/7.0/6.0,
• Databases: Oracle 10g/9.x/8.x, MS SQL Server 2000/7.0/6.5 2005, DB2 UDB, TeradataV2 R5/R4, Sybase 11/14, MS Access
• Languages: SQL, PL/SQL
• Operating Systems: Windows 2000/ NT/ 98/ 95, MS-DOS, Red Hat LINUX, UNIX, Solaris 2002

EXPERIENCE

Confidential

ETL Consultant

Responsibilities:

• Provide production support for all existing applications.
• Monitory daily, weekly job loads and fix any errors.
• Data reconciliation between the warehouse and the data mart.
• Performance tuning of existing ETL's and stream line the existing process.
• Discuss with the users to understand the business changes.
• Provide impact analysis and level of effort on any existing issues and process upgrades.
• Fix existing bugs and enhance the existing code as per the new business needs.
• ETL code migration between environments.
• Maintain support activities.
• Informatica 9.5 migration from Windows environment to Linux environment.

Environment:

Informatica 9.5, IBM DB2 9.5, Linux, MS windows 2003, MS SharePoint, JIRA, HP service center and ALM Quality Center.

Confidential

ETL Consultant

Responsibilities:

• Analyze the business requirement and prepare the design document.
• Provide ETL estimates to the business.
• Prepared technical design document with mapping and transformation rules for data load process.
• Build ETL's based on performance, support and complexity.
• Created batch scripts to FTP files to UNIX server.
• Automate ETL using Informatica Scheduler.
• Unit Test and Automate the ETL loads.
• Document the technical design specification.
• Created a production support run book for all the ETL process.

Environment:

Informatica 9.5, DB2 9.5, UNIX, Share point, JIRA, HP service center.

Confidential

ETL Tech Lead

Oracle DB object migration from R10 to R11.

Responsibilities:

• Analyze the existing environment, document the changes and process required for DB migration project.
• Discuss with the BSA and prepare the required technical documentation.
• Provide work estimates to BSA onsite, plan with the team and work accordingly.
• Explain the steps involved and provide daily tasks to the developers.
• Provide test execution guide lines to the testing team.
• Conduct status calls with the team to discuss the issues and track progress.
• Review the ETL code and check for standards.
• Capture the data dictionary tables and check for changes in the table structure.
• Test for the data between R10 and R11 environments.
• Update the existing ETL mappings in Cognos data manager to make sure they run successfully.
• Capture and test the data for each ETL before the migration changes and after the migration changes.
• Update Cognos Framework manager models and publish the packages onto Cognos connection.
• Validate and Test Cognos reports.

Environment:

Cognos 8 Data Manager, Cognos 10 BI Suite, Oracle 11G, Noetix, UNIX.

Confidential

ETL Lead

The Common Marketing Fund CMF is a percentage of amounts that is allocated for every contract. This amount is not actual revenue and should not be calculated as revenue for sales royalties. However, this data should be populated as transactions to keep a track of the contracts for CMF.

Responsibilities:

• Involved in business gathering meetings to understand the business, analyze the requirements and source data.
• Coordinate with business system analyst, QA team lead and project manager
• Documented the business requirements and prepared the functional document.
• Prepared the technical design document which included mapping and transformation rules to extract transform and load data into the data mart.
• Provide ETL estimates to the business.
• Build ETL's based on performance, support and complexity.
• Involved in design reviews, architecture discussions, and infrastructure reviews.
• Reviewed ETL code for standards and best practices.
• Work closely with the four offshore developers in providing them requirements and assigning tasks.
• Reviewed test cases with the client team and provide sign off.
• Provided knowledge transfer to the production support team.
• Wrote Unix shell scripts for advanced functionality and automation of the workflows.

Environment:

Informatica 9, DB2 Version,9.5, Micro strategy, Oracle 10g, SQL Server 2005,Sybase, windows 2003 server, Unix., AIX 5.3, Erwin 4.0, MS Project, MS Visio, Maestro, JIRA and HP service center.

Confidential

ETL Consultant

Worked on multiple Enterprise Planning implementations for the entertainment giant WALT DISNEY. The project was is to integrate the forecast data that was planned using Cognos EP and Actuals Data from SAP tables. Informatica was used to integrate data from these two sources and populate in a data mart for reporting purposes and further planning analysis.

Responsibilities:

• Involved in business gathering meetings to understand the business, analyze the requirements and source data.
• Documented the business requirements and prepared the functional document.
• Prepared the technical design document which included mapping and transformation rules to extract transform and load data into the data mart.
• Provide ETL estimates to the business.
• Build ETL's based on performance, support and complexity.
• Involved in design reviews, architecture discussions, and infrastructure reviews.
• Reviewed ETL code for standards and best practices.
• Worked on Informatica upgrade project from 8.1 to 8.6.
• Worked closely with the team to explain the Business, Requirements and the design process.
• Provided Knowledge transfer on the Production support processes.
• Documented the Production support frequent issues and the process to resolve it.
• Organized daily status call with the team onsite and offshore developers.
• Implemented currency conversion logics on the ETL have to store transaction, local and group currencies.
• Extensively Used Informatica Powercenter to extract plan data from the Cognos planning models and Actuals data from FDM data mart to load into IBM DB2 Data mart.
• Used Informatica Power Exchange to load actuals from SAP source systems.
• Worked on production support, bug fixes, enhancements, review the design on both Reporting and ETL issues.
• Wrote UNIX shell scripts for advanced functionality and automation of the workflows.
• Used Informatica scheduling and Maestro scheduling Tool for automation.
• Created and scheduled Workflows based on demand, run on time and run only once using Workflow Manager.
• Working knowledge on Cognos Planning and Cognos TM1
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment:

Informatica 8.6.1/8.6.5,Cognos 8.4 BI suite, Cognos Planning, IBM DB2 9.5, Oracle10g, Teradata, Micro strategy, windows 2003 server, Linux, MS Office, Visio.

Confidential

BI Developer

The project is to build Dashboards with drill through capability from the main report to all the detail level reports. The data has their employee information, Best place to work, Attendance, services provided etc. On the basis of the requirement from the user, the data is gathered, organized and the final reports are created for the end users.

Responsibilities:

• Interact with the business users and documented the requirements and reporting needs.
• Analyze the requirements and provide reporting estimates.
• Participated in design reviews, architecture discussions, and infrastructure reviews.
• Production support and bug fixes on the existing ETL code.
• Enhancements and performance tuning.
• Designed models using Framework Manager and deployed packages to the Cognos 8 server.
• Designed Multidimensional Model and Relational Models in Framework Manager.
• Created OLAP cubes using Power Play Transformer against various data sources like Oracle, DB2, and Teradata Flat Files.
• Created Dashboards and reports with advanced functionalities like drill down, drill through, report bursting etc.
• Migration of ETL objects from one Environment to the other.
• Informatica Power Center is used to extract the base tables in the data warehouse and the source databases include PeopleSoft EPM, Oracle, DB2, Teradata, Flat files, MS Access.

Environment:

Cognos 8.2/8.3/8.4, Framework Manager, Transformer, Cognos BI Tools, Cognos Go Office, Oracle10g, DB2/UDB, Teradata, Toad, Informatica, Data Stage, windows 2003 server.