PROFESSIONAL SUMMARY:

• Over 14 years of IT experience in Data Warehousing and application development.
• Strong Knowledge of Dimension Modeling (Star Schema, Snow flake Schema) and Data Modeling (Conceptual, Logical and Physical).
• Worked on designing and development of Operational Data Source (ODS), Data Marts, and Warehouse in OLTP and OLAP systems.
• Sound knowledge on Master Data Management (MDM), Meta Data Environment, Data Rationalization, Slowly Changing Dimensions and Change Data Capture mechanism.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
• Worked on several Data Quality initiatives. Designed sophisticated dashboards to monitor quality of data for all critical data elements across different LOB’s.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Well acquainted with ETL process using Tools such as AbInitio and Informatica (exposure to Talend and SSIS).
• Worked extensively on different Databases such as Teradata, Oracle, SQL Server, MongoDB and DB2.
• Well versed with tools like HP QC, IBM RTC, Rally and processes such as Defect Tracking, ER Diagrams, Sequence Diagrams, and Process flows.
• Experience in using scheduling tools like Autosys, CA7 and OPC.
• Exposure to BIGDATA architecture, HDFS, Hadoop Mapreduce framework, PIG, HIVE.
• Developed a data quality solution for CCB using Meta data. The Meta data contains all Critical Data Elements, business rules for validation and error messages.
• Build data quality checkpoint model using threshold values for different Financial Data elements. Business rules are defined to take a decision on process execution based on the Staged data.
• Designed Data quality reports, after staging, used by business users before providing approvals for further processing.

TECHNICAL SKILLS:

Operating Systems: Linux, Unix, Windows, MVS, Z/OS

Methodologies: Agile, Waterfall and Hybrid

Languages: SQL, Shell Scripts, COBOL, JCL, Python

Tools: AbInitio, Informatica Powercenter and Exposure to Talend and SSIS,Tableau, HP Quality Center, RTC, Autosys, OPC, Visio, Spectrum, NDM

Databases: Oracle, Teradata, DB2, SQL Server, MongoDB

PROFESSIONAL EXPERIENCE:

Confidential

Data Specialist, Hunt valley, MD

Technologies: SQL, Oracle, MongoDB, AbInitio, LINUX, Autosys, Rally, QC

Responsibilities:

• Maintain application metadata to keep the application running.
• Uncover data anomalies, work with business to fix.
• Create data quality reports.
• Introduce new technologies when it is beneficial (Ex: Suggested to use MongoDB to store Large Policies information).
• Automate manual tasks (Ex: Automated Metadata load process and Unit Testing).

Confidential

Tech Lead

Technologies\Tools: SQL, Oracle, Teradata, AbInitio, LINUX, RTC, Tableau, Autosys, QC and Rally

Responsibilities:

• Profiling data (Customer data, Bankers Data, Hierarchies, Ownership data) to identify anomalies and document opportunities for Data Rationalization.
• Worked with business to create Business rules to build Hierarchy, Customer\Account status change, Cross - sell commission distribution and Commercial\non-commercial segregation.
• Created Data Quality reports for CDEs (Critical Data Elements) and shared with senior management.
• Designed ODS for Pricing application which is a real-time OLTP system.
• Created a Meta Data model that stores all the Key business elements for commercial customers. The model contains business rules for data quality check for each critical element.
• Created check point reports after staging data. These reports will be verified by business users before providing approval to process further.
• Developed an exception processing mechanism by taking Data quality scores into consideration.
• Preparing User Stories by conducting workshops with all stake holders.
• Lead Technical, design sessions to provide ETL best practices with portfolio, application and infrastructure architects. Understanding current Business needs to convert them into functionalities.
• Created a process for e-mailing all concerned parties with Data quality metrics such as no.of processed records, no. of records loaded, rejected records, Unknown RMs and Unknown Products.
• Estimating Task durations, resource requirements, prioritizing tasks, monitoring progress, reporting status and identifying risks and issues at early stage.
• Ownership to prepare Functional, Technical Design, and Traceability Matrix, Defect Tracker and Risk mitigation plans.
• Responsible to obtain design Signoff from designated Product owners, Business and Leads.

Confidential

Data Analyst

Technologies\Tools: SQL, Oracle, Teradata, AbInitio, UNIX, Autosys, Cognos, HP QC, Visio, Spectrum, WSDL

Responsibilities:

