EXPERIENCE SUMMARY

• Around 10 years of IT experience in requirement capturing, business analysis, solution design, systems analysis, design development and support of full life cycle in Data Warehousing and Data Migration projects.
• Strong technical skills including Informatica Power Center, IDP, IDQ, Informatica Administration, Informatica Upgradation, OWB ODI, Talend 5.1, Oracle Discoverer, Oracle 10g, Teradata and OBIEE.
• Firm ability to research, analyze and translate complex business and technical information to stakeholders, SMEs, and developers at all levels of the organization.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 7/8/9.
• Experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in data Requirement Analysis and Data Mapping for ETL processes.
• Well versed with Kimball/Inmon methodologies.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in database programming in PL/SQL Stored Procedures, Triggers and Packages .
• Well versed in UNIX shell scripting.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SUMMARY

Professional Experience Summary

Confidential

Oracle Developer

Responsibilities:

• Develop ETL scripts with Informatica in order to build data integration between applications
• Create and execute unit, functional and integrated testing
• Performance tuned all the sessions to run faster within the allowed time window by using pushing major aggregations to backend database, using filters/routers at appropiate places, persistant caches, cache partitions, pipeline partitions, sql overrides with oracle analytical funtions etc.
• Optimize performance requests and Write all technical documentation
• Work closely in collaboration with the client team in order to reinforce the business partnership.
• Collaborate with the Application SME's to design and develop required ETL processes, Shell scripts, performance tune ETL programs/scripts.
• Maintain and enhance ETL code, work with the QA and DBA team to fix performance issues.
• Develop coding standards and guidelines document for the team.
• Study and review the Functional Requirements, Design documents or any other documents provided by the client and provide feedbacks to Technical Architect/Distinguished Technical Architect.
• Participate in project lifecycle activities including quality reviews for development, unit testing, testing and release.
• Identify and highlight risks to Technical Architect/Distinguished Technical Architect and suggest corrective actions.

Environment: Oracle 11g, Informatica Power Center 9.1.0, LINUX, IBM Connect Direct, OSS BSS Application

Confidential

Responsibilities:

• Develop ETL scripts with Informatica in order to build the data warehouse DW
• Create and execute unit, functional and integrated testing
• Performance tuned all the sessions to run faster within the allowed time window by using pushing major aggregations to backend database, using filters/routers at appropiate places, persistant caches, cache partitions, pipeline partitions, sql overrides with oracle analytical funtions etc.
• Optimize performance requests and Write all technical documentation
• Work closely in collaboration with the client team in order to reinforce the business partnership.
• Collaborate with the Data Warehouse team to design and develop required ETL processes, performance tune ETL programs/scripts.
• Maintain and enhance ETL code, work with the QA and DBA team to fix performance issues.
• Develop coding standards and guidelines document for the team.
• Study and review the Functional Requirements, Design documents or any other documents provided by the client and provide feedbacks to Technical Architect/Distinguished Technical Architect.
• Participate in project lifecycle activities including quality reviews for development, unit testing, testing and release.
• Identify and highlight risks to Technical Architect/Distinguished Technical Architect and suggest corrective actions.

Environment: Oracle 11g, Oracle Apps R11, Informatica Power Center 9.0.1, Cognos, LINUX

Confidential

Responsibilities:

• Involved in Requirements gathering, Reverse engineering the existing databases to derive data models and Dimensional modelling, Data mapping and data migration efforts from various legacy systems to the new REMEDY system, interacting with the business users/stakeholders/SMEs
• Design and devolop ETL process for loading data from multiple individual team/client systems to global data warehousing system for enterprise wide reporting and also data marts for individual clients for their reporting for OLAP reporting.
• Discuss the business requirements with end users and transform the requirements to Dashboard reports. Convert existing manual process to automated dashboard reports using DW architecture
• Performance tuned all the sessions to run faster within the allowed time window by using pushing major aggregations to backend database, using filters/routers at appropiate places, persistant caches, cache partitions, pipeline partitions, sql overrides with oracle analytical funtions etc.
• Providing technical solutions, coding, testing, UAT support, and documentation required for completing the project.
• Coordinate with other development teams to do an impact and risk analysis.
• Experience in OBIEE in Application Development using Analytics Web Components like answers, dashboards and Administration.
• Experience in designing and developing repositories .rpd in Subject Areas
• Innovative in Approach, quick learning new methods and ideas and putting them into daily practice

Environment: Oracle 10g, Informatica Power Center 9.1.0, OBIEE, Remedy COTS, UNIX

Confidential

Responsibilities:

