BHAGAVATHY PERUMAL PILLAI

adt545@r.postjobfree.com

412-***-****

DEGREE

AREA OF STUDY

SCHOOL/COLLEGE/UNIVERSITY

LOCATION

Master

MBA. Systems Production and Marketing

Sivaji University

India

Bachelor

BS in Computer Engineering

Madurai Kamaraj University

India

CERTIFICATION AND TRAINING

Sun Certified Java Programmer (SCJP) from Sun Microsystems.

Certificate Received from Work Training in Power Builder Foundation Class (PFC), from TELESIS Technologies

Skills:

SKILL

YEARS USED

LAST USED

20yrs experience in PowerBuilder development skills and technical knowledge.

20

2018

20yrs of experience in Oracle, SQL Server, Sybase, DB2/SQL skills and technical knowledge - design of tables, views, constraints, stored procedures, triggers, logging, etc.

20

2018

2yrs experience in .Net/C# skills and technical knowledge-implementing .Net/C# wrappers and/or Web Services

2

2018

Employment History:

Department of Health, NY State Nov'19 – Jun’20

Software People Inc.

Senior SQL/PowerBuilder Developer

Five Projects: CertProd, Officials, L-Paper, Safety Paper, FormOrders.

Location: Albany, NY.

Worked in Department of Health for New York State. Gone thru the Application code for six months and creating cases and made sure that the code matches the Business Flow. Also, if any missing cases needs to be documented. The CertProd application is huge complex application handles the issue of issuing Certificate like Birth, Death, Marriage, Dissolution (Divorce), Genealogy Birth, Genealogy Death, Genealogy Marriage and many more events throughtout the life cycle of Human., the L-Paper, Saftey Paper Applications are complex applications handles the Safety Paper and L-Paper issuances. All the applications are very complex, gone thru the code and understand the code and write cases. Since the Application was written decades back, it didn't have much comments written on what the things do, understand those after reading the codes, they simply migrate from I think from PowerBuild 5 or below to now, PowerBuilder 10.5. Some documentation was there, but greatly differ, my job is gone thru the codes and understand those complex logics and write those cases. I did bug fixing also some complex area where there were multiple table joins like 9 different tables and lot of subqueries, I fixed those and also done some enhancements like Report Screens which have didn't have auto resizing, as there was no PowerBuilder Foundation Class in that project, I written all the logics of the PowerBuilder Foundation Class logics myself and made it Resize same like PowerBuilder Foundation Class Framework Library.

The CertProd application is very complex one, spans lot of objects. It handles all the Birth, Death, Marriage, Dissolution (Divorce), Genealogy Births, Genealogy Deaths, Genealogy Marriage and many more events for all the New York State Counties. The main function it do is lot of complex calculations for each copies of any of the above Copies Requested.

The L-Paper & Safety Paper Applications manage the Paper used by the CertProd Application, it is also medium complex, but not as big as CertProd. It have various business rules to make sure to meet lot of validations.

The Officials application manages all the Officials used in the CertProd Application. It maintains the interlinks between Various Officials, their deputy, Registrars, County Clerks, Village Clerks, Supervisors, Mayor etc.

The FormOrders application is small application, it maintains various Forms done throughout the Application. These forms have various calculations like OFT Limits, some forms have more pages, some forms have only one pages, so, the forms availability etc and the calculations made it

Responsibilities:

Fixed Complex long standing issue on the 2nd week of the Project Joining which involves multiple joins and complex subqueries.

Bug Fixing & Enhancements like Resizing functionality for Report Screens, which were earlier too small, user has to use scroll bars to see the Report Contents. As the application was not written in PowerBuilder Foundation Class, so I have to do extra steps to create all the complex logics myself to make the Resize functionality behave like Resize Logic of PowerBuilder Foundation Class Library Framework.

For the past 8 months, gone thru all the 5 applications and also gone thru the code to make sure that all the software work per the code written and create cases for the application in addition to fix Production Bugs and enhancement as often.

Bug Fixing also done when Production Support tell issues.

We used REDMINE Ticket Tracker to Log Issues.

We used GitHub Source Control to keep codes.

Used GitLab Gui and Server module for creating branches and adding objects into Git.

We used Push OK Software as a Middle Layer to connect to Softwares & GitHub.

