PIYALI GANGULI

Email: ac111b@r.postjobfree.com

West Windsor, NJ 08550 Cell: 732-***-****

Immigration Status: US Citizen

SUMMARY

IT professional with more than 12 years of experience.

Master degree holder in Computer Software Applications.

Experienced in all phases of SDLC.

Possess excellent analytical skills, strong problem-solving skills, multi-tasking skills, good organizational skills, detail-oriented approach and outstanding oral & communication skills.

SOFTWARE: Oracle 12c/11g/10g, PL/SQL-creating triggers, functions, procedures and packages, TOAD 9.7.2, SQL Developer, Oracle BI Reports and Analytics, Dashboard, PowerBuilder 5.0/6.5/8.0, v10, v12, Visual Basic 6.0, Crystal Reports 11/8.5/7, Oracle Applications 11i (11.5.9), Oracle Forms 6i/Reports 6i, SQL*Plus 10.2/3.3, UltraEdit-32, MS Excel/Word, PowerPoint, C, C++, VBScript, OOP, HTML. MS Office Suite (Word, Excel, Access, Visio, Power Point), JIRA, Work in Agile / Waterfall environments.

RDBMS: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2000/7.0/6.5, Sybase, MS Access 2k

OPERATING SYSTEM: Windows XP, Windows NT 4.0, Windows 98, Sun Solaris 5.8, Linux, UNIX

EDUCATION: MCA [Masters Degree in Computer Software and Applications]

Bachelors Degree in Statistics, Mathematics & Physics

ETS – Education Testing Service, NJ 05/15 – Present

IT Consultant - Stat and Fraud Detection Tech. Industry: Education

Founded in 1947, ETS develops, administers and scores more than 50 million tests annually in more than 180 countries, at 9,000+ locations worldwide. Taken dual role of Developer and Business Analyst to venture new avenues and gain more insight.

Industry: Testing/educational products and services

Responsibilities:

Formulate and define system scope and objectives for assigned projects

Translating business, functional requirements into technical requirements and design

As part of the team, participated in JAD sessions with IT to identify requirements and design solutions

Collaborate with team members as well as across FCEs/SBUs to identify ways to improve existing processes and technical output

Write Functional and Technical specifications

Examine, devise and modify procedures to solve moderately complex problems

Support software production schedules and processing

Work with development team on implementation of new technologies

Recommend modification to existing processes and new procedures to solve complex problems considering the existing system limitations, operating time and desired results

Proactive identification of gaps and escalate in a timely and appropriate manner

Monitor and Update all relevant documentation after upgrades

Escalate problems of complex technical circumstances to appropriate channels

Promote policies that foster quality standards and industry best practice

Responsible for Data Mediation and Data Mapping to match company format

Software applications and product enhancements that reliably support both functional and business needs of the organization

Prepare, review test plans and defects identified during testing and triage defects identified during testing. Provide leadership, technical support and guidance to QA

ENVIRONMENT: Oracle 12c/11g/10g, PowerBuilder 12+, PL/SQL, TOAD 9.7.2.5, SQL Developer, Java 1.7, MS Visio, JIRA.

Tristar Risk Enterprise Mgmt.

(Formerly Risk Enterprise Management Ltd), NJ 08/09 – 05/15

Oracle Application Developer/ Analyst Industry: Insurance

REM is a Third Party Agent providing Workers Compensation, Auto Liability, General Liability and various other Liability Insurance services and tools for claim management program.

I was involved in Design and Development of Vendor Billing Interface for REM’s Claim Management Application and worked on:

•Dynamic Cursors and SQL to fetch data based on parametric inputs, making processes more generic, functional, stable and easy to use & maintain.

•Performance tuning with Explain Plan for better performance & increasing throughput.

•More than 1000 edits by creating triggers and procedures at right levels, to ensure data accuracy.

•Views & stored procedures to increase productivity and performance.

•ETL scripts to load complex client data from input files to database to maintain data integrity.

My Achievements in REM include:

Lead Developer and Business Analyst on a project for one of the Nation's leading insurance firms. Project involved handling ETL for Client Policies, sending Claim & financial records for various lines of businesses, creating balanced reports/Control reports and Loss runs to ensure ease of data reconciliation.

I looked over the following phases:

Requirement gathering and analysis providing estimations on project time-lines.

Data mapping for Payment types, Types of Recoveries, Reserve types, Transaction Types etc,

Designing Claim & financial feed layouts for various LOBs and creating Balanced reports/ Loss Runs,

Development activities Conducting/coordinating extensive test scenario,

Scheduling production deployment Providing post-production support and maintenance

