PROFESSIONAL SUMMARY:

• An IBM DB2 Database Technical Lead and Certified Informatica Designer with over 16 years of IT Experience in Database, Data Warehousing and Data integration, Conversion processes, including Software Architecture, Design and Development.
• Experience in DB2 Administration (Performance tuning, debugging) and Database design adhering to a well - defined software engineering process.
• Extensive experience working with Tableau reporting tool, Oracle PL/SQL functions, Stored procedures, and packages.
• Production release manager
• Serving as Scrum Master to manage SDM Agile methodologies
• Domain expertise in Financial services - Capital Markets & Insurance.
• Domain expertise in Disaster recovery and BCP.
• Experience in requirements analysis, risk analysis, project planning, and defect tracking management, and reporting.
• Hands-on experience in leading and designing Data Integration and migration for Data Warehouses
• Developed ETL standards for the project & Documented Best Practices for the projects.
• Experience in administering Job Schedulers and development of SFTP and FTP Scripts.
• Experience in Integration of various data sources (Oracle, DB2 and various File systems)
• Experience in developing high level and low-level designs based on the business and functional requirements documents.
• Experienced in identifying the potential risks associated with common coding errors and effectively guiding the team by identifying the coding approaches to address the same.
• As a Team Lead, possess strong abilities to mentor juniors and transfer knowledge to client while empowering team members and work collaboratively.
• Excellent CRM skills with due onsite-offshore coordination experience.
• Managed Production Support and Maintenance projects.
• Expertise in solving the production tickets with strict SLA’s and has extensive coordination skills in handling Vendor environment.
• Effective communicator with excellent relationship & Interpersonal skills

TECHNICAL SKILLS:

Database: IBM DB2, Oracle, Netezza, MS-SQL

DW / OLAP / ETL Tools: Informatica Power center 8.1.1 / 8.6.1/ 9.1 / 9.6

Programming /Scripting: Unix, SQL and PL/SQL, Shell, Perl, Scala

Reporting: Tableau 2020.3, Business Objects XI 3.1

Tools: Ansible Tower, IBM Data studio, AutoSys, Aqua Data Studio, Win SQL, MS Visual SourceSafe, WinCVS, SVN, Toad, Horizon, GIT repository

PROFESSIONAL EXPERIENCE:

Confidential

Vice President - Software Engineer III

Responsibilities:

• In Global Markets Data Organization serving as a Project Lead across onshore and offshore teams for Data and Regulatory programs. Responsible for managing integration, change management and data delivery with approximately 80 upstream and downstream applications having data flow dependencies with the Global Markets Regulatory applications.
• Serving as a Release Manager for multiple Regulatory Applications within the Bank of America using Agile/SDLC adherence and managing end-to-end production releases for using Scala, Java, Unix, Autosys, RDF and Semantic web technologies/frameworks.
• Serving as Scrum Master to manage SDM Agile methodologies
• CI/CD Integration with Ansible Tower for Automated deployment
• Responsible for developing, enhancing, modifying and/or maintaining applications in the Global Markets environment using mathematical models, Informatica, Db2, Oracle, Tableau, Unix, Shell scripts, Autosys, IBM Data studio
• Designing, code, test, debug, and document programs as well as support activities for the corporate systems architecture. Involved in Design improvements and Scala code refactor using Database Partition Features to improve flexibility, performance, re-usability, and extensibility.
• Working closely with business partners in defining requirements for system applications to determine software feasibility of design within time and cost constraints.
• Managing a high level of risk and responsible for Access control management on Unix and Database for Regulatory applications in the Global Markets environment using GES entitlement system and ITRS alert monitoring system to avoid Business Operations impact.
• Performing Infrastructure Support Activities of Regulatory Applications to evaluate and implement Unix filesystem storage expansion, build auto archival tool, work with Unix Administrators on operational readiness of Unix servers.
• Performing database administrative tasks in non-production DB2 environments using Db2 Utilities to perform Optimized Data loads and the development of DB2 data models in support of regulatory applications. Design Data Integration & Data modeling (Dimensional & Relational) and migration for Data Warehouses. Implement Integration of various data sources (Db2, Oracle) using Golden Gate replication.
• Performing the development of DB2 data models in support of regulatory applications working on Database Management of Db2 V11.1 Migration with BLU Acceleration and data reconciliation providing ultimate scalability and performance for analytics and warehousing workloads.
• Providing application development support, query analysis and performance tuning for applications integrating within the DB2 environment using IBM Data studio Tool to generate Query tuner report statistics and based on query cost, provide SQL tuning options, indexes, Modify sub-queries, Usage of in-built memory cache.
• Conducting the supervision and compliance of enterprise policy for regulatory applications within Bank of America Global Markets Data Organization. As a Business Continuity Planning (BCP) Coordinator responsible for managing end-to-end Application/Database Disaster Recovery, Application Resiliency (ARC) and Data Restoration Testing. Manage Technical Recovery plans (TRP) and Technical Profile Information (TPI) Management

