SUMMARY

• An enterprising professional with around 11 + years of rich and cross - cultural experience in Full Life Cycle Management of Data Warehouse & Business Intelligence Projects Execution.
• Deft in DWBI-Projects implementation, involving analysis, design, development, testing, migration, debugging and run time analysis, in-depth understanding of mapping client's requirements, custom designing solutions & troubleshooting for complex Information Systems Management.
• Extensively worked on OFSAA technology to build the T2Ts,F2Ts & DTs to load to move the data in FSDF database.
• Ceated OFSAA ICC Batches and Tasks and configured different types of OFSAA OOTB objects like transform data, executables in tasks using Operations framework.
• Worked on developing GL reconciliation mappings using Run Rule Framework ( RRF).
• Experience in FSDF Data model customizations using Erwin tool and uploading the data model using Data Model management.
• Sound knowledge on FSDF Data model and GL Reconciliation madule, working with OFSAA Utilities Batch Operation, Data Mangemnt, Data Quality and RRF frameworks.
• Has experience in Objects migration using Object migration XML utilities.
• Configured Key dimesions load using SCD and DRM loader functions in tasks.
• Experinece in troubleshooting the batch failures using logs, Message log tables in Automic schema & config schema tables.
• Strong knowledge of data warehouse architecture, OFSAA internal architecture and experienced in dimensional modeling on data modeling tool (ERWIN).
• Extensively worked on Informatica, created complex mappings using different transformations, created sessions and build dependency between sessions, used different tasks in the workflows, involved in performance tuning of jobs.
• Extensively used Informatica client tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Informatica Workflow Manager and Informatica Workflow Monitor
• Optimizing Informatica Mappings and Sessions to improve the performance.
• Extensively worked on the Automic Scheduling tool, creating jobs and scheduling them by creating workflow as per their dependency.
• Extensively worked on Oracle 11g and Teradata, creating Teradata Stored Procedures(PL/SQL), tuning and building the complex SQLs.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Expertise in OBIEE 11g/12c and Oracle BI Publisher Technologies, Architecture Concepts, Work Process Architecture Concepts, An ardent analyst with a flair for adapting quickly to dynamic business environments and resolving complex business issues; deft in interacting with clients, understanding current business processes, gathering new business user requirements.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Extensively worked in various domains like Banking Risk and Regulatory, Sales & Supply management and Manufacturing.

TECHNICAL SKILLS

Product Suits: OFSAA-PFS,GL Recon

ETL Tools: Informatica 10.2/ 9.x,.

BI Tools: OBIEE 12c

DATA Bases: Teradata, Oracle 12C, SQL Server 2012.

Developer Tools: Teradata SQLAssisstant, SQL Developer, TOAD, WinScp, Putty.

Languages: SQL, PL/SQL, Core Java, Java Script.

Scheduling tools: Automic 12.3

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Lead ETL & BI Developer

RESPONSIBILITIES:

• Building Table to Table (T2T) Transformations in OFSAA manual file uploads & Configuring DQ Rules in OFSAA through UMM
• Scheduling and Executing Jobs, creating sql and maintain OFSAA Configurations. Validating the SCD Process to handle Dimensional Hierarchies.
• Involved in analysis of data issues from upstream and downstream applications associated with the OFSAA and its datamarts.
• Created Data quality check on the key elements of OFSAA-PFS application.
• Developed OFSAA T2T,F2T and PFT rules for PFS application Create multiple OFSAA components like batches, process, rules, Hierarchy, data transform and run
• Performed data model changes/customizations using CA Erwin tool
• Prepared the environments to run and validate the data for each sprint code.
• Extensively worked on informatica mappings & workflows development to load the multiple SORs data into FSDF STG Automic database.
• Provided technical solutions by debugging through experience, and created SR with Oracle
• Creating Model Tables and views with partitions and indexes.
• Advised/notified the mangers & other team members about the issues and impact of the new changes before moving into PROD.
• Involved in unit testing of mappings and ensure delivering the flaw less code to the SIT and UAT environments.
• Fixing the defects and implementing the Change requests during SIT and UAT phases.
• Involved and developed creating scheduling jobs & workflows in Automic.

ENVIRONMENT: OBIEE 12c,OFSAA, Informatica, Automic, Oracle, UNIX, Jira

Confidential - GL

Lead ETL & BI Developer

RESPONSIBILITIES:

• Developed OFSAA T2T, DT and ETL jobs to load the data into FSDF database.
• Identifiying the Key data elements and congfigured product processor and Gl data tables in global settings.
• Developed RRF rules for GL recon between GL to Product Processor (PP) reconciliation
• Cofigured SCD load tasks to load the Key dimensions like Product, Legal entity, org unit etc.
• Developed the ICC bathces with tasks and scheduled
• Developed various informatica Mappings & workflows to load data and implemented audit checks on the data load.
• Created Data quality check on the key elements of OFSAA-PFS application.
• Prepared the environments to run and validate the data for each sprint code.
• Extensively done code reviews and verified defined informatica coding standards.
• Creating Model Tables and views with partitions and indexes.
• Fixing the defects and implementing the Change requests during SIT and UAT phases.
• Involved and developed creating scheduling jobs & workflows in Automic.

ENVIRONMENT: OBIEE 12c,OFSAA, Informatica, Automic, Oracle, UNIX, Jira

