SUMMARY

• Experienced Software Developer with more than 10 years of experience and exceptional skills in all areas of software construction and programming. Adept at troubleshooting and ensuring quality control at every stage of software delivery life cycle, with the ability to function independently as well as a team.

TECHNICAL SKILLS

Programming: ETL - IBM Infosphere DataStage 11.5

Scripting: Shell Scripting and Python

RDBMS: DB2 10, MS-SQL 2012, Oracle 11g, T-SQL and PL/SQL

Environments: Unix, Linux, IBM z/OS

Project Management Tools: JIRA, Rally, HP ALM

Scheduling Tools: AutoSys

Visulation Tools: Tableau

Automation: VBA

Mainframe: JCL, COBOL and Easytrieve

PROFESSIONAL EXPERIENCE

Confidential

ETL Software Developer

Responsibilities:

• Work with client, business analyst, and other stakeholders to discuss and understand the business requirements.
• Create technical design documents detailing the solution that will be developed as per the business requirements, the technology stack used to build the solution, normalized data models depicting the relationship between entities, details about interdependencies and delivery stages.
• Develop ETL data warehouse solutions using IBM Infosphere DataStage that will extract data from disparate data sources like files of different formats and Oracle and MS SQL server.
• Build data transformational solution that format, sort, join and utilize various partitioning, collection techniques to build high performing parallel processing solutions.
• Build relational database solutions using Structure Query Language (SQL) and stored procedure languages such as PL/SQL, T-SQL as per data volume and business requirements.
• Build Business Intelligence solutions based on the data warehouse data, job metrics, job status and other metrics through interactive data visualization using Tableau and other BI tools.
• Develop automation solutions that will minimize manual efforts through shell scripting, Python programming, VBA and other tools as per the scenario.
• Build AutoSys job flows to schedule processes that auto trigger based on time, file or events and multiple job dependency conditions.
• Work will fellow team members to improve code quality, process performance tuning, peer review and code integration activities.
• Work with testing partners to support QA and UAT testing, facilitate test data and provide code fixes for defects raised during testing.
• Work with admin team to deploy code changes in appropriate environments in a phased manner to facilitate various stages of testing and production deployment.
• Provide tactical and strategic post productions support by fixing the defects that arise withing SLA minimizing business impact.

Environment: IBM Infosphere DataStage, AutoSys, Shell Scripting, Oracle, PL\SQL, MS SQL Server, T-SQL, Python and Tableau

Confidential

DataStage Developer

Responsibilities:

• Build IBM DataStage and Mainframe jobs to extract data from various file systems, Databases like DB2, MS SQL & Oracle that contain Consumer Banking, Investment Banking, Mortgage and Credit card data, perform transform operations as per business needs and load into the data warehouse.
• Creation of parallel processing data pipelines, functionality level configurations and customizations for individual environments.
• Provide production support and resolutions on the go for data refresh batch job and transactions batch job abends and failures within stipulated SLA.
• Perform code review, code standardization, code integration, version controlling and deployment activities for the solution developed by team in IBM DataStage Director, AutoSys and in Mainframe using ChangeMan.
• Schedule & maintain application level cycle details and production job schedules in Autosys and CA7 as per environment release cycle schedules published by release management team and populate application dashboards with cycle status.
• Build and performance tune SQL scripts and data ingestion solutions for mining of data from the frontend.
• Build Tableau dashboards that reflects data volume, data quality and data availability for the business to consume for each pipeline built and maintained by team.
• Identify automation scenarios and implement solutions to reduce manual work, work of proof of concepts involving new technologies and delivery end to end solutions using technologies like UiPath, Python and VBA.
• Participate in Backlog refinement and requirement gathering meetings with client, upstream and downstream applications to understand the requirements for new data warehousing solutions.
• Participate in Program Increment, and other agile timeboxing events to perform impact analysis for modules undergoing enhancements, user story inputs, task break down and estimations.
• Gather metrics and prepare tasks status inputs for daily scrum meeting, weekly and monthly dashboards.
• Coordinate with QA and UAT testing teams for testing efforts, defect resolution and post deployment support efforts.
• Create release level artifacts, knowledge transfer documents, functionality level detailed process flow documents.

Environment: IBM DataStage, Autosys, JCL, COBOL, DB2, Easytrieve, Tableau, MS SQL, Oracle 11g, PL/SQL, z/OS, Linux, Shell Scripting, Rally, JIRA, UiPath, Python and VBA