The project successfully completed on time with great reviews and appreciations from Client & my superiors.

Additionally, I was actively involved in the following applications:

iTAKE Application (Tristar’s Claim Intake Application) - Worked on the automation of IAIABC EDI FROI & SROI form submission to the Labor Dept. of Worker’s Compensation for all Jurisdictions (52 states) and created FROI and SROI reports using Oracle BI reporting tool.

iCLMS Application (Tristar’s Disability Claims & Payment Processing Application) - Worked on the automation of W2 & 1099 processes and maintenance of other key functionalities.

ENVIRONMENT: Oracle 10g/9i, PL/SQL, TOAD 9.7.2.5, SQL*Plus 10.2, Oracle BI Publisher, Crystal Reports 11, RMX R7, Ultraedit 32, Intersolv PVCS v6, Merant Tracker v 8.0.3.

Independence Blue Cross & Blue Shield, PA 08/04 – 01/08

Programmer Analyst & Technical Support Industry: Insurance

My Achievements in Independence Blue Cross include:

Planning, designing, developing and documenting a Tracking Monitor which facilitated my client to identify business processes that were causing backlogs in the system and helped them focus on backlog reduction, cutting lead time significantly.

Developed & introduced Email-Notification and Barcode printing, giving my client a faster & secured channel to communicate with brokers and submit deliverables on time.

Single handedly carried out the Migration process from PowerBuilder 6.5 to 8.0 to v10 and Oracle 8i to 9i and provided Post-Migration Support.

Assisted in converting Claim Entry System from PowerBuilder to Java 1.2 using IBM VisualAge v3.0.

Created Stored Procedures & Functions using PL/SQL & integrated with PowerBuilder Datawindows.

ENVIRONMENT: PowerBuilder 6.5/8.0/10,Java 1.2, IBM VisualAge 3.0, Oracle 8i/9i, PL/SQL

Dendrite International, NJ 12/03 – 07/04

Techno-Functional Consultant (ERP – Oracle Project Accounting PA, Account Receivables AR)

Worked on Oracle Project Accounting (PA) and Accounts Receivables (AR) Modules for the leading-edge solutions and service provider in the Pharmaceuticals Sector.

My Achievement in Dendrite International Inc. include:

Lead the Oracle Accounting Team of 4 individuals Functioned as the SME - Subject matter expert and provided technical expertise Performed various project accounting set-ups Trained team members in Oracle Billing processes Guided and mentored the team during the transition from manual to automated Oracle Project Accounting & Financial systems. The transition was completed a month ahead of schedule.

ENVIRONMENT: Oracle Applications 11i (11.5.9), Oracle Forms/Reports 6i, Oracle 9i, PL/SQL

Independence Blue Cross & Blue Shield, PA 02/01 – 11/03

Programmer/Analyst Industry: Insurance

Worked as part of the Development team, creating a group of Windows-based applications- designed to collect data from various external entities, process and pass the results into the QA, which validates and feeds data into the Server. Various Applications handled are:

AAA: (Automated Account Administration) Designed to manage Customer & prospect information, Payables, Benefits and Transfer of accounts.

BROKER: Designed to efficiently keep track of broker information, commissions, adjustments & payment.

INCENTIVE: Handles incentive calc/adjustments based on various segment tier, cov codes and categories.

Developed new interfaces and screens for these Windows based applications

Generated numerous reports for user group and top management.

Responsible for UAT (Users Acceptance Testing).

Created Stored Procedure, Functions using PL/SQL programming.

ENVIRONMENT: PowerBuilder 5.0, Oracle 8i, PL/SQL programming

Bridgestone ACC. India Ltd. (BAIL) 02/00 – 01/01

Programmer/Analyst Industry: Tire Manufacturer

Developed BRANCH ACCOUNTING SYSTEM - Sales & Distribution Software for automating distribution outlets. Handled Inventory, OM, AR, Cash Disbursement, Claims & Foundation modules.

Study of existing system & Code Enhancements Integrating all modules into a complete system Unit testing Report Creation Tech. documentation & User Manual Training Users on Installation Proc.

ENVIRONMENT: Visual Basic 6.0, SQL Server 2000, Crystal Reports 8.5

Warner Lambert, INDIA 01/98-01/00

Programmer/Analyst Industry: Pharmaceutical

Developed EXPRO - Excise and ModVAt Module for PROTEAN ERP, which calculates Excise & other duties, avails ModVAt for Excisable resources.

ENVIRONMENT: Visual Basic 5.0, MS SQL Server 6.5/7.0, Crystal Reports 7

Contact this candidate