• Involved in Design of ETL Architecture and Dimension Model. Design and develop the ETL mappings using Informatica 8.6 and Jobs using Talend 5.1
• Involved in Talend tool evaluation for the global implementation of all Data Quality and Integration projects
• Discuss the business requirements with end users and transform the requirements to Dashboard reports. Convert existing manual process to automated using applications architecture
• Extensively used talend components in the area of Data Quality Treplacelist component, tschemacompliancecheck and Databases - Toracleinput, toracleoutput, toraclebulk/bulkexec etc
• Invoked the execution process of the talend file input, management and outputs componets
• Analyzing the source system schemas which are in Remedy Apps and designing dimensional star and snowflake schemas
• Manage client expectations with the quality of the data not compromising on user friendliness of profiling/dashboard reports
• Coordinate with other development teams to do an impact and risk analysis
• Created mappings for 1x1 tables from Oracle source to Teradata target.
• Performance tuning, enhancements and Best practices implementation for the existing data marts
• Perform testing with test plans, test cases and defect traking using Mercury Test Director
• Designed the ETL processes using Informatica tool to load data from Oracle database to Teradata.
• Created Mapping/BTEQ script to load data for Dimensions Facts
• Involved in developing Reports Dashboard provided by OBI which will allow the respective Users to view reports on the various phases of the migration process along with the status.
• Preparing Test cases, Unit Testing, providing CIT testing support
• Creating Dashboards, Charts, and Tables using OBIEE Answers.
• Developing business reports using OBIEE Answers and to display the reports in Dashboards

Environment: Oracle 10g, Informatica Power Center 8.6, OBIEE, Remedy COTS, Teradata DWH, UNIX

Confidential

Sr. Technical Associate

Responsibilities

• Involved in building the dimension modeling and star schema for Analytical reports.
• Designed the ETL processes using Informatica power center to load data from Oracle database to Teradata.
• Created Mapping/BTEQ script to load data for Dimensions Facts
• Liaise between PMO and Customer for project management estimate and approvals
• Responsible to understand different in-country systems OSS BSS systems in scope.
• Data load strategy mapping for One Siebel, Infinys Rating, Billing and EDW using Informatica power Center.
• Develop the production process to automate the ETL and create documentation to transition the process to the Production team
• Research and analysis of BTGS applications in EMEA Region

Environment: Oracle 10g, Informatica Power Center 8.6, OBIEE, Remedy COTS, UNIX

Confidential

Sr. Technical Associate

Responsibilities

• Involved in Installation/Administration of Informatica ETL on server/client.
• Responsible for conceptual, logical and physical implementation of CDM common data model
• Involved in data analysis/crunching in order to manipulate the data to be able convert from legacy applications to new stack
• Create adhoc reports, troubleshoot and fix data issues, update business rules in the ETLs/Reports etc
• Data load strategy mapping for Inventory and billing systems One Siebel, TANGOE BFG and Billing using Informatica Power Center.
• Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.
• Data entry template created for ease of Data Quality and Service assurance teams.

Environment: Oracle 10g, Informatica Power Center Bundle 8.6, COTS App, UNIX

Confidential

Sr. Technical Associate

Responsibilities

• Involved in Installation/Administration of Informatica ETL on server/client
• Liaise with Informatica support team if there were any issues related to Tool
• Designing and Developing Data Migration Frameworks
• Generate Data profiling report to identify the data Quality issues using IDP
• Finalize data quality rules with various stakeholders and architects and implement using IDQ
• Proof of Concepts to demonstrate Data Migration Frameworks
• Providing Data Migration design documents
• Manual and automated Data Profiling and Cleansing
• Data load strategy mapping for Infinys Rating and Billing using Informatica Power Center
• Responsible for repository backup and storage create and grant privileges to user groups.

Environment: Informatica Power Center 8X, IDP, IDQ, UNIX, Oracle 10g, SQL

Confidential

Technical Associate

Responsibilities

• Involved in Installation/Administration of Informatica ETL on server/client
• Liaise with Informatica support team if there were any issues related to Tool
• Create necessary schemas DBA and Configure VCS for new version of Informatica
• Setting INFA Switch to run code in different version of Power Center
• Responsible for Power Center version conflict / Incompatible software drivers
• Generate Data profiling report to identify the data Quality issues using IDP
• Finalize data quality rules with various stakeholders and architects and implement using IDQ
• Dry run or test run of jobs by Application Support team where applicable
• Educated the team to carry out different POC using Informatica Power Center 8.6
• Data load strategy mapping for Infinys Rating and Billing using Informatica Power Center
• Responsible for repository backup and storage create and grant privileges to user groups.

Environment: Informatica Power Center 8X, IDP, IDQ UNIX Oracle 10g, SQL