SUMMARY

• 10 years of excellent IT industry experience in Operational, Data ware Housing BI projects.
• Worked closely with project stakeholders, SMEs and staff to understand the requirements and specifications for new applications along with re-engineering the existing applications.
• Excellent writing skills in preparing business requirements documents BRDs , system requirement specifications SRS , system design specification SDS , functional specifications and defining project plans.
• Experienced in the analysis and design of applications using OOAD techniques, UML and Design Patterns
• Hands on experience with Microsoft Visio for requirements management and analysis use case development, business and data modeling.
• Performing GAP analysis, SWOT analysis.
• Modeling the system using Use Case Diagrams.
• Extensive experience in Analysis, Design, Development, and Testing Implementation of various Data Ware housing Projects.
• Regularly involved in Scrum Meetings for one project, and also involved in Agile for other project -SDLC methodologies.
• Integrated the webservices by generating the necessary stubs from the WSDL files for extracting the data from the home grown applications by using the home grown web services.
• Strong experience on landing and staging mappings for MDM project and implemented cleanse and standardization IDQ functions.
• Strong project development and Management skills focusing in providing end-to-end Data Warehousing Business Intelligence solutions for various industry segments like Banking Finance Finance, Credit Cards .
• Involvement in Informatica ILM Design, Development, and Implementation of ILM archival.
• Expertise in Data Warehousing, ETL technologies using Informatica power center.
• Client tools Designer, Repository manager, workflow manager/monitor tools. Importing Source/Target Tables from the respective databases and created Reusable Transformations and Mappings using Designer Tool set of Informatica
• Knowledge of different Schemas like Star and Snow Flake.
• Having knowledge in performance tuning of Informatica mappings and Sessions.
• Configuring Stage process by using Siperian.
• Creating Complex Mappings and defining functions.
• Understood the usage of Reusable components like Graph functions, Regular Expression Functions and Cleanse lists.
• Configure the load process by Trust values, Validation rules, Cell update etc.
• Configure the Match and Merge process.
• Good Understanding of Informatica Service Oriented Architecture SOA and Informatica Cloud computing.
• Configure the Data Access views Execute the Batch processes.
• Experienced in RDBMS like Oracle and Teradata.
• Extensive experience in DWH Dimensional Modeling Star Snow flake schemas .
• Good knowledge in SQL and writing PL/SQL procedures.
• Designed and developed efficient error handling, Re-conciliation routines and implemented in various projects.
• Worked extensively in Oracle to Teradata Migration project.
• Experienced in team leading Offshore and Client-Site .
• Experienced in Leading Project Delivery and client-interaction.
• Experienced in Performance testing, Load testing, benchmarking and Performance based redesign.
• Worked on MDM Objects like Customers, Products, Vendors etc.
• Experienced in leading/collaborating with large teams, client and vendor relationships simultaneously.
• Experienced in Competency building, and Technology training.
• Excellent communication, documentation and presentation skills.

SKILL SET:

DWH Tools: Informatica 6.x, 7.x , Oracle Warehouse Builder OWB , Informatica ILM Data Archive.

Database: Oracle, Teradata, SQL

Database Tools: Toad, Teradata SQL Assistant, Oracle SQL Developer, SQL Navigator

MDM Tools: Siperian

Operating Systems: UNIX, Windows 95/98/2000/2003/XP/Vista/Windows 7.

Languages: Unix/Linux Shell Scripting, SQL, PL/SQL

Domain: Banking/Core Banking, Credit Cards.

Solution: Product Implementation, System Integration Management.

Professional Experience

Contribution

• Understanding of client business requirement and documentation of same
• Preparation of mapping documents based on client requirement specifications.
• Preparation of ETL Design documents and Functional Technical specifications
• Created Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Created Data Marts and loaded the data using Informatica Tool.
• Created Physical schema Data Mart and load the data into schema using NSI Scheduling tool
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Worked on Performance Testing.
• Experienced in RDBMS like Oracle and Teradata.
• Written proxy class for particular application, WSDL file to invoke Web Service SOAP . And written java code to invoke particular web Service by making use of proxy class.
• Experience in delivering end to end data archive solutions using ILM data archive 5.3.6.
• Write Unix scripts to handle different file operations like structure validation, archiving, merging, deletions.
• Used Agile Methodology throughout the project and participated in daily Scrum meetings and worked with Business.
• Works within an Oracle environment performing PL/SQL code development, building high performing Oracle queries, and tuning existing queries

Contribution

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers Application Owners.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Prepared technical specifications for the development of Informatica ETL mappings to load data into various target tables and defining ETL standards
• Used slowly changing Dimensions techniques to load the dimensions.
• Created Power Exchange Registration for CDC on DB2 mainframe tables, created DataMap to extract data from file on mainframe.
• Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Populated master data from reference data server using Master Data Management MDM technique using Informatica as ETL tool on weekly and monthly basis.
• Created Incremental Iterative ETL releases using an Agile Process.
• Removed Duplicate records, rejected invalid Data using Informatica.
• Developed standard and re-usable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, filter and B2B Data Transformations.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment
• Prepared the Standard Operating Procedure Knowledge Transfer document, which provides necessary information, required for the Maintenance and Operation of the application.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Contribution

• Defining a Data Model and Configuring Stage process.
• Responsible for creating Complex Mappings and defining functions.
• Understood the usage of Reusable components like Graph functions, Regular Expression Functions and Cleanse lists.
• Installation and Configuration of Informatica MDM Hub, Cleanse and Match Server, Informatica Power Center.
• Designed and developed Mappings for loading MDM Hub.
• Configure the load process by Trust values, Validation rules, Cell update etc.
• Configure the Match and Merge process, Configure the Data Access views and execute the Batch processes.

Contribution

• Analysis of the specifications provided by the customer
• Responsible for providing the inputs to obtain the standard input files.
• Designing Mappings with Various Transformations Like Source qualifier, Filter, Lookup,
• Update Strategy, Normalizer and etc.
• Designing Sessions and Workflows.
• Responsible for understanding the Oracle Purchasing module in Oracle applications for loading into the PO interface tables
• Responsible for understanding the EDI Invoice module in Oracle applications for loading into the Invoice interface tables
• Developing the mappings with sources and testing them with sample data.
• Involved in Unit testing, Performance testing for data consistency and Quality.