Environment: Git Hub, PowerBuilder 10.5, SQL Server, HP Quality Center, Unix Shell Scripts,ASP.NET, .NET Framework, Visual C#, MVC, T-SQL, DTS, Profiler for debugging SQL Scripts, Microsoft Management Studio (SSMS). RedMine Ticket Tracker and Issues Logger. MS Team. Push OK Software

Utah State Board of Education Oct'18 – Feb'19

MSYS Inc.

Senior SQL/PowerBuilder Developer

Utah Board Software called STUDENTS

Salt Lake City, Utah.

Worked in Utah School Board Software called STUDENTS. Which involves various stages of enrollment procedure for Special Needs Students. This system deal with various things like Enrollment, monthly allowable contribution from State & Parents. Assign students to near by Special Needs Schools etc. This is a big software used throughtout the State of Utah.

Responsibilities:

Developing, Bug Fixing, Enhancement, Unit Testing of Production Issues.

Worked on complex Enhancements from scratch.

Worked on School System Software Students for Special Needs, added extra logics to process Fee Increase or Cost of Living Adjustments for Grants etc.

Used Ticketing Systems HP Quality Center to log Bugs and fix those once got approval.

Environment: PowerBuilder 12.6, SQL Server, HP Quality Center, Unix Shell Scripts,ASP.NET, .NET Framework, Visual C#, MVC, T-SQL, DTS, Profiler for debugging SQL Scripts, Microsoft Management Studio (SSMS).

TATA Consultancy Services Jun’17 – Dec'17

NiSource Inc., Columbus, Ohio

Senior SQL/PowerBuilder Developer

EASy Software, GRIPS Software, ABS Software Projects

Columbus, OH.

Worked various projects enhancements, bug fixes, Support of Natural Gas & Electric Sensitive Application. EASy Application is one of the Silver Plus Application, means high importance. GRIPS Application is Silver, next higher priority. As these two applications are involved in Monthly Billing Report Preparation, every day meter readings comes to the application and stored into various tables from FTP & Meters directly thru Data Warehouse.

This application is backbone for Nominating volume of Natural Gas to various Suppliers & Pipelines. Nomination, Adjustment, Billing, Reports of Natural Gas and Electrical Systems are done via these Systems. 24 hours Batch Run background and bring daily the meter readings into the system.

GRIPS sends Reports every 12:30pm.

EASy has automatic Reports about Batch jobs completed and Manual Reporting modules. EASy & GRIPS are called very important application without these it is very difficult to nominate how much natural gas to particular Interstate pipelines. The states which uses the Software are Columbia Gas of Massachusetts, Kentucky, Ohio State, Maryland, Pensylvania & Virginia.

Responsibilities:

Full incharge of EASy & GRIPS Softwares which are written in Powerbuilder 12.5.

Estimation & Design of Enhancements like Gas Rate Change Mega Project which occur every decade on EASy Software.

Cost Estimation of migration & minor demo migration of Powerbuilder 12.5 to Powerbuilder 2017.

Research of Powerbuilder 2017 and Oracle 12c compatibility.

Take care of Powerbuilder Builds & Releases. Notification of Releases to various clients. They use a separate properitary procedure to build which updates many FTP & Lan Sites.

Enhancements of Reports and Maintenance of Billing Modules.

Work with Client on each month from 1st to 5th of each month co-ordination of the Billing Activities, if any billing struck, need to find the reason and make it work.

Make sure that GRIPS reports correctly comes.

Make sure that the Batch Jobs all successfully run everyday morning, analyze the email and findout & rectify any errors.

Took full control of the softwares EASy & GRIPS from outgoing IBM Personnel after knowledge Transfer.

Worked on Interfaces & Batch Jobs, which control the software through Unix Shell Scripts, Oracle Pro*C, IBM DB2, IBM SQC.

Design Oracle Reports using Oracle Report Builder.

Worked on Complex Stored Procedures, Triggers, DML, DDL, PL/SQL, SQL*Plus, Pro*C modules.

Roles: Analysis, Design, Code, Documentation, Unit Testing, Test Plan creation, High level Design, Low Level Design, Reviews of EASy & GRIPS. The systems are high sensitive systems.

Involved in the Analysis, Design, development and maintenance of application modules for the assigned applications within the SDLC process.

Extract business rules and create technical design documents for the web conversion of assigned modules.

Create functional and technical design documents of assigned modules for system enhancements.

Coordinate with business in analyzing business requirements, QA team and user community for system testing and implementation processes.

