Insightful, result-driven Software Developer with 12 years of total experience as a Developer, Architect,Database modeling, ETL Data Modeling, Documentation and Implementation of Business Applications, Data Analysis, Design, Coding, Testing and Reporting.Offer strong leadership with excellent communication and successful team building skills adds to the expertise of developing and delivering successful Solutions.

COMPETENCIES

Oracle Database

PL/SQL Programming

Informatica (ETL)

Web Services

Architecture Design (Visio)

SAS Documentation

AWS Cloud Associate

Data Modeling (Erwin)

Data Analysis & Validation

Production Support

Shell Scripting

Waterfall & Agile Scrum

PROFESSIONAL EXPERIENCE

Customer: Wells Fargo

Program: Data Blueprint Cloud/Data Lake Migration

Project: Migration Project/Creditview Project

Nov 17 - Mar19

Charlotte, NC

Program Description: Program to maintain and enhance and migration for financial data

Project Description:Project to migrate Heterogeneous database processing system to Data Lake.

Roles: Support & System Architect

Role Description:

●Key responsibility includes the analysis, design and implementation of enterprise architecture processes using TOGAF Architecture principles such as business architecture, application/integration architecture, information architecture and technical architecture. Responsible for multiple POCs.

●Involved in Real time Data Replication from heterogeneous sources to DataLake using Kafka 0.9 and MapR Streams.Comparing different technologies, product recommendation to stakeholders.

●POC of reporting Database migration to AWS.Responsible for Certification and compliance checks Validation.

●Currently responsible for support, including applications backend development and Production support of the existing system.

Technologies Used: Kafka, MapR, Goldengate, AWS Cloud, PL/SQL, Informatica, Unix Shell Scripting, AWS

Customer: T-Mobile

Program: New Financial System

Project: Migration Project

Feb 2017 to Oct 2017

Atlanta, GA

Program Description: Program to maintain and enhance T-Mobile financial data system

Project Description: Project to migrate Informatica(ETL) & Oracle database processing system to Hadoop technologies using Hive & Impala over Amazon (AWS) Cloud infrastructure.

Roles: Developer, AWS Cloud Associate

Role Description:

●Migrating data warehousing system from ETL & PL/SQL processes in Oracle database and Informatica to Hadoop cluster.

●Use Hive and Impala technologies to convert the existing data transformation rules to Hadoop ecosystem

●Convert existing reports and write new reports in Hive and Impala across different dimensions.

●Performed POC of migrating Hadoop from local infrastructure implementation to Amazon (AWS) cloud infrastructure.

Technologies Used: AWS Cloud, PL/SQL, Java, Informatica, Unix Shell Scripting

Customer: COX communication

Program: ACS (Atomized Customer Service Solution Center)

Project: Migration Project

Oct 2016 to Jan 2017

Atlanta, GA

Program Description: Program to enhance IVR Solution and Data warehouse archiving system

Project Description: Add a new IVR stream data intake into the existing system. Move the existing archiving system from oracle database to Hadoop.

Roles: Developer

Role Description:

●Check feasibility of adding additional data intake stream to existing system.

●Develop a plan to move the existing archiving solution from oracle to Hadoop.

●Create new reports using hive and Impala.

Technologies Used: Hive, Impala, PL/SQL, Informatica.

Customer: Department of Human Services Arkansas

Program: Eligibility and Enrollment Framework (EEF)

Project: Enhance and maintain EEF

Jul 2016 to Oct 2016

Atlanta, GA

Program Description: Module to Determine user enrollment

Project Description: System Maintenance

Roles: Developer

Role Description:

●Database support for Change management and release management.

●Understand business rules and objectives and communicate these with team members and business stakeholders

●Understand legacy application data flow across multiple layers based upon business and technical documentation, and provide optimal solution.

●Identify recurrent data quality issues and provide solution to resolve them, generate scripts for bulk Data fix, Creating Data Flow logic. I debugged existing ETL processes and performance tuning to fix bugs.

Technologies Used: Oracle, Linux, Erwin.

Customer: CEDAR Document Technologies, Atlanta

Program: Sunrise project implementation

Project: New Implementation and maintenance of Cedar products

Jul 2012 – May 2016

Atlanta, GA

Program Description:

Project Description: Cedar product installation and development related tasks for various Cedar clients

Merz North America Jan 2015-Feb 2016

HDFC-America, Canada Apr 2014-Jan 2015

Summit Financial Group, America Jan 2013-Feb 2014

PFG, America Feb 2012-Dec2012

PENN, America Aug 2011-Jan 2012

Roles: Developer

Role Description:

●Understand the customer BRD (business requirement document) and translating it to appropriate technical specification.

●Maintenance and development of business flows, scripts, code, design, creating HLD, LLD, Data Model.

●Comparing Schemas with DB Change Manager and Maintenance of development environment. Syncing with production. Creating/Configuration scripts for dynamic control scripts to keep environment in sync.

●Involved in PL/SQL code review and modification for the development of new requirements.

●Performance Tuning of queries and solved database performance issues using awr reports and oracle dictionary views, OEM using ADDM. Performance tuning of several Queries and stored procedure. Used explain plan and HPROF in identifying issues with the queries. Used oracle views to identify issues with performance at DB instance level.

●Worked with bulk data, loading of data using CTAS, SQL loader, DBMS_SCHEDULER, data pump for handling millions of rows to migrate data using custom scripts.

●Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

●Developed mappings to load into staging tables and then to Dimensions and Facts.

●Developed REST web services client code using swagger tool for code generation.

●Used Spring and Apache CXF while developing web services and used Postman to test the same.

●Used Tibco jms queue messaging system for internal data transmission

Technologies Used: Oracle PLSQL, Web services, Java

Customer: Comptroller and Auditor General-New Delhi, India

Program: Modernize Legacy systems.

Project: HR and Payroll Member Management System Upgrade

Mar 2005 – Aug 2011

New Delhi, India

Program Description: Upgrade legacy systems with more modernized enterprise system

Project Description: New Implementation and maintenance of HR and payroll systems

Roles: Developer

Role Description:

●Develop PLSQL procedures and functions to implement new functionality related to HR and payroll systems.

●Interface with clients and resolve the issues related to new system implementation.

●Work with new system vendor to transfer legacy business logic to new system.

●Convert business reports to the new system and create new reports.

●Integrate various satellite offices with the centralized system and educate users on using the new system.

●Establish process and procedures for enrollment of new members

Technologies Used: Oracle, Linux, Oracle Forms

Contact this candidate