SUMMARY

• Over 9 Years of work experience in ETL design solutions, implementation, Data Quality/Profiling/conversion and maintenance with customers like Confidential, Confidential, IBM Australia, Confidential, Confidential, UniSuper, Confidential, Confidential services, Department of Human Services and HealthCare (Australia), Kaiser Permanente, Ford Motor Company, Confidential using IBM Infosphere Datastage and Informatica.
• Have strong IT background in Data warehousing projects which involves Business and Data Analysis, Data profiling, Development, Data Migration/Conversion, Data Governance and Master Data management (MDM).
• Very strong experience in IBM Infosphere Datastage /Change Data capture, Information Analyzer, Quality Stage, SAS EG, SAS Data Integration Studio, SAS DataLoader for Hadoop, DataFlux Management Studio, SAS Visual Analytics, SSIS, SSRS and Informatica PowerExchange /Power Center (CDC)/Informatica Data Quality (IDQ)
• Experience in Big Data, Cloudera - Hadoop 2.0, MapReduce, Pig, Hive, Splunk, Impala, Python, Spark technologies and Machine learning tools
• Experience in ETL design and development of ETL design documents.
• Strong functional knowledge in Anti Money laundering systems (AML), FATCA and Common Reporting Standard (CRS) in BFSI.
• Experience in scheduling Jobs in crontab and Autosys.
• 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: Cloudera -Hadoop 2.0, Map Reduce, Spark Hive, Pig, Splunk, HBase, KNIME

DataWarehouse Tools: IBM Tools - Infosphere Datastage 11.5 & Change Data Capture (CDC) 11.3.3 (Datastage Parallel & Server Edition), Information Analyzer

Microsoft Tools - SSIS: SAS Tools - SAS data loader for Hadoop, SAS Data Integration Studio 9.4, Data Flux, Management Studio, SAS EG9.4

Informatica : Informatica Power Center/Power Exchange 9.6.1, Informatica IDQ

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

DBMS: Oracle (8i - 11g), IBM DB2, SQL Server, Teradata, Oracle CC&B

ER DataModeling Tools: IBM Financial Model, Erwin DataModeller

PROFESSIONAL EXPERIENCE

Confidential, Dallas - Texas

Datastage Consultant

Responsibilities:

• Facilitating data requirement meetings with business and technical stakeholders and resolve conflicts to drive decisions.
• Have joint accountability with data stewards and data architects on the projects to ensure conformance to enterprise data governance policies around information risk and data protection guidelines.
• Data sources analysis and data profiling using IBM information Analyser to support the required business requirement
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification documents
• Provide data mappings requirements, user interface specifications, processing logic as per business requirements
• Design, develop datastage jobs to transform semi-structured JSON, XMLfiles (hierarchical data) and load into Oracle database
• Design, develop datastage jobs to pull data from Web services/HTTPS websites and load into oracle database using IBM Datastage 11.5
• Design, develop datastage jobs to send email to the operator who received commendation from customers.
• Responisible for developing the datastage jobs to replace the ‘Kildrummy’ application inorder to generate the reports for the users overnight.
• Responsible for unit testing the datastage jobs
• Created detailed Unit Test Document with all possible Test cases/Scripts
• Automate routine tasks where appropriate.
• Responsible for resolving the production issues and deliver data on time to business users

Confidential

Informatica Consultant

Responsibilities:

• Perform data profiling and analysis using Informatica IDQ
• Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes.
• 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 and Configured Workflows and Sessions to transport the data to target warehouse using Informatica Workflow Manager
• 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.
• Back-up and recovery of Informatica software, repository, and configurations
• Participate in Business discussion and prepare initial source-to-target mappings
• Responsible for Data profiling, Data analysis, validate business rules and data integrity
• Responsible for creation of mapping document by understanding the business requirements
• Document logical, physical models complete with business definitions and glossaries into central metadata repository
• Responsible for creation of ETL jobs based on the mapping specification which capture the changed data from source and load into target Oracle database using IBM infosphere CDC 11.3.3.
• Responsible for unit testing and automated script testing

Confidential

Data management Consultant

Responsibilities:

• Establish and maintain comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships
• 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 using SSIS and load the data into target Teradata and SQL server databases
• Analyze data across multiple channels and translating them to actionable insights and improvements to increase customer satisfaction and enterprise efficiency.
• Extract multiple data-sets, writing complex SQL queries & building BI Reports and Dashboards
• Create Analytical Reports for business insights using SSRS and SAS
• SME for Financial Crime Services (AML, FATCA, CDD & CRS)
• Test Management Support
• Responsible for resolving production support issues in a timely manner

Confidential

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.

IBM, Australia Data Analyst

Confidential

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.

Datastage Consultant

Confidential

Responsibilities:

• Design the Mapping Document (Module flow from Mapping source to target)
• Design ETL jobs like EXTRACT, Transform, LOADS, SEQUENCER based on the mapping documentand load data into the target Teradata database
• 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

Senior Product Analyst

Confidential

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