SUMMARY:

• 14 years of experience in IT with a strong background in Data warehousing projects which involves Business and Data Analysis, Data profiling, Development, Data Migration, Data Governance and Master Data management (MDM).
• 10 years of ETL experience using Confidential Infosphere Change Data Capture (CDC) 11.3.3, Datastage Enterprise and Server Edition, Information Analyzer, Quality Stage, Profile stage and also worked in SAS EG9.4, SAS Data Integration Studio 9.4, SAS DataLoader for Hadoop, DataFlux Management Studio, SAS Visual Analytics, SSIS, SSRS and Informatica PowerExchange /Power Center 9.6.1(CDC)
• Experience in Big Data, Hadoop 2.0, MapReduce, Pig, Hive, Splunk, Spark technologies and Machine learning tools
• Worked in Energy & Utilities, Superannuation, Banking and Financial, Automotive, Manufacturing and IT consulting firms.
• Strong functional knowledge in Anti Money laundering systems (AML), FATCA and Common Reporting Standard (CRS) in BFSI.
• Proficient in Data Quality management (DQM) and Data Governance.
• Experience in full Software Development Life Cycle (SDLC) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
• Experience in Agile iterative development methodologies.
• Self - motivated; able to work independently and in teams; can handle multiple projects while paying attention to details; accomplished problem solving and analytical skills. Highly motivated, quick learner and extremely versatile. Accepts responsibilities and job duties eagerly with minimal supervision required.

TECHNICAL SKILLS:

Big Data Technologies: Hadoop 2.0, Map Reduce, Spark, Hive, Pig, Splunk

IBM Tools: - Infosphere Change Data Capture (CDC) 11.3.3, Datastage Enterprise Edition 8.X (PX), Server Edition 8.0, Information Analyzer

Microsoft Tools: - SSIS

SAS Tools: - SAS data loader for Hadoop, SAS Data Integration Studio 9.4, Data Flux, Management Studio, SAS EG9.4Informatica: Informatica Power Center & Informatica Power Exchange 9.6.1

Reporting Tool: Cognos Report Net, Business Objects, SAS Visual Analytics & Visual Statistics, SSRS

RDBMS: Teradata V14, Oracle (8i - 10g), Confidential DB2 & SQL Server 7.0, Oracle CC &B

Data Modeling Tool: Erwin 3.5, Confidential -Financial Services Data Model

Testing Tools: Mercury Quality Center

Version Control: PVCS,Tortoise SVN

PROFESSIONAL EXPERIENCE:

Confidential

Informatica/Datastage Consultant

Responsibilities:

• Responsible for Business Analysis and Requirements Collection .
• Data sources analysis to support the required business requirement
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification documents
• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 9.6.1. to transform the data to satisfy business rules
• Developed reusable Mapplets and Transformations
• Created detailed Unit Test Document with all possible Test cases/Scripts
• Created and Configured Workflows and Sessions to transport the data to target warehouse using Informatica Workflow Manager
• Monitored sessions using the workflow monitor. Debugged mappings for failed sessions.
• Conducted code reviews
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Responsible for creation of mapping document by understanding the business requirements
• Responsible for creation of ETL jobs based on the mapping specification which capture the changed data from source and load into target using Confidential infosphere CDC 11.3.3.
• Responsible for unit testing and automated script testing

Confidential

Data management Consultant, Financial Crime Services

Responsibilities:

• Responsible for Data profiling, Data analysis, validate business rules and data integrity.
• Responsible for providing quality data to Fraud Detection business daily to detect Card, Cheque, efraud and merchant fraud through Data Governance.
• Responsible for Data mapping and translation of business rules to technical design rules.
• Design and build ETL Jobs for Fraud detection business
• Create Analytical Reports for business insights
• SME for Financial Crime Services (AML, FATCA, CDD & CRS)
• Test Management Support

Confidential

Datastage and Datamigration / ETL Consultant

Responsibilities:

• Take ownership of particular Data Migration loads with respect to data cleansing, extraction, transformation, loading, reconciliation, business verification and identification of all cut-over tasks, dependencies, timings and requirements.
• Take lead role in designing ETL tool DataStage to meet Data Migration requirements (Data Validation & Data Transformation) and supporting other Data Migration team members.
• Monitor ETL jobs and data loads through DataStage tool.
• Troubleshoot broken ETL processes, develop and deploy resolution
• Load data for trial conversions, dress rehearsals, go-live and support the testing team and business teams with respect to migrated data including tracking and resolution of defects.

Confidential

Data Analyst

Responsibilities:

• Systems Analysis and Design of the Master Data Management (MDM) Solution
• Work with the source system SMEs to understand source data and capture business rules
• Data Profiling and analysis of source data to identify data quality issues, validate business rules, and data integrity
• Translation of business rules to technical design and capture the same in design templates
• Technical Design including data mapping, translation of business rules to technical design rules, and data validation
• Analyze data files, capture business rules, discussions with source systems to understand source data, scripting to verify business rules, and identify data quality issues

Confidential

Data Management Consultant

Responsibilities:

• Create data migration design documents for particular data loads.
• Design and administrate ETL tool DataStage to meet Data Migration validation and transformation requirements
• Support testing team. Including tracking, resolution and reporting on data migration defects.
• Provide status updates and feedback to data migration manager as required.

Confidential

Datastage Consultant

Responsibilities:

• Design the Mapping Document ( Module flow from Mapping source to target)
• Design ETL jobs like EXTRACT, Transform, LOADS, SEQUENCER based on the mapping document.
• Involved in System testing, User acceptance Testing (UAT) including tracking, resolution and reporting on defects.

Confidential

Senior Associate

Responsibilities:

• Gather Requirement(s) & analysis of the same.
• Reviewing and assessing source systems and data processing methods and techniques.
• Prepare design documents and program specification
• Design the Mapping Document ( Module flow from Mapping source to target)
• Design ETL jobs like EXTRACT, CDC, LOADS, LDW, SEQUENCER based on the mapping document

Confidential

Senior Product Analyst

Responsibilities:

• Attend workshops on AntiMoney Laundering (AML) with business teams, source teams and Legal & Compliance teams to gather business requirements.
• Gathering and documenting the technical and business meta data about the data.
• Prepare design documents and program specification
• Perform raw data analysis checks in Excel, SQL database platforms on tabulated data gathered
• Designed database, tables and views structure for the new datamart
• Provides production support: solving defects, code debugging and SQL performance tuning
• Help provide end users with the ability to access and utilize the data stored in the datamart.
• Develops data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex ad hoc queries and analysis.
• Worked closely with business and technology stakeholders to ensure appropriate business outcome is achieved

Confidential

Analyst

Responsibilities:

• Design the Mapping Document ( Module flow from Mapping source to target)
• Design ETL jobs like EXTRACT, CDC, LOADS, LDW, SEQUENCER based on Mapping document
• Used the Datastage stages like Oracle Enterprise, Teradata API stage, Teradata Multi-load, Copy, Modify, Lookup, Transformer, Sort, Column Export, Funnel, Column Generator, Row Generator, Shared Containers, Column Import, Join, Dataset, Merge, Aggregator, Sequential file, Remove Duplicates
• Export the job design & elements using Datastage Manager
• Unit Test of ETL jobs using Shell script and Sequencer
• Involved in generation of OLAP reports ( simple, drill through, cross-tab ) using Cognos Reportnet