Jun 2022 – Present · 3 yrs 10 mos

• Responsibilities:
• ☛ Spearheading a team of five members to drive toward deliverables
• ☛ Contributing to data migration tasks from Teradata to DeltaLake
• ☛ Creating Shell scripts and DataStage jobs following the ETL jobs' architectural specifications
• ☛ Engaging in the meeting and providing feedback to the Architect team
• ☛ Scheduling jobs in PROD and support for 1 month post-deployment warranty
• ☛ Carrying out an impact analysis on the necessary modification and evaluating the new business requirements
• ☛ Ensuring that every facet of a program or application is recorded and documented
• ☛ Keeping a record of the workaround for further reference after resolving the issue
• ☛ Tracking down and guiding solutions for significant interface-related software and hardware problems
• ☛ Strategizing, monitoring, and scheduling software deliverables
• ☛ Actively identifying and fixing flaws in software systems
• ☛ Extensively working on CDC solutions
• ☛ Drive the call and engage stakeholders
• ☛ Creating appropriate documentation to support the team by assisting them in resolving their issues
• ☛ Working with a team to investigate various options while analyzing and solving complex problems
• ☛ Providing team members with training and supervision over their actions
• ☛ Building strong working connections with other staff members, including the product manager, marketing manager, engineers, and programmers
• ★★ Project ★★
• 👉 Project & Location: TCS, Synergy Park, Hyderabad, India
• 👉 Title: Digital Insights
• 👉 Client Name: HSBC
• 👉 Hardware: Linux Server, Distributed System
• 👉 Operating System: Linux, Delta Lake
• 👉 Languages: DataStage, Unix Shell Scripting, Teradata, Delta Lake, PySpark
• 👉 Special Software: Gitlab, Control M, JIRA

Apr 2022 – Jun 2022 · 2 mos

• Responsibilities:
• ☛ Comprehended technical requirements by participating in every Tech Sync call
• ☛ Developed Unix artifacts, such as SQL and schema files
• ☛ Generated entries in the ParamFile and Config for every task
• ☛ Set up Control M jobs for the entire flow
• ☛ Utilized Control M to test the job
• ☛ Actively participated in every daily scrum meeting
• ☛ Gathered all the information via liaising with every team member
• ★★ Project ★★
• 👉 Project & Location: TCS, Synergy Park, Hyderabad, India
• 👉 Title: CFO
• 👉 Client Name: USAA
• 👉 Hardware: Linux Server
• 👉 Operating System: Linux
• 👉 Languages: ETL Developer, Unix Shell Scripting
• 👉 Special Software: Gitlab, Control M, UCD, JIRA

Oct 2020 – Apr 2022 · 1 yr 6 mos

• Responsibilities:
• ☛ Gathered all jobs by exporting them from 11.5 and importing them into 11.7
• ☛ Performed testing on every Control M job that is associated with DataStage jobs
• ☛ Converted all SFTP jobs to NDM jobs, verified them in testing, and then repeated the process in production
• ☛ Moved all jobs from RTC to Gitlab
• ☛ Adhered to E3 criteria for all FTP tasks
• ☛ Switched from E2 to E3 framework for all file systems
• ☛ Utilized separate service IDs for distinct payment jobs
• ★★ Project ★★
• 👉 Project & Location: TCS, Synergy Park, Hyderabad, India
• 👉 Title: FFIEC, Enterprise Payment Platform
• 👉 Client Name: USAA
• 👉 Hardware: Linux Server
• 👉 Operating System: Linux
• 👉 Languages: DataStage, Unix, Shell Scripting
• 👉 Special Software: DB2, Gitlab, Control M, JIRA, UCD

Aug 2010 – Sep 2020 · 10 yrs 1 mo