Confidential

Lead Developer

RESPONSIBILITIES:

• Organized the team in developing various informatica Mappings & workflows.
• Ensured all delivery activities from offshore as per the project implementation plan.
• Providing project status to onshore team on daily basis.
• Involved in setting up test environment, development, UAT.
• Extensively done code reviews and verified defined informatica coding standards.
• Creating Model Tables and views with partitions and indexes.
• Improving the performance of jobs execution by implementing TPT Load, push down optimization, enabling cache for the required sessions.
• Involved in unit testing of mappings and ensure delivering the flaw less code to the SIT and UAT environments.
• Fixing the defects and implementing the Change requests during SIT and UAT phases.
• Involved in Scheduling and troubleshooting informatica jobs.
• Extensively worked on providing information through flat files of .txt & Relation tables.

ENVIRONMENT:  Informatica, Teradata, UNIX

Confidential

Senior ETL Developer

RESPONSIBILITIES:

• Analyzing the source system, identifying the required elements as per requirement and developing the Informatica mappings
• Designing the mappings and workflows as per the defined ETL architecture.
• Worked on the creation of the views on different sources to bring the history data for the Model.
• Created dependencies on workflows as per the requirements through CA7 job scheduling.
• Unit testing for each mapping end to end field and comparing the results with expected results.
• Involved in setting up test environment, development, UAT & migrating the code to PROD.
• Involved in unit testing of mappings and ensure delivering the flaw less code to the Production.
• Involved in Scheduling and troubleshooting informatica jobs.
• Prepared all project related documents (UTC, LLD, Deployment document and Run Book) from Development side.

ENVIRONMENT: Technologies: Informatica, Teradata, UNIX

Confidential

Senior ETL Developer

RESPONSIBILITIES:

• Analyzing the existing EDW architecture and proposing the new approach for dis source.
• Developing RAW, STG and TGT STG mappings to load the source files data.
• Implementing SCD Type2 to maintain the Historical data based on Customer Requirements
• Performed various Performance tuning techniques at Mapping level and session Level.
• Performed Flat mapping to extract the Data and Load into staging.
• Performed Testing on Mappings to check validation of mapping.
• Analyzed BRD and identified the source data dat needed to be moved to data warehouse..

ENVIRONMENT: Technologies: Informatica, Teradata, UNIX.

Confidential

Senior ETL Developer

RESPONSIBILITIES:

• Analyzing the FED changes and identifying the existing Teradata procedures and Informatica mappings to modify and documenting the impact analysis.
• Modifying the Teradata procedures as per requirement and testing the code with final expected results.
• Modifying the existing mappings, workflows and sessions.
• Loading the required month ends data in the Models and making ready for validation.
• Moving code from lower environments to higher environments.
• Designed mappings and workflows as per the requirements.
• Preparing deployment document and Details ETL design documents.
• Involved in setting up test environment, development, UAT & migrating the code to PROD.
• Involved in unit testing of mappings and ensure delivering the flaw less code to the Production.

ENVIRONMENT: Technologies: Informatica, Teradata, UNIX

Confidential

Senior ETL Developer

RESPONSIBILITIES:

• Analyzing the requirements and preparing the ETL design architecture.
• Segregating the fields for each mappings to develop based on the mapping document.
• Designing the mappings, sessions and creating the dependency to load consolidation target table.
• Implementing the TPT load in required sessions to improve the performance.
• Loading the required month ends data in the Models and making ready for validation in SIT and UAT phases
• Reviewing the team members’ code to verify the coding standards and to improve performance.
• Designed mappings and workflows as per the requirements.
• Preparing deployment document, LLD and UTC documents.
• Involved in setting up test environment, development, UAT & migrating the code to PROD.

ENVIRONMENT: Technologies: Informatica, Teradata, UNIX

Confidential

Senior ETL Developer & Module Lead

RESPONSIBILITIES:

• Analyzed existing system and developed business documentation on changes required.
• Handled end to end ETL implementation of two modules (Treasury & Loans).
• Created different workflows for new source system like (Raw, Stage and Target).
• Involved in designing mapping documents and preparation of UTC, LLD & HLD.
• Developed mappings & workflows and performed unit testing and System testing.
• Involved in data cleansing, mapping transformations and loading activities.
• Involved in Code migration from Dev to SIT, SIT to UAT environments.
• Involved in creating dependency for CA7 jobs creation based on data arrival.

ENVIRONMENT: Technologies: Informatica, SQL Server, UNIX

Confidential

Senior BI Developer

RESPONSIBILITIES:

• Gathering the client requirements.
• Designed Data models in Frame work manager to meet up the Clients report requirements.
• Working in coordination with client and team.
• Developed various kinds of List, Cross Tab, and Chart and Dashboard report using Cognos 8.4 & Cognos 10.
• Scheduling the reports based on the clients requirements using IBM Cognos Connection.
• Developed Various Dashboards Mutual funds, Business Banking, Investments and Insurance Dashboards.
• Understanding the existing stored procedures and migrated all the existing BO reports to various Cognos List, Crosstab, and Chart reports using Cognos.
• Handling complete Datacenter Migration.

ENVIRONMENT: Technologies: IBM Cognos BI, SQL Server, Windows7, SAP BO.