SUMMARY:

• 8 years of experience in Oracle 10g, 11g, PL/SQL, TOAD, developing back - end modules for multi-tier business applications using PL/SQL.
• Comprehensive Experience in Banking & Finance domains.
• Rich experience in Data migration activities from different sources to oracle and Transform the data as per product requirement using Stored Procedures, packages, functions, triggers, tables and views.
• Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, analysis, Design, Development, Testing, Implementation and Support .
• Have hands on experience in data warehousing concepts such as star schema and snowflake schema, data marts used in relational and dimensional modeling. Have rich experience in ETL mappings in informatica, analysis and documentation of OLAP requirements.
• Strong ability to effectively lead a team and encourage team work.
• Coordinating with QA Team to develop test schedules & scenarios and execute them.
• In-depth working knowledge of business processes in BANKING and FINANCIAL sectors.
• Have hands on experience in UNIX operating environment.
• Strong problem solving and analytical skills
• Actively involved in Automation on python and Application DBA for data migration activities.
• Worked on a Poc for a BIG data project (platform loader) .Have a hands on experience in hadoop, spark, scala and hive.

TECHNICAL SKILLS:

Database: Oracle 10g/11g (SQL, PL/SQL, Stored Procedures, Triggers,GTT,cursor,collections),Hive

Languages/ Utilities: SQL, PL/SQL, Unix shell scripts,C,C++, Core Java,Python,Scala,Spark

Operating Systems: UNIX, LINUX, Windows- 8.1/Windows-10, Windows server 2012

ETL Tools: SQL*Loader, Shell Scripts,Informatica Power Center,OWB(Oracle warehouse builder),sqoop

Other Tools:: Toad,SQL Developer,Control-M, WinSCP,Microsoft Office, Visio,Excel,Putty,sqoop,visual studio,intellij

Version Control Tools: GIT,Star Team

PROFESSIONAL EXPERIENCE:

Confidential, Oaks, PA

Senior Software engineer

Tools: PL-SQL/Oracle/Informatica/ Unix Shell Scripting/Sql loader/python

Database: Oracle

Responsibilities:

• Wells Migration is one of the most complex among all other Confidential clients.
• Provided the solution to source data from legacy system (Trust) to SWP ( Confidential Wealth platform).
• Work with Business Analyst to understand the source system and collect the requirements to migrate data in SWP system.
• Analyze the business requirements, create technical design and source to target mapping documents for development.
• Using Informatica ETL tool in Auto advisor process to transform the data from business excel sheets and web portal to SWP Data warehouse.
• Develop UNIX, python shell scripting to create the migration staging environments and move the source files to landing area.
• Using SQL loader and control files load the extract into oracle database .
• Using Oracle Stored procedures,functions, packages, collections,materialized views, triggers to migrate data from the source system Trust to SWP, which involves different levels of staging area, custom/ staging/ MIG and target area.
• Creates stored procedures to validate the data during the different levels of migration.
• Load balancing SQL is created to compare the assets between source and target.
• Create unit test cases and regression test cases for various cycles to validate the results.
• Fix the issues through various test cycles and in production systems.
• Lead the team towards successful project release.

Confidential, Oaks, PA

Senior Software engineer

Tools: PL-SQL/Oracle/packages/python/sql loader/winscp

Database: Oracle

Responsibilities:

• Worked on the automation to perform the extract and file load to oracle database.
• Actively worked with Business Analyst to analyze the source data
• Analyze the business requirements, create Technical design and Source to Target mapping documents for development.
• Develop UNIX shell scripting to create the staging environments and move files in landing area .
• Worked on design/structure for the staging area Custom/ Staging/ MIG and Target area.
• Actively involved with application DBA for designing schemas, scope and authenticity of users.
• Using Oracle Stored procedure and packages to migrate data from the source system to SWP.
• Creates SQL Validation queries test scenarios to validate the business requirement and integrity of data for the staging area
• Fix the technical and functional issues through various testing environments, client facing trials and production systems.

Confidential, Oaks, PA

Senior Software engineer

Tools: PL-SQL/Oracle Stored Procedures/packages/collections/sql loader

Database: Oracle

Responsibilities:

• Worked on name, address Parsing and mixed casing for Wells Fargo based on the dictionaries available online .
• In Legacy mainframe system wells stored their client’s address,name,suffix,Prefix,City,State in a single row, without any proper formatting .
• We used the online dictionary and defined several rules template to convert this hugh dataset partitioned and cased.

Confidential, Oaks, PA

Senior Software engineer

Tools: Oracle Stored Procedures/packages/Scala/Spark/Hadoop/sqoop/intellij (As Scala IDE)

Database: Oracle, Hive

Responsibilities:

• To process and analyze this huge data in oracle cost more time .
• We performed the POC on hadoop and spark and sqoop to load, analyze and transform the data and load in oracle .
• Worked on hadoop cluster setup, spark and write the business logic in scala and hive.

Confidential, Oaks, PA

Software engineer

Tools: PL-SQL/Oracle/packages/winscp/informatica

Database: Oracle

Responsibilities:

• We automated the process and introduced the informatica as ETL where input can we web services, csv files and it will trigger the auto firm deployment after EOD/BOD runs in production/I-strips.Primarily
• Worked on the informatica power center to define the task and mapping.

Confidential

Software engineer

Tools: PL-SQL/Oracle/packages

Database: Oracle

Responsibilities:

• It’s automation which convert the internal account’s and Confidential house account’s name into small tokens and based on the maximum token match it define the correct linkage .

Confidential

Software engineer Greater

Tools: PL-SQL/Oracle/packages/collections/sql loader/unix shell scripting

Database: Oracle

Responsibilities:

• Based on client's requirements generate the outbounds.
• Involved in design process to load inbound files/extract using sql loader, control files provided by the End clients for custom interface.
• Actively worked with Business Analyst to analyze the business requirement for custom interface .
• Developed shell scripting to create the staging schema as per the inbound files .
• Generate outbound extract using Oracle Stored procedures,packages,collections,cursor,GTT etc.
• Created SQL Validation queries to validate the business requirement and integrity of the outbound.
• Worked on the partitioning and indexing for the target tables.