Environment: PowerBuilder 12.5, Powerbuilder 2017, Oracle 11g, 12c, Oracle PL/SQL, Pro*C, SQL*Plus, Oracle Report Builder, IBM DB2, SVN Tortoise Source Control, ASP.NET, .NET Framework, Visual C#, MVC, Web Forms, Microsoft SQL Server, T-SQL, VB6.

Northrop Grumman Corporation Nov’16 – Jun'17

TekSystems, AR

Senior SQL/PowerBuilder Developer

Dept. Of Human Services State Project

Little Rock, AR.

Working on system called ANSWER (Arkansas Snap and Medicaid Processing Application), used by Statewide in Arkansas.

Responsibilities:

Design of tables, views, constraints, triggers, logging, etc.

Windows, UNIX, C, C Services middle ware, Complex SQLs and complex rules in front end.

Roles: Analysis, Design, Code, Documentation, Unit Testing, Test Plan creation, High level Design, Low Level Design, Reviews of Arkansas Food Stamps, SNAP, Medicaid program system.

Involved in the Analysis, Design, development and maintenance of application modules for the assigned applications within the SDLC process.

Extract business rules and create technical design documents for the web conversion of assigned modules.

Create functional and technical design documents of assigned modules for system enhancements.

Coordinate with business in analyzing business requirements, QA team and user community for system testing and implementation processes.

Environment: PowerBuilder 11.5, DB2, TFS, .NET, Visual C#

Wells Fargo, Charlotte, NC Oct’12 – Sep’16

Senior SQL/PowerBuilder Developer

Responsibilities:

Responsible for development and support of enterprise application serving collections department.

Involved in the Analysis, Design, development and maintenance of application modules for the assigned applications within the SDLC process.

Extract business rules and create technical design documents for the web conversion of assigned modules.

Create functional and technical design documents of assigned modules for system enhancements.

Conduct code reviews and design walkthroughs with business and other developers.

Design of tables, views, constraints, triggers, logging, etc.

Coordinate with business in analyzing business requirements, QA team and user community for system testing and implementation processes.

Conduct Impact Analysis and identify all related code modifications for system enhancements.

Environment: PowerBuilder 12, Oracle 10g, PL/SQL, TAR Tracker, SharePoint, MS-Office Suite, Clear Case, Clear Quest, Java, Rational, SQL Loader, ASP.NET, Visual C#, C#, .NET Framework.

BlueCross of BlueShield of Florida, Jacksonville, FL Jan’12 – Sep’12

Senior SQL/PowerBuilder Developer

Responsibilities:

Responsible for development and support of denial claims department health system.

Worked in the Conversion and enhancement of data window from legacy to XML based and bug fixes.

Worked in PowerBuilder area which contacts Middle layer Tuxedo.

Worked in development and migration of 11.5 version of PowerBuilder.

Responsible for development and support of enterprise application serving collections department.

Designing, implementing EMR interfaces utilizing HL7, XML, and/or Web Services.

Involved in the Analysis, Design, development and maintenance of application modules for the assigned applications within the SDLC process.

Extract business rules and create technical design documents for the web conversion of assigned modules.

Create functional and technical design documents of assigned modules for system enhancements.

Design of tables, views, constraints, triggers, logging, etc.

Conduct code reviews and design walkthroughs with business and other developers.

Coordinate with business in analyzing business requirements, QA team and user community for system testing and implementation processes.

Conduct Impact Analysis and identify all related code modifications for system enhancements.

Strong SQL experience, worked in complex Stored Procedure, Triggers.

Environment: PowerBuilder 9 and 11.5, Oracle 10g, PL/SQL,, SharePoint, MS-Office Suite, Clear Case, Java, BART, Tuxedo, ASP.NET, C#, Visual C#, .NET Framework.

Wells Fargo, San Francisco, CA Jan’08 – Dec’11

Wachovia Bank, Charlotte, NC

Senior SQL/PowerBuilder Developer

Responsibilities:

Responsible for development and support of enterprise application serving collections department.

Involved in the Analysis, Design, development and maintenance of application modules for the assigned applications within the SDLC process.

Extract business rules and create technical design documents for the web conversion of assigned modules.

Create functional and technical design documents of assigned modules for system enhancements.

Conduct code reviews and design walkthroughs with business and other developers.

Design of tables, views, constraints, triggers, logging, etc.

Coordinate with business in analyzing business requirements, QA team and user community for system testing and implementation processes.