• Responsibilities:
• ☛ Developed Parallel jobs to Extract, Transform and Load (ETL) the data into the data warehouse
• ☛ Designed, developed and enforced best practices and standards around data quality and ETL solutions
• ☛ Utilized different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Sort, Peek stages etc. to develop DataStage Parallel jobs
• ☛ Applied Debug phases to enhance the ETL code's comprehension and performance
• ☛ Developed solutions for the DataStage ETL Platform's best possible performance and managed other non-functional elements of availability, dependability, and security
• ☛ Developed AutoSys jobs to carry out the jobs in the DataStage job sequence
• ☛ Monitored and executed the jobs using the DataStage Director
• ☛ Built DataStage sequencers to carry out the jobs in batches
• ☛ Improved the performance of the parallel jobs with Optimizer
• ☛ Built jobs to read data from many sources (such as Oracle, Mainframe Z/os, ODBC Connector, and DB2 Connector) and load it into a data warehouse
• ☛ Created parallel jobs using several partitioning techniques, such as HASH, MODULUS, RANGE, SAME, ENTIRE, and ROUND ROBIN
• ☛ Enhanced data lineage through the utilization of the IBM Infosphere Metadata workbench
• ☛ Engaged in all phases, including requirement analysis, client interaction, design, development, testing, support and documentation
• ☛ Created a test plan that outlines the scope, roles, responsibilities, testing strategy, and testing approach
• ☛ Carried out UAT and included Business Users in the Testing
• ★★ Project ★★
• 👉 Project & Location: Newark, DE, USA
• 👉 Title: Analytics and Business Intelligence Technology
• 👉 Client Name: Bank of America
• 👉 Hardware: AIX Servers
• 👉 Operating System: Linux
• 👉 Languages: DataStage V8.3/9.1/9.7/11.5, Unix Shell Scripting, Perl Utilities
• 👉 Special Software: DB2 9.7/11, AutoSys, Maestro (TWS Web Admin)

Mar 2008 – Aug 2010 · 2 yrs 5 mos

• Responsibilities:
• ☛ Worked extensively with Development of Reports using Shell Scrip and Oracle SQL
• ☛ Created re-usable components to optimize the code
• ☛ Created Design Documents and Unit Test cases with test Results Documents
• ☛ Good Experience Working with Crontab for scheduling daily Jobs
• ☛ Worked on the Impact analysis and Effort Estimation
• ☛ Worked on Many Ad hoc Report requests from Clients
• ☛ Acted as a point of contact for Maintaining Lower environments like QA, UAT, PRE-PROD
• ☛ Actively worked on impact analysis and Effort Estimation for major process changes
• ☛ Played key role in performance optimization of existing SQL queries by removing unnecessary usage of joins and creating indexes of join keys
• ☛ Implemented automated process which addresses Issues with settlement process
• ☛ Achieved certification in Telecom domain
• ☛ Actively participate in conducting Knowledge transfer for fellow teammates in both functional and technology aspects
• ☛ Worked as a Point of contact for the project MetaSolve to Oracle CRM Conversion project
• ★★ Project ★★
• 👉 Project Location: Kohinoor Park, TCS, Hyderabad, India
• 👉 Title: TTSL – MetaSolve Reports
• 👉 Client Name: Tata Tele Service Limited
• 👉 Hardware: Linux Server
• 👉 Operating System: Linux
• 👉 Languages: Unix Shell Scripting
• 👉 Special Software: Oracle, MetaSolve, Report Builder 6i

Mar 2007 – Mar 2008 · 1 yr

• Responsibilities:
• ☛ Developing the PL/SQL Code to perform the Account Receivable and Account Payable Activities.
• ☛ Developing the Reports in Reports Builder 6i
• ☛ Acted as a point of contact for Maintaining Lower environments like QA, UAT, PRE-PROD
• ☛ Created re-usable components to optimize the SQL Query and PL/SQL.
• ☛ Actively worked on impact analysis and Effort Estimation for major process changes
• ☛ Created Design Documents and Unit Test cases with test Results Documents.
• ☛ Coordinated the user acceptance testing.
• ☛ Developed technical documentation such as deployment instructions and production steps to enable the production support personnel to better understand the production process.
• ☛ Involved in project planning like time and cost estimation.
• ☛ Gain a good knowledge of payments and receipts module functionalities.
• ☛ Gave some knowledge sharing sessions on Payables and Receivables.
• ★★ Project ★★
• 👉 Project Location: Kohinoor Park, TCS, Hyderabad, India
• 👉 Title: Apollo Payments
• 👉 Client Name: Apollo
• 👉 Hardware: Linux Server
• 👉 Operating System: Linux
• 👉 Languages: Unix Shell Scripting, PL/SQL
• 👉 Special Software: Oracle 10g, Report Builder 6i