• Analyzed Data sources, requirements and business rules to perform logical and physical Data Modelling
• Analyzing demographic data from different countries and regions to identify data anomalies.
• Developed DDL scripts and supported DBA in Physical Implementation of data Models.
• Performed data analysis and data profiling using SQL queries on various sources systems.
• Defined ETL framework which includes load pattern for staging and ODS layer using ETL tool, file archival process, data purging process, batch execution process.
• Played key role in designing a base frame work using Spectrum and AbInitio which can be used for multiple countries across APAC, EMEA and NA regions.
• Document and report different data quality scores and metrics using Pivot tables and charts.
• Profile data using AbInitio profiler to document data trends and anomalies with sample data to build checks for data quality.
• Designed and developed data element scoring mechanism that used to fetch the most possible accurate record. This increased the data quality of the search result.
• Analyze data using SQLs after cleansing process and validate the quality.
• Understanding Data privacy requirements for different countries and make sure team is adhering to audit requirements.
• Designed and developed matching rules to enhance the quality of the customer data.
• Conducted workshops to create Source-Target mappings, Functional document and to finalize the ETL architecture.
• Extensively used AbInitio graphs for the ETL batch process and Spectrum tool to standardize customer name, address and matching process.
• Prepare test plan and SQLs for testing.

Confidential

ETL Developer

Technologies\Tools: AbInitio, Informatica, UNIX, Teradata, OPC, HP QC

Responsibilities:

• Preparing Source-Target mappings by participating in all discussions with all teams.
• Assisting Data Modeling team in finalizing the model.
• Design and development of AbInitio graphs and Informatica mappings.
• Developed number of AbInitio Graphs based on business requirements using various AbInitio Components such as Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Merge, Denormalize, Normalize and Write Multiple Files etc.
• Created dynamic DMLs and reusable XFRs using AbInitio
• Created several mappings, workflows, sessions using Informatica Power Center
• Used UNIX for creating Job Wrapper Scripts, file validations and file splits.
• Used AbInitio EME for Version Control System and for Code Promotion.
• Created Test Approach, Test Plan and Test case documents and involved in multiple phases of testing
• Defects were traced, reviewed, analyzed and compared using Quality Center.
• Attended defect resolution calls, created test reports and presented progress updates to launch managers.
• Fine-tuning AbInitio graphs and functional process.

Confidential

ETL Developer

Technologies\Tools: AbInitio, UNIX, Teradata, OPC, HP QC, SQL Server

Responsibilities:

• Gather Requirements from TPR.
• Participate design discussions with LOB users and prepare the technical specs.
• Worked on Multi file systems with extensive parallel processing.
• Implemented Lookups instead of Joins, in-memory sorts to minimize the execution times while dealing with huge volumes of data.
• Extensively used Partitioning Components: Broad Cast, partition by key, partition by Range, partition by round robin and De-partition components like Concatenate, Gather and Merge in AbInitio.
• Implemented Transform Components such as Aggregate, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components and created appropriate XFRs and DMLs.
• Walkthrough and review of documents & code prepared by the team members before moving it to higher regions.
• Review of code/unit test results.
• Functional issues resolution and coordination with Business teams.

Confidential

Mainframe Developer

Technologies\Tools: COBOL, JCL, CICS, FILEAID, VSAM, EXPEDITOR, CSF, Stream Weaver, AFP, VBA, Oracle, MS-Access, DB2, Office tools.

Responsibilities:

• Get the requirements of a TPR by discussing with relevant groups involved in the project
• Attend the project calls to finalize required table data
• Key in the data and upload to mainframe so that development groups can load the tables
• Make sure the data integrity and constraints are maintained
• Support the UAT jobs for necessary table corrections
• Implement and verify the table changes thru backend (mainframe)
• Support the Production to resolve any TR’s pertaining to Tables

Confidential

Mainframe Developer

Technologies\Tools: IBM Mainframes OS/390, COBOL, JCL, DB2, IMS-DB, FILEAID, INSYNC, ENDEVOR, DB2I, BMCDB2, VSAM, Control-M, NDM

Responsibilities:

• Preparation of new JCL’s or changing the existing JCL’s based on the CR’s (Change Requests) as a part of a release.
• Set up of test bed data by running the required scrub and spin jobs.
• Performing system test by running the jobs using the Control-M tool.
• Resolution of errors during the job cycle execution is one of the important tasks which need interaction with various groups.
• Verification and comparison of test results.
• Perform severity analysis of reported bugs & carry out root-cause analysis of the bugs, preparing the supportive checklists for the next phases of work again can reduce the probability of their occurring.
• Adherences to Quality procedures such as IQMS, IPMS guidelines, CMM processes.