SUMMARY:

• 10 years of IT industry experience encompassing a wide range of skill sets and industry verticals.
• 9 years of experience in Data Warehousing Development and Maintenance projects, including Business Requirements Gathering, Technical Design, Development, Testing, Customization, Implementation and Production Support following Data warehousing and ETL Best Practices.
• Advanced Knowledge and expertise indesigning and developing ETL jobs using IBM InfoSphere DataStage (v11.x/9.x/8.x).
• Having strong expertise in identifying Performance Bottlenecks and Performance Tuningof ETL jobs.
• Working experience and knowledge of Hadoop HDFS and Hive.
• Extensive experience in writing advanced SQL Queries for Relational Databases, e.g.DB2(v 10.5/10.1/9.7 ), Oracle (v11g/10g/9i), Netezza, MS SQLand Teradata.
• Experience in writing PL/SQL stored procedures, functions and packages.
• Extensive experience working with Unix Operating System.
• Proficient in writing Unix Shell Scripts.
• Programming and hands on experience in Python.
• Having work experience on Social Platforms and Salesforce Cloud Environment Integration.
• Extensive experience in Unit Testing, System Testing, User Acceptance Testing, Integration Testing, Performance Testing and Regression Testing.
• Experience in IBM InfoSphereDataStage Upgrade and Migration projects - from planning to execution.
• Strong data warehousing concepts and Dimensional Modelling Concepts. (Fact/Dimension Tables, Star and Snowflake schema modelling).
• Experience in creating Conceptual, Logical and Physical Data Model utilizing Erwin and Sybase Power Designer tools.
• End to End experience in Software Development Life Cycle (SDLC) including analysis, design and implementation of software applications.
• Experience in Agile software development methodology and Waterfall methodology.
• Experience in creating and maintain high quality Project Documentation: Technical Design Documentation, Test Documentation (Test Plan, Test Cases and Test Data), Job Scheduling Details and Implementation Plans.
• Expertise in Creating Implementation/Roll-Out Plans for code migration to Production Environment.
• Extensive Knowledge of Production Support /Maintenanceprocesses and tools. (Incident, Defect and Change Management).
• Extensive Experience in Analysing and Troubleshooting production job failures and data discrepancies.
• Experience in ETL Job Monitoring andSchedulingusing CA7 and Control M tools.
• Served as Onsite Project Lead (10 Offshore Team Members) for AML - Create Operational Environment Project which were successfully deployed into Production in June 2014.
• Provided Value Addition to client ( Confidential ) by developing new solution of CTR E-Filling Process, which reduced manual intervention of Business Users and also gained significant performance improvement of the existing process.
• Served as Onsite Project Lead (6 Offshore Team Members) for BI Reporting Phase-2 Project which were successfully deployed into Production in October 2014.
• Played a major role to build an end-to-end IT solution of BI Financial Reporting. Previously the Business Users were using a view for their Financial Reporting which actually was broken and not fulfilling expected reporting criteria and it was critical for business to resolve this issue ASAP without doing any manual effort. So, we introduced and built a stable ETL solution.
• Received Put The Client First twice (In 2016 and 2017) for high degree of commitment for on-time delivery of projects.

TECHNICAL SKILLS:

Operating Systems: ETL Tools

Languages: Relational Databases

Database Tools: Scheduling Tools

Version Control Tools: Big Data ToolsOther Tools Windows, UNIX, DOS, IBM InfoSphere DataStage(v11.x/9.x/8.x), SQL, PL/SQL, UNIX Shell Scripting, Python, C, DB2(v 10.5/10.1/9.7 ), Oracle(v10g/10g/9i), Netezza, MS SQL, Teradata, SQL Developer, Toad, SQuirrel, Aginity,QMF (DB2 ), Teradata Queryman, BMC Control-M Workload Automation, CA7 Scheduling, Rational Software Architect (RSA), Power,Hadoop, Hive, HP ALM Defect Manager, Service Now, JIRA, WinSCP, Putty, Rational Team Concert (RTC)

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Responsibilities:

• Business Requirement Gathering, Creating Design Solutionfor ETL applications, Development of IBM InfoSphere DataStage ETL Jobs,Unit Testing, System Testing, Creating Implementation Plans and Deployment to Production.

• Responsible for leading the development and implementation of quality ETL codes for various interfaces from onsite using IBM InfoSphere DataStage.
• As Onsite Co-ordinator, plan and delegate daily team tasks to Onsite and Offshore.
• Attend Daily Stand-Ups and regular Onshore-Offshore meetings.
• Identify data quality issues that can be addressed at Source System or ETL level
• Perform Peer-Review of codes.
• Collaborate with the project team in monitoring and resolving production job issues.

Environment: DataStage Server: AIX 7.1, Oracle (v11g), DB2 (v10.5),Netezza, MS SQL, IBM InfoSphere DataStage(v 11.3/9.1/8.5 ), Python, UNIX

Confidential, Bentonville, AR

DataStage Onsite Coordinator and Senior Developer

Responsibilities:

• Design and Deliver high quality Data Integration solution to client in response to varying business requirements by utilizing in-depth functional and technical expertise in IBM InfoSphere DataStage ETL and other leading-edge products and technologyin conjunction with industry and business skills.

• Responsible for effective communication between the project team and the client.
• Perform Performance Tuning activities of IBM InfoSphere DataStage ETL jobs, key areas are:
• NFS (Network File Sharing) implementation
• Runtime Node Allocation (sequencer.sh) implementation
• Teradata Bulk Load implementation
• Array Size and Record count optimization is database connectors
• Minimizing repartitioning and sorting, less modularity analysis and implementation
• Code migration and deployment of changes across test environments, validation and implementation in production, job monitoring and validation.
• Providing knowledge sharing to Production Support team; before and after implementation and validation of change in Production.

Environment: DB2 (v10.1/9.5), Oracle (v10g), Teradata (v12), IBM InfoSphere DataStage (v8.5/8.1)

Confidential

DataStage Senior Data Analyst

Responsibilities:

• Deliver high quality solutions to client in response to varying business requirements.

• Utilize in-depth knowledge of functional and Technical expertise in IBM InfoSphere DataStage ETL and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to the client.
• Unit and Function Testing for IBM InfoSphere DataStage ETL jobs and implementation of the same.
• Responsible for effective communication between the project team and the client.

Environment: DB2 (v9.5), IBM InfoSphere DataStage (v8.1)

Confidential

DataStage Developer

Responsibilities:

• Design of Logical and Physical Data Models.

• Designing & Developing IBM InfoSphere DataStage ETL jobs as per requirements.
• Execution of the IBM InfoSphere DataStage ETL jobs.
• Unit and Component Testing of IBM InfoSphere DataStage ETL jobs.
• Coordinate and communicate with the Support and testing team after deployment.
• Communicate activities/progress to project managers, business analysts and clients
• Develop implementation and test plans, build software acceptance criteria.

Environment:: Teradata, Oracle(v10g), IBM InfoSphere DataStage(v8.1)

Confidential

Geneva Developer

Responsibilities:

• Worked on various billing products such as IX (Interconnect Circuit), CU (Conveyance Usage) and LLU (Local Loop Unbundling).

• Design study and design walkthroughs.
• Application Support Maintenance activities
• Preparation of Data
• Unit Testing
• Verification of Results

Environment:: Oracle (v9i), Geneva Billing Platform