SUMMARY:

• 12 years of IT experience in analysis, design, development, implementation of Client/Server, Data Warehouse, Web applications and testing. Oracle Certified Professional with experience in Oracle technologies including of experience in Database administration including installations, migration, Oracle Development involving SQL, PLSQL programming, Oracle Reports, Forms v8i, 9i, 10g.
• Experience in Dimensional Modeling using Star and Snow Flake Schema. Experience in Data warehousing using Informatica Power Center 9.1 (Workflow Manager, Workflow monitor, Repository Manager and Designer), Server Manager, Mapping Designer, Transformation Developer, Mappings, and reusable transformations, Warehouse Designer, OLAP, and OLTP.
• Solved complicated database problems with simple and effective solutions. Tuned and optimized complex database queries.
• Extensively used oracle tools like TOAD, PLSQL and SQL Developer, Oracle Forms and Reports. Good knowledge in designing and coding of Oracle builder reports, BI reports and Jasper reports. Deployed Reports and Forms on AIX, Linux Servers.
• Expertise in data analysis, database design, data management, logical and physical data modeling using Erwin and Visio and in depth knowledge in building Relational Database Systems.
• Good Knowledge on Linux operating system.
• Worked as a DB2 Content Manager Administrator.
• Worked on Oracle Essbase reporting from different essbase cubes.
• Good knowledge of manual and automation testing. Good working experience on Web based financial applications.
• Good experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle and SQL Server Databases.
• Experience in working in Agile environment. Forward thinking with strong business sense.
• Flexible in working hours and locations.

TECHNICAL SKILLS:

Microsoft: Windows 2000, NT, XP, Linux, Aix.

Database: Oracle 8i /9i/ 10g/11g, IBM DB2 Universal Database, Microsoft Sql Server, MS Access, Teradata

Data Warehousing: Informatica Power Center Designer 9.6.1, 9.5.1, 9.1, Microsoft SSIS

Languages: SQL, PLSQL, C++, C.

Oracle Utilities: SQL * PLUS, TOAD, SQL Developer, PLSQL Developer, SQL Navigator

Data Modeling Tool: ERWIN, VISIO

Functional Testing Tools: QTP, IBM RFT

Defect Tracking Tools: QC, Bugzilla

GUI & Reporting Tools: Oracle Forms v8i/ 9i/10g, XML Reports, Oracle Reports v8i/9i/10g, Oracle BI EE 10, Oracle Essbase Reports, Cognos, Tableau.

Version Control Tools: Sub - Version, Git Hub, Git Kraken, Atlassian Source Tree, CA-SCM(Harvest)

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Consultant

Role & Responsibilities:

• Worked on multiple project enhancements by making code changes in Teradata SQL and PLSQL scripts.
• Analyze business requirements and translate it to functional ad design specification for WY Stop Loss.
• Involved in testing of CBS Bill Engine for Wyoming Stop Loss, North Dakota (Vision and Dental Claims and Enrollment), Minnesota (Claims and Enrollment), HMK (Claims and Enrollment) as per test cases and coordinated with BA, Claims team, PSAR team, eBill and DBA team in finishing regression and functional testing.
• Analyzing business requirements for Pharmacy Rebate Project.

Confidential, Pittsburgh, PA

Consultant

Role & Responsibilities:

• Creating the database schema and maintaining the database. Created Partition and Sub Partition tables for archiving different versions of CCAR data for Staging tables and reconciliation of VENA-XML output which was later used for FED edit checks dashboard by business to review submitted data. Writing Stored Procedure, functions, Packages, Materialized Views and Views in oracle. Migration of Database from SQL Server to Oracle.
• Creating SSIS Packages for loading data from Microsoft Sql Server to Oracle and for loading Metadata into SQL Server database.
• Developed mappings to load into staging tables and then to Dimensions and Facts. Worked on Informatica power center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor. Involved in building the ETL architecture and source to target mapping to load data into CCAR Exchange Layer (CCAR Reporting schema). Created sessions, configured workflows to extract data from various sources, transformed data, and loading into CCAR Exchange Layer and Vena (Sql Server) Database. Developed mapping parameters and variables to support SQL override. Used Debugger to test the mappings and fixed the bugs. Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Used CA SCM Workbench to promote ETL Packages to QA and Prod.
• Created Data model for CCAR Web Application using Erwin.

Environment: Oracle 11g, Microsoft SQL Server Management Studio, Informatica Power Center 9.5.1, SSIS, Toad, Vena, Tableau, Erwin.

Confidential, Columbus, Ohio

Sr. PLSQL Developer

• Finance portfolio is a collection of investments held by an investment company, financial institution or individual. This is the automation process for deriving ending balance, draws balance, runoff balance, transfer balance, purchase sales from remote database tables into our Loan servicing database schema through database subprograms. Servicing fee automation is a percentage of each mortgage payment made by a borrower to a mortgage servicer as compensation for keeping a record of payments, collecting, passing principal and interest payments along to the note holder, etc. Delinquent servicing fee relates to delinquent loans and bankruptcy reflects the amount of the invoice paid to third party vendors. In this project we were concerned about those loans which are delinquent from 30 days onwards and foreclosure rates. As a part of team I used to create monthly reports through database packages and send report to business for analysis .Redesigned and redeveloped several finance database projects. The back end process is all driven in Oracle database.

Confidential, Piscataway, NJ

IT Analyst

Role & Responsibilities:

• Analyze business requirements and translate it to functional specification.
• Created Informatica mapping, session and associate workflow.
• Through ETL mapping loaded data from source to target database.
• Used various transformations like Filter, lookup, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Involved on testing the new functionalities based on test cases and coordinated with support team, DBA team & middleware team in fixing the issues. Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Testing of Migrated Data from source tables through Informatica into GPS database for North America, Europe & Hong Kong Region. Involved in Functional, Integration testing & user acceptance testing before the release of Project. Involved in fixing the database bugs.

Environment: Windows XP, Informatica Power Center Designer, Oracle 10g, SQL & PLSQL, TOAD, PLSQL Developer.

ICICI Prudential Life Insurance Corporation

Oracle Developer

Role & Responsibilities:

• Analyze business requirements of Priority circle sales Domain and translate it into functional specification.
• Created a SQL query For Priority Circle Sales Domain for Filter Criteria, Aggregation and Calculation processes.
• Tuned SQL queries using indexes and table partitioning and monitored database activities, performance, and size. Increase the size if required and identified and resolved performance issues.
• Design & Development of application using Oracle Forms Builder.
• Created a Payout on Planetsoft application of ICICI Prudential LIC.
• Created new tables for PMS Priority circle.
• Created Oracle form for inserting a data into PMS tables of ICICI Prudential.
• Conduct technical interviews for new positions.
• Mentor team members on PL/SQL and SQL.

Environment: Windows XP, SQL, Toad, SQL * PLUS, SQL Developer, Oracle Forms Builder.

Confidential

Associate Consultant - Oracle Apps

Role & Responsibilities:

• Created Journal, Bank, Cash voucher reports, Cash Book, Bank book, Debtors & creditors trial balance report.
• Updating stored procedures, Functions, Packages, tables according to the business requirement. Involved in fixing the database bugs and live application bugs. Created value sets, flex fields for the application. Developed SQL queries & PLSQL program units for reporting.
• Measure outcomes and consequences of report requirements and designs.
• Deployed Reports on Application servers.

Environment: Windows XP, SQL, PLSQL, Oracle 9i, Oracle 10g, Oracle Report builder 9i, MS Office 2007, MS Excel, PL/SQL, Toad, Oracle R12..