Priyanka Koul

Phone: 614-***-****/ Email: ac83rb@r.postjobfree.com

SUMMARY:

** ***** ** ** ********** 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:

O/S

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

Deployment Tools

Data Virtualization Tools

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

IBM Urban Code Deploy

Cisco Information server

EDUCATION:

Bachelor of Technology (B.E) in Electronics and Telecommunication, India

CERTIFICATIONS:

Oracle Certified Professional (OCP)

Oracle Certified Associate (OCA)

IBM-Seed Certified: Diploma in Software Testing

PROFESSIONAL EXPERIENCE:

State Street Bank and Trust Company, Quincy, MA Nov 2018 – Present

Contractor

Highlights: The FR 2052a reports collect data that will enable Federal Reserve to access the liquidity profile of reporting firms. FR 2052a data will be shared with office of comptroller of currency and the Federal Deposit Insurance Corporation to monitor compliance with the Liquidity Coverage Ratio rule.

CCAR (Comprehensive Capital Analysis & Review) and DFAST (Dodd-Frank Act Stress Testing) are regulatory tools the Federal Reserve uses to ensure that financial Institutions have robust capital planning processes and adequate capital

Role & Responsibilities:

Worked on Cisco Information Server data virtualization software that lets you integrate data with breakthrough speed and. cost effectiveness. With Cisco Information, build and manage virtualized views / data services that access, transform and deliver the data your business requires to accelerate revenue, reduce costs, lessen risk, and improve compliance.

Analyze business requirements and implement it into Cisco Information build packaged query, SQL and PLSQL programming.

Involved in making in Treasury Data Repository database objects and Cisco Information server objects.

Validation of CCAR Technical instructions and comparison from previous versions.

Highmark Health Solutions, Pittsburgh, PA Jul 2018 – Nov 2018

Consultant

Highlights: The Claims Billing System (CBS) is a web-based application used to produce invoices for self-funded health insurance clients. The system can invoice paid claims and related expenses as well as administrative fees and miscellaneous items.

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.

PNC Financial Services, Pittsburgh, PA Oct 2014 – Jul 2018

Consultant

Highlights: CCAR (Comprehensive Capital Analysis & Review) and DFAST (Dodd-Frank Act Stress Testing) are regulatory tools the Federal Reserve uses to ensure that financial Institutions have robust capital planning processes and adequate capital. Assessing ALL risk types: credit, operational, market, liquidity, etc.

Performing risk-based capital assessment (stress testing). Having Board and management oversight for policies and strategies. Monitoring and Reporting. Internal control reviews: internal audit and other management sign offs.

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.

JP Morgan Chase, Columbus, Ohio Sep 2012 – Oct 2014

Sr. PLSQL Developer

Highlights: 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.

Role & Responsibilities:

Oracle backend developments for several Mortgage Banking Loan, Servicing and Finance Systems.

Redesigned & redeveloped home Lending Finance Portfolio and Servicing Fee Automation.

Created & modified database Function, Procedures for project enhancement & consolidate all into a Package.

Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.

Worked on several Mortgage Banking Finance Month end processes like dimension change request, cost center hierarchy and location, BA CAP planning.

Performed performance tuning on existing reporting query. Used ROW function, RANK and DENSE_RANK functions.

Used TOAD extensively to create and modify procedures, packages, tables, indexes etc. Also used for session info, schema browsing etc. Data importing and exporting from excel files or text files to database.

Developed Process Flow diagrams using Microsoft Visio.

Worked on schema migrations from one database to other database.

Prepared Test Cases & testing of different pages of financial analysis management system website.

Environment: iSpace, Oracle 10g, SQL & PLSQL, Oracle Essbase, TOAD 11.1, SQL Developer, TortoiseSVN, EPV Break glass, Subversion, Cognos 10.1.1.

GE Healthcare, Piscataway, NJ Aug 2011 – Sep 2012

IT Analyst

Project: LS ITO GPS ENHANCEMENT

Highlights: LS ITO GPS enhancement is the automation process of storing the invoices from GPS Data warehousing, JD Edward database and Gen schemas into PRDGPSL schema of GE Healthcare. Worked on automating North America, Europe and Hongkong region data. Replaced amtrix with informatica workflow process. Worked as a PLSQL database and ETL developer in automating the process. The back end process is all driven in Oracle database.

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, Mumbai, India May 2011 – Jul 2011

Oracle Developer

Project: Development of Priority Circle PMS Department

Highlights: Planetsoft application of ICICI Prudential LIC is a web based application developed by 3i Infotech. Worked as oracle developer in creating priority circle sales domain for filter criteria, aggregate and calculation processes. Created oracle form for inserting a data by user into database.

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.

AWC Software Pvt. Ltd. Dec 2009 – Apr 2011

Associate Consultant - Oracle Apps

Project: HSIIDC finance reporting.

Highlights: HSIIDC finance reporting is a Haryana State Industrial & Infrastructure Development Corporation project. Worked as a Finance technical consultant for creating Journal, bank, cash voucher, and general ledger reports. The back end process is all driven in Oracle database.

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.

Mahanagar Telephone Nigam Limited, New Delhi, India Sep 2008 – Dec 2009

Software Engineer

Project: Web Based Financial Management System

Highlights: Web Based Financial Management System was built for MTNL users and employees.

As part of the team resolved production issues, created finance reports used by the employees and users of MTNL, worked closely with business in day to day activities, maintenance of the system, addressing defects/incidents and system enhancements.

Role & Responsibilities:

Designed and created the database objects such as tables, views, triggers, procedures, functions, packages, sequences, synonyms.

Developed PL/SQL stored procedures, functions, triggers and packages at different levels to perform various validation operations for financial accounting, paybill, works accounting & IMS modules of financial management system (FMS).

Analyzing, writing, designing reports & communicating results to other team members & managers.

Performed Performance Tuning on existing reporting query and PLSQL programs. SQL scripts for data extraction from source tables, views, packages, functions.

Resolving the issues on priority basis. Deployed Oracle Reports on reporting servers.

Environment: Windows XP, SQL, PLSQL, Oracle 9i & 10g, Oracle Jdeveloper, C++, Toad, Oracle Forms and Reports 9i, Manual Testing, AIX Operating system.

Central Electricity Authority, New Delhi Oct 2006 – Sep 2008

Software Engineer

Project: CEA – Information Management System

Highlights: CEA- Information management system was built for central electricity authority throughout India. Solutions built on IBM Content Manager deliver documents and information to users in context, streamline work processing and improve productivity with automated processes. It manages the life cycle of all content, including images, electronic documents, XML, streaming audio and video, so that users can work with all types of information anytime, anywhere. As a part of team worked on creating monthly power generation and consumption reports and form for users to insert data into database.

Role & Responsibilities:

Involved in System Analysis and Database Design of Performance Management module of the Project.

Installation of Linux Operating system on server, IBM WebSphere and DB2 content manager, DB2 database on server. Installation of oracle client on Windows XP.

DB2 Content Manager Administrator. Deployed PDF files, images, excel files, documents on DB2 content manager.

Designed and developed Jasper Reports using SQL, PLSQL. Design & Development of application using Oracle Forms Builder.

Developed several reports, wrote SQL queries & configured the report as per the client requirement using Jasper Reporting tool.

Testing full product suite's, identifying problems & resolving them with other development team & support team.

Environment: Windows XP, SQL, Oracle 10g, DB2 Universal Database, DB2 Content Manager, Jasper Reports Eclipse3.0 (IDE), C++, IBM WebSphere, RHEL Operating System.

Contact this candidate