Environment: DB2 11.X/10.X, Tableau 2020.3, Scala, Oracle PL- SQL, Shell scripts, AutoSys, Ansible tower

Confidential

Vice President - Programmer Prof MKTS

Responsibilities:

• Complete ownership of DB2 and Oracle database related activities across the firm’s GRRP FMU reporting applications
• Design of complete FMU database architecture and implementation prepared the High-Level Design Document and walked it thru several acceptance cycles of the project.
• Production Release Manager, responsible for creating Release notes, creating tickets and co-coordinating with Production team to migrate the code.
• Tableau Reporting Developer for Enterprise transaction reporting
• Disaster Recovery Subject Matter Expert
• Subject Matter Expert for the firm’s trade, transactional, collateral and client data
• Performance optimization of Tableau reporting requirements.
• Involved in task estimation, planning, resource allocation, mentoring and .
• Extensively worked with offshore teams and evaluated the timely changes to the coding as part of conversion.
• Developing Unix Scripts for automation and to handle Business requirements.
• Developed & reviewed code done by team members as per the standard guidelines document
• Leverages relationships to gather information/data to anticipate client needs and expectations.
• Participated throughout the project life cycle from requirements to production implementation with emphasis on development.
• Coordinating with Delivery, Support, Testing, DBA and downstream teams to deliver the projects successfully.
• Providing the project estimates and status to the project managers and Line of business owners.
• Maintained Document standards, processes and procedures relating to best practices, issues and resolutions
• Documented process run books, production job schedules and troubleshooting procedures

Environment: DB2 9.X/10.X, Tableau 9.2.6, Oracle PL- SQL, Shell scripts, AutoSys

Confidential

Vice President - Programmer Prof MKTS

Responsibilities:

• As a team lead responsible for complete ownership of DB2 and Oracle database related activities across the firm’s RegW reporting applications
• Design of complete RegW database architecture and implementation prepared the High-Level Design Document and walked it thru several acceptance cycles of the project.
• Production Release Manager, responsible for creating Release notes, creating tickets and co-coordinating with Production team to migrate the code.
• Disaster Recovery Subject Matter Expert
• Subject Matter Expert for the firm’s trade, transactional, collateral and client data
• Performance optimization of Client On boarder reporting requirements.
• Actively involved in the meetings with Business Users for gathering business requirements.
• Analyzing existing database schemas to support the users reporting needs and requirements.
• Prepared the High-Level Design Document and walked it thru several acceptance cycles of the project.
• Involved in task estimation, planning, resource allocation, mentoring and .
• Extensively worked with offshore teams and evaluated the timely changes to the coding as part of conversion.
• Developing Unix Scripts for automation and to handle Business requirements.
• Developed & reviewed code done by team members as per the standard guidelines document
• Participated throughout the project life cycle from requirements to production implementation with emphasis on development.
• Coordinating with Delivery, Support, Testing, DBA and downstream teams to deliver the projects successfully.
• Providing the project estimates and status to the project managers and Line of business owners.
• Maintained Document standards, processes and procedures relating to best practices, issues and resolutions
• Documented process run books, production job schedules and troubleshooting procedures

Environment: DB2 9.X/10.X, Oracle PL- SQL, Shell scripts, AutoSys

