Abhishekranjan Sharma

Oracle Pl Sql AWS ETL Application DBA Reporting

adlfff@r.postjobfree.com +1-973-***-****

New jersey – 07054

CAREER SUMMARY

13+ years of progressive experience in managing & implementing wide range of projects through concept development, analysis, design, testing and implementation phases of Application Software

Over 5 years of experience as a Project Lead with responsibilities like Project Planning, Estimation, Monitoring and Progress Reporting.

Successfully handled challenging projects based on Waterfall as well as Agile methodology.

Experience in large data migration using database, java framework and REST API call.

Experience in Oracle PL/SQL that includes query writing, Functions, Procedures, Package, data modeling, data transformation, database concepts such as Materialized views/views, partitioning, performance tuning.

Certified Oracle SQL certified professional and AWS certified solution architect- Associate

Experience in handling complex programs in the Health care domain, Banking, Payroll, Time and attendance domain,

Handled multi projects assignment /teams with team sizes varying from 5 to 10 Cross-functional team

Expertise in handing development, Support projects including off-shore, Vendor teams and cross-cultural teams

Possess strong knowledge on Software development life cycle (SDLC)

EXPERIENCE SUMMARY

Project – Cigna ESI Data migration. (Jan 2019 – Till Date), Cigna Express scripts.

Joined as technical lead on Cigna integration project. The primary focuses on migrate Cigna specialty customer profile and supplemental data into ESI Accredo specialty application. And Build interface to interact ESI application at Cigna network.

Roles and Responsibilities :

Involved in Requirement Gathering from the Client/Business.

Design and development of application for data migration.

Build interface for REST API call using database wallet and Java layer.

Build a utility for data reporting.

Developing and testing Scripts, Oracle Stored Procedures, Functions and Packages.

Involved in release planning, testing and UAT and post production support.

Lead the Team with delivering the modules as per the WBS.

Achievements :

Gained customer appreciation for delivering application on given time frame.

Quickly learnt new technology to meet customer expectations.

Project – Custom application development service. (Mar 2018 – Dec 2018)

Project Description- Project involved in to converting existing web based system to cloud based solution. It enable user to get real time view of various portfolio of project in progress and review resource allocation, cost allocation and project delivery.

Roles and responsibility

Database Architecture design

Analyze users and project specific requirement.

Perform high level design such as interface development and new module development.

Project – Risk reporting (Basel II & Basel III regulatory Reporting)(Sep 2016-Feb2018) Citi bank, USA

Project Description - The platform build to support more sophisticated and granular product models and dynamic forecasting of net interest revenue under different scenarios.

Roles and responsibility

Analyze business specific interest rate risk exposure..

Design and development reporting platform at initial stage at database side.

Build DATAMART using HADOOP database environment.

Developed Store Procedure, Functions and Packages for application releases.

Project - Regulatory Transaction reporting (Jan 2013 – Sep 2016) - Credit Suisse, USA

Project Description - The project involved to build reporting application as per the regulatory reporting guideline (MiFID 1 and MiFID 2) and report the bank trading transaction to regulatory body. All transaction from multiple sources is fed into the developed reporting application. The application further enriched and validates the received trade as per the regulatory reporting guideline and then reportable trades sent off to regulator.

Roles and responsibility

Design and development of transaction reporting engine tool.

Co-ordinate with client to understand the Transaction reporting requirement.

Worked on the data huge data migration task around 400 GB data. .

Developed Store Procedure, Functions and Packages for reporting application releases.

Managing a 4-5 resources Team to develop the GUI application.

Project - Cash Management processing Platform (Nov 2010 – Jan 2013) - JP Morgon Chase, UK

Project Description- The project is aiming to manage the day to day positions for the NOSTRO accounts. The project was built on various modules - Viewing the Summary position, View Transaction details, Funding and also few static data maintenance viz. Legal Entity Group management, NOSTRO Account Group management, Manual Adjustment, Approve Position, Manual Upload, Client Account Group mgmt.

Roles and responsibility

End to end solution design and development for Cash Management processing business and workflow to interfaces.

Manage and coordinate with all stakeholders, attend key decision meetings.

Developed Store Procedure, Functions and Packages in Oracle SQL and PL/SQL to incorporate the business processing logic.

Project – Inventory Management (June 2010 – Nov 2010) - Novelis, Brazil

Project Description - The project involves the development and implementation of oracle e-Business suit. This provides the inventory management between the various units in a plant. To deal with data exchange within the plant various interface has been designed using the oracle data integrator module and interfaces are scheduled to run at defined interval.

Project - Indus collection module (Feb-2008 to May 2010)

Client -Tata capital Ltd, Mumbai American international group (AIG), Philippines, Kasikorn bank and Bank of Ayudhya, Bangkok

Project Description - The project involves the implementation of Indus collection module for credit card business for above mentioned client. The host data (bank legacy system data) received through flat file on a daily basis. A program builds to run at a predefined time and process file data. Based on the business rule configured in a system, it sends the SMS, generates the letter and allocated delinquent cases to the respective collector. It also mapped with the dialer system, which take care of all calling activity and automatic call transfer with the required collection team

Project – Time and attendance (Nov-2006 to Dec 2007) L&T Ltd and Ford Motors India limited

Project Description–Time and attendance module is for managing and tracing all employee movement activities, by planning their shifts and rosters, capturing overtime and comp off activities, depending upon employee’s grade and work environment, which ultimately, needed to be reflected in employee’s payroll.

Educations

Advance Computing C-DAC 2006

Bachelor Degree in Electronics and power Engineering - 2004.

Technical Skills

Oracle9i-10g-11g,12C,SQL, PL/SQL

ETL

AWS and Hive

Rest API call - Database and Java

UNIX shell scripting

BI –Tableau/Quick view

Java Script/Spring data flow

HTML, XML, CSS

Sybase

Rainstore

MS Project

Certifications& Accreditations

Oracle SQL certified professional.

AWS certified solution architect – Associate.

Business Domains& Client

Banking and Finance

oCredit Suisse

oJP Morgon

oCity group

Pharmacy and Healthcare

oCigna

oAccredo

Telecom

oVodafone

oAirtel

KEY PROJECTS

Cigna Integration USA – Project Lead

Oracle 12c, AWS, Oracle forms and Report, AWS EC2,Attunity, Spring data flow, REST API call

City Basel II & Basel III regulatory Reporting – Team Lead

Oracle 10g and 11g, Hadoop and Hive

Regulatory Transaction reporting, United Kingdom – Senior Associate

Oracle 11g, Angular JS and Informatica

Cash Management processing Platform, United Kingdom - Associate

Oracle 10g,11g, Java, Reporting

Credit card collection and recovery application – Developer

Oracle 9i,10g, crystal report

Contact this candidate