SUMMARY

• 12+ years in IT working in Data Warehouse & Business Intelligence solutions with an emphasis in Data Integration, Data Quality Management including ETL, Data Profiling, Enrichment as a developer and team lead.
• A track record in providing technical expertise, delivery and consulting across Business Intelligence, Data Warehousing, Data Migration and Data Integration projects.
• Developing and supporting enterprise ETL implementations in business critical applications with a demonstrated ability to be the subject matter expert in designing, developing, supporting, maintaining, and administering complex ETL projects.
• Working in technical roles on a combination of operational support and development/project based work.
• Various problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.
• Ability to multitask in a fast paced environment and deliver on tight/agile time frames.
• Willingness to adapt and learn new skills/technologies.

TECHNICAL SKILLS

Industry Domains: Banking and Finance, Manufacturing, Automobile, Media and Entertainment, Health Care

Operating Systems: Windows, UNIX, LINUX

Scripting Languages: Apache Hive, SQL, HTML, Unix Shell Scripting

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

ETL Tools: IBM InfoSphere Information Server 11.7 (and below), Informatica 6.1, IBM Datastage Flow Designer

Data Quality: IBM QualityStage (Data Cleansing, Data Standardization)

Data Profiling: IBM - InfoSphere Information Analyzer

Scheduling Tools: Autosys, Crontab, Control - M, Zena

Tools & Utilities: Teradata Load and Unload utilities, HP Quality Center (For testing/defect tracking), Toad, ALM (Application LifeCycle Management), Jira, GitLab

Project Management Methodology: Waterfall, Agile (Scrum)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Software Developer

Responsibilities:

• Modified all DS jobs to point to new directory structures.
• Exported jobs to new DS 11.7 environment
• Migrated code to upper environment using GitLab CI/CD process.
• Planned and conducted ETL unit and development tests; monitored results and took corrective action.
• Created a generic automated process for comparing Datasets for regression testing.
• Responsible for creating documentations related to regression testing.
• Responsible for modifying Control-M flow.

Confidential

Sr. Software Developer

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software
• Work closely with business & IT stakeholders and understand ETL requirements and build end to end ETL framework using IBM DataStage tool.
• Coordinating with vendors/project team, downstream systems and offshore team for project completion.
• Design overall ETL framework & data flow.
• Provided recommendations on techniques to improve data quality, ETL processing & data loading times.
• Requirement gathering.
• Unit testing of newly built framework.
• Assist UAT/SIT testing.

Confidential

Software and Integrator Developer

Responsibilities:

• Developed ETL process that facilitates Data Movement between internal/external sources and the enterprise by integrating different data formats into a structure that conforms to the business information model and standardize for consumption by enterprise data stores, data marts and 3rd parties.
• Planned and conducted ETL unit and development tests; monitored results and took corrective action.
• Created a custom DQ process to maintain data integrity end to end and automated process to collect controls evidence and run time details to load into the audit table.
• Created automated process for Schema reconciliation.
• Responsible for loading out/Inbound files to Hive tables.
• Documented ETL mapping documents.
• Developed Control-M flow to schedule ETL batch.

Confidential

App Dev Sr.Specialist

Responsibilities:

• Responsible for creating business rules by using Information analyzer per the specification to support Data Quality Initiative.
• Import data in Information Analyzer meta data from the production environment.
• Profiled data in IBM InfoAnalyzer using rules and column analysis against source files.
• Developed exception management process for reporting using IBM Datastage.
• Created projects, add data sources, write, configure and execute rules/rule sets within Information Analyzer.
• Profiled and analyzed data in IBM InfoAnalyzer using rules and column analysis.
• Based on IA reports, standardized data using Quality stage.
• Created 1100+ rules and 400+ rule definitions for checking syntax, date time, cross reference validations.

Confidential

Sr. Associates

Responsibilities:

• Responsible for loading data from 3rd party vendors into the Data Lake housed on the Hadoop file system and from data lake to staging databases and then to Enterprise Data warehouse tables for analytics.
• Developed ETL process that facilitates Data Movement between internal/external sources and the enterprise by integrating different data formats into a structure that conforms to the business information model and standardize for consumption by enterprise data stores and data marts.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, prepared test data for testing, error handling and analysis.
• DDL creation for the additional attribute identified for generating the Summary reports and performing the data load.
• Created a load process using Teradata Parallel Transporter utility to load a huge file of 250 gb into Teradata table.

Confidential

Sr. Associates

Responsibilities:

• Built, tested and deployed scalable, highly complex and reusable Datastage parallel and Quality stage jobs.
• Created the High Level Design and Low level design documents for the DataStage and Quality stage components.
• Achieved 80% data matches with existing production data, 15% improved data than existing production data and remaining 5% new data added which were missing in the old system.
• Developed data profiling solutions, run analysis jobs and view results, and create and manage data quality controls using Information Analyzer.
• Reduced manual efforts of Business analysts by around 60% by improving quality of data using Quality stage.
• Created local and shared containers to facilitate ease and reuse of jobs.