Confidential

Vice President - Programmer Prof MKTS

Responsibilities:

• Served as Informatica and Db2 Tech Lead
• Actively involved in the meetings with Business Users for gathering business requirements.
• Analyzing existing database schemas to support the users reporting needs and requirements.
• Prepared the High-Level Design Document and walked it thru several acceptance cycles of the project.
• Create and execute SQL queries and scripts to validate data movement and generate expected results for UAT
• Involved in task estimation, planning, resource allocation, mentoring and .
• Extensively worked with offshore teams and evaluated the timely changes to the coding as part of conversion.
• Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designers.
• Developing Mappings, Mapplets.
• Developing Tasks/Sessions and workflows as required with session variables.
• Performance tuning of Informatica workflows
• Involved in the development of Source to Staging and staging to Target Mappings.
• Used most of the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Update strategy etc.
• Developing Unix Scripts for automation and to handle Business requirements.
• Developed & reviewed code done by team members as per the standard guidelines document
• Leverages relationships to gather information/data to anticipate client needs and expectations.
• Participated throughout the project life cycle from requirements to production implementation with emphasis on development.
• Responsible for creating Release notes, creating tickets and co-coordinating with Production team to migrate the code.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Coordinating with Delivery, Support, Testing, DBA and downstream teams to deliver the projects successfully.
• Providing the project estimates and status to the project managers and Line of business owners.
• Maintained Document standards, processes and procedures relating to best practices, issues and resolutions
• Documented process run books, production job schedules and troubleshooting procedures

Environment: Informatica Power center 9.1, Db2 9.X/8.X, Netezza, Db2, PL- SQL, Shell, Autosys

Confidential

Team Lead

Responsibilities:

• Onshore Delivery & Production Support lead for Atlas Claims Data Mart Team
• Understanding the specifications for Data warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements
• Documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart
• Developed high level and low-level designs based on the business and functional requirements documents
• Developed ETL jobs for Loading Datamart, Dimension, Fact and History tables
• Used Informatica Jobs to Extract, Transform, and Integrate data from multiple data sources and performed data cleansing and validations using Informatica predefined functions
• Implemented Type 2 SCD for Dimension tables in Datawarehouse using Informatica
• Used Informatica Built in Functions and Transformer stage to enrich and transform the data
• Developed number of Informatica ETL jobs based on business requirements using various Transformations Joiner, Aggregator, Filter, Expression, Lookup, Union, Stored Procedure, Normalizer
• Implemented partition techniques using the partition methods available in Informatica
• Developed Job Sequences and scheduled them using Autosys
• Supported the extraction of data, from heterogeneous source systems involving Oracle database & Pipe separated flat files. Developed transformations based on the requirements and loaded the formatted data into the target tables using Informatica
• Involved in Functional Testing, Regression Testing, Integration Testing, Performance and Load Testing.
• Estimating the module and coordinating with the client team for release plans
• Coordinated in deploying the application on test and production Environments owned by 3rd Party Vendor
• Taking care of Severity Incidents as part of Batch and resolve SEV1/SEV2 Incidents as per Client SLA
• Identify and escalate issues. Coordinate and follow-up with offshore team on Production Support and Maintenance of ETL based applications on multiple Platforms.
• Conduct weekly meeting with offshore team to go over all open issues, scheduling upcoming outages, batch related issues, change requests and UAT sign off for Production migration. Investigate client concerns and respond with solutions
• Demand Capacity planning for the entire team and coordinating with Clients to plan for Open requests
• Project Management and Resourcing
• Peer reviews on Coding standards and Best practices

Environment: Informatica Power center 9.1, MS-SQL2008, Netezza, Db2, PL- SQL, Shell, Autosys

Confidential

Team Lead

Responsibilities:

