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.
Architecture Design (Visio)
AWS Cloud Associate
Data Modeling (Erwin)
Data Analysis & Validation
Waterfall & Agile Scrum
Customer: Wells Fargo
Program: Data Blueprint Cloud/Data Lake Migration
Project: Migration Project/Creditview Project
Nov 17 - Mar19
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
●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
Program: New Financial System
Project: Migration Project
Feb 2017 to Oct 2017
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
●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
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.
●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
Program Description: Module to Determine user enrollment
Project Description: System Maintenance
●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
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
●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
●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