Analysis, Design, Coding, implementation of .NET Project using ASP.NET, C#, Visual C#, .NET Framework.

Conduct Impact Analysis and identify all related code modifications for system enhancements.

Environment: PowerBuilder 10.5, Oracle 10g, PL/SQL, TAR Tracker, SharePoint, MS-Office Suite, Clear Case, Clear Quest, Java, Rational, SQL Loader, ASP.NET, Visual C#, C#, .NET Framework.

CIBER Inc. Raleigh, NC Jan’07 to Jan’08

Senior SQL/PowerBuilder Developer

Projects: HICAMS & Vendor Management

I worked on the projects named HICAMS and Vendor Management. These projects involve maintenance of Transportation and road work materials like asphalts etc. These systems track the usage of these materials and maintenance of contracts about whom the work was given, length of contracts etc. in details.

My main responsibility is bug fixing, coding, unit testing, enhancement. The team lead assigns the work/bugs; I have to utilize PowerBuilder debugger to solve the bugs. Some enhancements also will be there to work on. I use the software development life cycle for my assignments. Enhancements will be like extending the functionality of the existing screen or new screen altogether.

Vendor Management contains Adding New Vendors, Editing existing Vendors, Delete vendors. Here the complexities come in the business rules when doing each operation.

Example, when existing vendors were edited which contains 100s of fields which has relationship with other screens and sometimes with other systems, the validations becomes complex.

Hicams contains modules like add, edit, and delete of materials. Also, add, edit, and delete of contracts. Linking materials to contracts, Link contracts to vendors and overall maintenance of contracts.

Environment: PowerBuilder 10.0, Sybase 11, Windows 2000, Merant Version Manager.

Discovery Communications, Inc. Nov’05 to Jan’07

Silver Spring, MD

Senior SQL/PowerBuilder Developer

Project: Deal Builder

Deal Builder is software for the Advertisement Sales Management and it is used by Discovery Channel Sales people in Programming Advertisement Spots & calculate air timings & money etc.

It contains Scheduling module, Spot Management Module, Financial Module, Rate Card Module and lot of other enhancements.

We developed a new module called Group Move Mapping. Group Move Mapping allows the Sales Management team to Map the operations in volume. It used in sync with the Group Move Nightly job, it allows the sales people to deal with great extent & flexibility to allow pre-empting, schedule & carrying out lot of complex & challenging operations. Previously, those operations were done by them manually & hard to manage.

Environment: PowerBuilder 10.0, 7.5, PFC, Oracle 9, Windows XP, Visual Source Safe (VSS).

Askesis Developer Group, Inc. Jan’01 to Sep’05

Chicago, IL/ Pittsburgh, PA

Senior SQL/PowerBuilder Developer

Project: PsychConsult

PsychConsult is a product for the behavior health care and it is used in various states throughout United States.

Responsibilities:

Took lead role HIPAA team in the design and coding, which has lot of challenging works in the PowerBuilder side and SQL Side and Data Junction (data warehousing side). Created new HIPAA design which boosts speed 10 times than previous one.

Worked in HIPAA 837 Professional Transactions, HIPAA 837 Institutional & HIPAA 835 Standard Transactions etc. those uses xml, java & Data Ware housing tools, PowerBuilder, MS SQL Server 2000.

Electronic Medical Record (EMR) software design and development utilizing HIPAA 837, XML, and/or Web Services.

Newly designed, implemented & coded a new GUI development called “New Configuration” window, which was appreciated by everybody in the company.

Worked with the team in the development of Chat Server called PNS (Provider Notification Server) using distributed computing technique, created main heart of the chat server.

Worked in the General Ledger Numbering System to speed up the module which improves the performance to a very great extent.

Worked in the Managed Care (another product) Team with lot of bug fixes & enhancements. Enhanced a system to speed up the module to a great extent.

Improved performance of an old module by avoiding costly memory usage.

Used four datawindows instead of opening thousands of user objects in run time, makes one module performance improved dramatically (used sync scrolling also).

Design of tables, views, constraints, triggers, logging, etc.

Developed the Call Center Interface for the PsychConsult. This links caller to Patient, Staff, and Contact Person & Organization.

New patient can also be created from the call. There were lots of security validations for the calls to enter in the system. Setting of Relationship to an existing Patient, Staff, or Contact Person can be done. Browsing done based on Social Security No., Last Name, First Name, and Home Phone No. Very Good Graphic Interface associated with this module by using rich bitmaps in datawindows.