• Created technical design document for the critical enhancements
• Developed high level and low-level designs based on the business and functional requirements documents related to new products created to handle business at a more granular level and for reporting
• Developed number of Informatica ETL jobs based on business requirements using various Transformations Joiner, Aggregator, Filter, Expression, Lookup, Union, Stored Procedure, Normalizer
• Co-ordination with global users to solve their concerns/issues which are apart from the technical work.
• Involves high interactions with Global sales management
• Developed complex Informatica mappings and performance optimization of mappings
• New EQ/FICC feed setup for daily trades processing from multiple upstream systems
• New Regional EQ/FICC product classification enhancements and new products setup
• Developed Job Sequences and scheduled them using Autosys
• Automation of Business Objects reports / DB2 Stored Procedures using Informatica
• Involved in Functional, Regression, Integration, Performance and Load Testing.
• Demand Capacity planning for the entire team and coordinating with Clients to plan for Open requests.
• Peer reviews on Coding standards and Best practices.

Environment: Informatica Power center 8.6.1, Db2 9.1/ 9.7, PL- SQL, Shell, Perl, Autosys

Confidential

Senior Informatica and DB2 Developer

Responsibilities:

• Senior Informatica Designer & Developer for CADM
• Suggested and created Optimization at both DB / Informatica level
• Extensive usage of Database Partitioning concepts which helped in huge volume Data load handled as part of daily batch
• Involved in development of Automation of daily trades feed process within CADM system through Common API
• Extensively worked in Informatica Migration 8.1.1 to 8.6.1
• Extensively worked in DB2 9.7 Migration
• Developed number of Informatica ETL jobs based on business requirements using various Transformations Joiner, Aggregator, Filter, Expression, Lookup, Union, Stored Procedure, Normalizer
• Involved in Functional Testing, Regression Testing, Integration Testing, Performance and Load Testing.
• Involved in design and development of Revenue adjustment tool
• Automation of Revenue Load process
• Performance optimization of Stored procedures and Informatica Jobs
• Worked extensively on the DB2 PL/SQL, triggers and stored procedures. Enhanced reusable business functions for the application
• Interacting with client end users Cross divisional reporting project to report both EQ and FICC business across Global divisions
• Coordinated with business users for user acceptance testing and documenting the implementation plan
• Created re-usable code documents / Best Practices on following code standards and shared with team

Environment: Informatica Power center 8.1.1/8.6.1, Db2 9.X, PL- SQL, Shell, Perl, Autosys

Confidential

Senior Informatica and DB2 Developer

Responsibilities:

• Extensively worked on Legacy Data Migration Project to De-commission Equity Federated Data Mart EFDM to Contribution Attribution Data Mart CADM
• Involved in building highly complex mappings to retrieved data from Legacy system and migrate as per the new architecture.
• Implemented new logic to calculate the Revenue split Logic as per Legacy system and replicated the same in the new DataMart using Informatica.
• Prepared daily Reconciliation reports using Informatica and UNIX.
• In addition, coordinated year end Budgeting activity with clients and end users.

Environment: Informatica Power center 8.1.1, DB2 8.X, PL- SQL, Shell, Perl, Autosys

Confidential

Informatica and DB2 Developer

Responsibilities:

• Interactions with end users for gathering requirements.
• Developed Informatica ETL jobs based on business requirements using various Transformations Joiner, Aggregator, Filter, Expression, Lookup, Union, Stored Procedure, Normalizer.
• Developed Table scripts, Indexes, views and Dynamic SQL’s.
• Responsibility includes maintaining and enhancing the programs.
• Developed test data and conducted performance testing on the developed modules.
• Involved in performing unit and system integrated testing.
• Developed various triggers, functions and stored procedures in PL/SQL.
• Developed many shell scripts for efficient job scheduling.
• Worked for Year-end Budget activity with clients and end users for Fiscal Year, using DB2 Loads.
• Successful implementation of Product Enrichment activity Phase 1&2 - Using complex DB2 steps using Recursive SQL’s / MQT’s for reporting.
• Built automated reports using Db2 Stored procedures and Perl scripts.
• Responsible for creating scheduled reports for various reporting and quality processes using Shell scripts.
• Performance optimization of stored procedures which runs as part of Daily Attribution Process.
• Production support requests from users and Daily batch monitoring.

Environment: Informatica Power center 8.1, DB2 8.X, PL- SQL, Shell, Perl