Developed the Treatment Planning Module for Provider Project which is a sub product in PsychConsult. The Treatment Planning module is a template for all the documents in the system. Before creating any document for the medical system, the user must go to the Treatment Planning module and create a template first, and then using the template, they can create documents. This module contains lots of treeviews, tab controls & report views. The user can store the template & edit the template in future.

Worked with Managed Care team, that is another aspect in PsychConsult. Minor modules & windows were developed in Managed Care in co-ordination with the existing system.

The job involves in working with Frame work related and Normal PowerBuilder.

I involved in the creation of Complex Store Procedures & Triggers.

Environment: PowerBuilder 8.0, 6.5, PFC, MS SQL Server 2000, Windows XP, 2000.

One Inc. Chicago, Chicago, IL Jan’00 to Jan’01

SQL/PowerBuilder Developer

Adelphia is a communication company for cable, long distance, ISP etc. This software automates their entire operation using PowerBuilder 6.5 and Oracle 8 with Advanced Queing – DeQueing.

Responsibilities:

Developed Batch Payment Processing Module for the System, which process individual payments in batch. This module is integrated with the Payment Module where user can pay individually.

Worked with the Security & User Preference Modules, this handles the Security Related Information and Login User Information.

Worked with Other teams to fix bugs in the system, testing, enhancement, new development etc.

The job involves in working with PFC related and Normal PowerBuilder.

I involved in the creation of Complex Store Procedures & Triggers.

Environment: PowerBuilder 8.0, PowerBuilder 6.5, PFC, MS SQL Server 2000, Windows XP/ 2000.

Askesis Developer Group, Inc. Chicago, IL Aug’99 to Jan’00

Programmer Analyst

PsychConsult is a product for the behavior health care and it is used in various states throughout United States.

Responsibilities:

Developed the Call Center Interface for the PsychConsult. This links caller to Patient, Staff, and Contact Person & Organization.

New patient can also be created from the call. There were lots of security validations for the calls to enter in the system. Setting of Relationship to an existing Patient, Staff, or Contact Person can be done. Browsing done based on Social Security No., Last Name, First Name, and Home Phone No. Very Good Graphic Interface associated with this module by using rich bitmaps in datawindows.

Developed the Treatment Planning Module for Provider Project which is a sub product in PsychConsult. The Treatment Planning module is a template for all the documents in the system. Before creating any document for the medical system, the user must go to the Treatment Planning module and create a template first, and then using the template, they can create documents. This module contains lots of treeviews, tab controls & report views. The user can store the template & edit the template in future.

Worked with Managed Care team, that is another aspect in PsychConsult. Minor modules & windows were developed in Managed Care in co-ordination with the existing system.

The job involves in working with Frame work related and Normal PowerBuilder.

I involved in the creation of Complex Store Procedures & Triggers.

Environment: PowerBuilder 6.5, PFC, SQL Server, Windows NT.

New York Women, Infants and Children Statewide Information System (NYWICSIS)

Deloitte & Touché, Albany, NY Aug’98 to Jul’99

Programmer Analyst

NYWICSIS is a state-of-the-art client/server eligibility determination and management system. The system will support processing functions for the Women, Infants and Children (WIC) Nutritional Supplement program.

Users of the system will be presented with Graphical User Interface (GUI) windows to access the numerous functions of the system. Users will have access at their desktops to on-line policy manuals. A powerful ad hoc reporting tool will be utilized to provide users with a quick and efficient way for generating some on-line reports. The application will utilize Sybase SQL Server Relational Database Management System (RDBMS) with processing of the application distributed between the client workstation and the database server.

Responsibilities:

To handle complex requirements of the Subsystem, Created Interfaces in Power Builder for Reading Checks Magnetically.

Developed Power Builder routine to process electronic signature.

Designed and developed the screens for the Food Package and Food Instruments Subsystem.

Created specifications and developed Food Package and Food Instruments subsystem.

Designed and developed file layouts for interfaces with Food Instruments and Food Packages and other sub systems.

The job involves in working with deeper level of Inheritance.

I involved in the creation of Complex Store Procedures & Triggers.

Environment: PowerBuilder 6.0, PFC, Sybase System 11.x SQL Server, Windows NT, DEC ALPHA Server, MF COBOL, PENWARE, MOBINETEX, View Builder.

Contact this candidate