Objective:

Interested in an opportunity as a Team Lead responsible for developing and deploying web based applications that are beautifully designed, easy to use, highly reliable and requires low maintenance.

Overview:

• Ability to identify a concept and nurture it from the initial vision through design, development and implementation.
• Ability to quickly grasp and work with the most leading edge technologies.
• Extensive experience working with a team of talented professionals, motivating the team to high efficiency and productivity.
• Ability to bring complex projects to successful completion on time and on budget.

Experience:

Confidential

Lead Data Analyst / Off shore manager

Project Description:

• The client is a regulated energy company providing natural gas transmission, storage and distribution, to a
• total of nearly 4 million customers stretching from the U.S. Gulf Coast through the Midwest to New England.
• The client selected IBM to lead the Green Pay project in customizing the industry leading Time and Labor application Workbrain, to meet their unique needs. Workbrain is a customizable web based solution developed using Java and JSP as its user interface and Oracle as its database. Upon the completion of this project, over 2,000 NIPSCO Northern Indiana Power Supply Company employees will transition from a
• paper based system manually entered into a mainframe system, to a state of the art web based solution. This system will interface with a multitude of other systems that include People Soft for employee information, Maximo for order generation and Ventyx for field work tracking. Work data updates from Ventyx will be fed into WorkBrain in almost real time.
• Mr. Pradhan was selected to lead the effort in validating the data loads from the various systems into Workbrain and work with the testing team to identify and resolve all data related issues. Mr.Pradhan performed data analysis using Oracle's SQL Developer, created SQL scripts to efficiently analyze the load data and generated several reports used by the testers to validate the data using the Workbrain interface.
• Three months into the project, Mr. Pradhan was assigned the additional responsibility of managing the off shore development of the custom software additions to the Workbrain system. The off shore team was located in two separate locations in India Hyderabad and New Delhi with several developers working at
• each site. Mr. Pradhan was successful in building excellent working relationship with the off shore development team and the onshore business process team responsible for creating the Functional and
• Technical requirements. Mr. Pradhan was successful in leveraging his extensive experience in software development and Project management to deliver all the enhancements on time and with the fewest defects possible. To continue the development cycle on a twenty four hour basis, Mr. Pradhan handled the daily 8:30 am and the nightly 10pm call with the off shore team, ensuring a constant and consistent flow of top quality software for testing by the onshore team during the day. The defects generated by this continuous development process were identified, triaged, logged and ultimately resolved using the HP-ALM Application Life Cycle Management tool. Mr. Pradhan wrote some simple custom reports using the HP-ALM Query Builder capabilities. These reports were exported to Excel and used in the daily meetings.
• Upon completion of the project, Mr. Pradhan took on the responsibility to managing the Steady State team for Workbrain4 and Workbrain6. Currently he is working on transitioning the Steady State responsibilities and start work on the Power Plant project as a Lead developer. Transition is expected to be completed around the end of March 2015.

Experience:

Confidential

Transition existing CFTC systems over to Team IBM

• Responsible for transitioning several ASP.net / C and PowerBuilder applications to Team IBM. Attended multiple knowledge transfer sessions and followed the IBM standards in creating the necessary transition documents. Personally responsible for the maintenance of several applications that included Integrated Surveillance System ISS , Unfied Reporting UR , SSRS Reports and Interest Rate Swaps IRS .
• Unified Reporting and IRS are ASP.net/C and Telerik control based applications. Both use Entity Frameworks and LINQ for their data access model.
• UR is designed to host all SSRS based reports for the commission in one location. Active Directory is used to handle report level security. UR has over 300 reports. Upgraded the Report Viewer control to better handle the display of several critical reports that were having formatting issues.
• Took over the IRS application as Team Lead and mentored the junior developer to turn the project around. Worked with the business user to identify the core issues with the existing version of the application. Developed and implemented a turnaround plan by breaking down the issues into TFS Work Items and focusing on the prioritized list to get it through to User Acceptance testing. Redesigned the look and feel of the application to meet CFTC standards. Improved the response time issues by adding indexes and optimizing the queries and stored procedures. This release of the application is scheduled to go into production end of September.

Confidential

• Converted over 30 plus reports from a Client Server based reporting system into a SQL Server Reporting Services SSRS based Unified Reporting System UR .
• All converted reports were deployed to the Report Server and integrated into a web based reporting system.
• SSRS reports were executed from the application using the Report Viewer control.
• Developed several report templates that were used by all developers on the project. The templates had the corporate logo, standard colors, font formatting and alternate row coloring built into it. SSRS built in fields for Execution Time and User ID's were made part of the footer section of the template.
• Conscious effort was made to reuse as much as possible the existing SQL and Stored Procedures. Reports were translated directly into SSRS datasets using the extracted SQL or Stored Procedure, and easily mapped to a tablix or a matrix report.
• Wrote VBA functions in the Code properties of the Report object allowing us to do Required Field or Date Check type validations. These functions were referenced from the visibility property of the text boxes, which were used to display validation error messages. Depending on the returned value from the function, the appropriate error messages were displayed.
• Implemented the horizontal and vertical tabbed look and feel of a Client server based system using Rectangle, text boxes, table and matrix report items.
• Drilldown and Drillthrough features were implemented as appropriate. The drilldown feature was used for reports where the data returned was under a few hundred rows. This allowed the users to toggle the column and switch between summary and detail data without having to refresh the data from the database. Drillthrough reports were used for data intensive reports as it allowed us to retrieve the data in two pieces.
• The Crosstab reports were converted over using the matrix report item which allowed us to create row and column groupings. LookUp function was used in some of these reports to collect data from multiple data sets and display it in a text field of a matrix report.
• Sub reports were used for more complex reports allowing us to breakdown reports into manageable components.
• Used the Chart control extensively to make sense of large volumes of data As part of the data selection criteria, multiple dropdowns were used in a cascading fashion with one dropdown feeding off the other. These charts had data for multiple Series Oil, Corn, and Gas mapped to one category Date . Within the graph object, visual drilldown capability was provided by setting up the action property of the Series to call other graphs or report as needed.

Confidential

• Responsible for maintaining a PowerBuilder application Version 11.5 with a team of two more developers. This application is called ISS Integrated Surveillance System . It is used by the regulatory body and the CFTC economists to watch over trade practices in the Futures market. Data is collected from most of the commodity exchanges in the U.S., some foreign exchanges, and loaded into a SQL Server 2008 database on a daily basis.
• This application was developed under PFC and it takes advantage of core PFC services which include resizing, extended selection, sorting, filtering, validation and updating. ISS is comprised of over 900 plus PowerBuilder objects. There are over 100 windows, 90 plus User objects Class and Visual , 25 plus Structures and several datawindows of various styles Tabular, Grid, Free Form, Graph . There is extensive use of dropdown datawindows to allow the system to be flexible and database driven. Tab objects are used throughout the application to allow for a clear presentation of data. ISS has over 50 reports and 25 plus screens that have update capabilities. Almost all reports can be displayed graphically. The graphics engine was developed in house using PowerBuilder. It was implemented by adding a new graphics layer at the PFE level.
• The backend is SQL Server 2008 with over 300 tables and 700 plus Stored Procedures. All the SQL and the Stored Procedures are highly optimized using multi table joins and dynamic views within the SQL. CTE techniques are used in the Stored Procedures to avoid using Cursors and improve response time.
• Directly responsible for adding several new reports, enhancing existing reports, adding new screens with update capabilities and adding new tabs to existing screens. Also responsible for creating a new Alerts module which allowed the economists to set up pre-defined alert criteria, which could trigger an email alert on a daily basis. Also, set up DDE communication between the ISS application and a Web based application called Actimize. This allowed Actimize to call up an instance of ISS , pass it a string with pre-defined parameters and ISS would open up the appropriate window and display the trader's daily position.

Confidential

Web Developer

• The primary purpose of this site is to provide the users with a web based solution to save all their favorite bookmarks in one place.
• Responsible for all phases of the product development life cycle, starting with the initial idea, the drafting of the requirements, building of the data model and the requisite scripts, development, testing and ultimately the deployment.
• Developed the application using Visual Studio 2010, ASP.Net 3.5, C and SQL Server 2008. Deployed the site in March 2012 to a Windows based environment hosted by Arvixe using the FileZilla FTP client.
• Integrated the Google provided JavaScript in the Master Page and other .aspx pages, to facilitate the tracking of site usage by Google Analytics. Created my own set of tables and C classes to internally keep track of page views, click counts and unique visits. Am able to exactly match my internal unique visit count with Google's on a daily basis. Additional C classes were developed to trap TCP IP and other user related information. This information was then displayed as a Tracking report which allowed us to see all the visitors to the site including the Web Bots from various search engines domestic Google, Bing, Yahoo and overseas Baidu, Yandex .
• All pages in the site were inherited from the Site.Master giving the site a very consistent look and feel. Created a User Control that had a Grid View and a SqlDataSource which accepted retrieval arguments. This one User Control was registered using the Tagprefix and Tagname attributes with all the pages that make up the various tabs. This allowed us to display different data in the various tab pages with one user control and a minimum amount of coding.
• A Master/Detail report was created using two Grid Views controlled with the two Div tags, allowing us to show scroll bars when needed. Paging and Sorting was enabled in both the Grid Views to allow the users to navigate easily. Data for both the Grids were retrieved using the SqlDataSource. AJAX Update panel and the Script Manager server control was used with the Master Grid View to provide flicker free retrieval. EnableSortingAndPagingCallbacks property of the Grid Views was set to allow for Post back free sorting.
• Currently in the process of setting up Login functionality and the various Skins and Themes are being developed to provide the site with a professional look.

Confidential

Technical Team Lead

• Responsible for maintaining 5 PowerBuilder applications with a team of 7 developers and 1 Database administrator. These applications support over 200 users in 2 separate locations. The applications are ARMS Automated Reimbursement Management and Subrogation System , PAL, Letter Batch, Report Batch and Report Generator.
• The application interacts with two highly optimized SQL Server 2000 databases which has over 200 tables, 150 views, 200 plus triggers and over 200 Stored Procedures. The total size of each database is over 500 million rows.
• Direct responsible for the enhancement and maintenance of the ARMS application. This Application is extensively used in negotiation with Providers, Attorneys, Third party carriers and other contacts for collection of reimbursement claims already paid by HCSC or for ASO groups. The ARMS system is on track to allow HCSC to collect about 100 million in revenue this year.
• ARMS comprises of over 500 PowerBuilder objects. Two of the systems use the PFC class libraries and the rest use an in-house developed class library. Extensive use of advanced PowerBuilder objects Tabs, TreeViews, User Objects and Rich Text edit is made. Tabs are created dynamically, Tree Views are populated with data from the database and the Rich Text Edit object is used to save data to the database in a binary format. Multiple transaction objects are used to manipulate data in the databases.

Technical Team Lead Confidential

Migrated the ARMS application to the web based Troveris application. The underlying data models that support the business processes for the two systems were significantly different. Lead the effort to explain the ARMS data model to the Troveris team and help them understand the obvious and inherent relationships between the various tables and views. Upon completion of the requirements, developed a parallel testing process between the two systems and a User Acceptance plan to validate the proper implementation of all existing functionality. Also involved with the end users in developing special reports that would help them validate the data transfer and system functionality quickly and accurately. Also assisted the Project Manager with incorporating the technical details of the user acceptance and testing process in the project plan.

Technical Team Lead / Developer Confidential

Enhanced the ARMS application to add significant new functionality for managing the two class action lawsuits 2004 and 2008 . Worked with a team of lawyers and senior management to define the requirements, enhance the data model and develop all the screens necessary to implement the payout calculation logic as determined by the courts. A reporting subsystem was also built allowing management to generate several reports necessary to monitor the progress of the project and the disbursements of the final payouts. In the Brannan lawsuit 2004 there were over 80,000 mailing with about 11,000 responses. In the Cruz lawsuit 2008 there were 2,000 plus mailings with about 300 plus responses. The final settlement paychecks are scheduled for mailing in late July 2009.

Project Manager / Developer Confidential

Java Server Pages / Java

• Put together a team of four consultants two developers, one DBA and myself to develop a web based Financial Reporting system. This system allowed Catholic Charities to move from a manual system to an automated system for tracking annuity payments. Developed a Distributed Development methodology to build the software with a minimum amount of physical interaction between the developers. This was accomplished by providing the developers with a clear set of requirements using a MS Word document and a HTML page that was an exact replica of the screen approved by the customer. The requirements document would detail every action to be performed on the page, the expected inputs to the JSP / Java based web page, and the expected output the webpage it would call from the JSP / Java based web page. Clear definition of the input and output parameters allowed each developer to independently develop and test a web page without having to understand the whole application. This approach inherently lent itself to modular coding and clear documentation.
• The system was developed using Apache Tomcat as the application server. HTML and JSP were used for creating the Webpages, all communication with the My SQL database was performed invoking Java Servlets from within the JSP pages.
• I was personally responsible for co-coordinating and managing the project from the requirements stage to the implementation stage and to develop procedures for ongoing support and training. Worked with the customer to define the system requirements, build the requirements documents in MS-Word and the corresponding HTML page, create the logical design for the database and the final testing and integration of all the modules developed by the individual developers. Also had the opportunity to code three key reports using JSP / Servlets and SQL.

Confidential

Convert PowerBuilder application to ASP.net

• Migrated two existing PowerBuilder applications Cash Card, Chargeback and the supporting Oracle database from a Client Server environment to a web based environment.
• Rewrote the PowerBuilder based Cash Card application into a browser based application using HTML, Active Server Pages ASP/ADO , JavaScript on the client side, VB script on the Server side and Oracle Stored Procedure for data access.
• Designed and developed a new data model for the Cash Card application and worked extensively with the DBA in implementing the new data model in the development and the production environment. The database comprised of forty plus tables, Referential Integrity was built between the tables using Primary Key / Foreign Key relationships and indexes were built to optimize response times.
• The Cash Card application used the FTP process to pull several files that contained card orders, daily card transactions, and card activations from two servers on a daily basis. All files were loaded into the database using PL/SQL based packages and stored procedures. Batch processing was used to reconcile the transactions using .cmd files which executed PL/SQL based packages and stored procedures.
• All processing was done on a NT server and the automated job scheduling was handled using the NT scheduler. Un-reconciled records were processed online by Analysts using the web based Cash Card application.
• User access security was built into the system and was controlled at the database level through online screens. The Reporting System had over twenty online reports which were used to validate load processing online reconciliation and batch reconciliation.
• The Website consisted of 80 plus ASP pages, including files and Style sheets. Database access was built into the Webpages using the ActiveX Data Objects

Confidential

PowerBuilder Consultant

• Enhanced an Enterprise wide reporting system using PFC TreeView and Tab objects. The business logic and validations were moved to the user objects allowing for a 'N' tiered approach. To reduce the distribution issues a meta data model was designed allowing for the integration of new reports without having to create new executable. The meta data was stored in a Oracle database which supports the data types needed to store the syntax of exported datawindows in the database. The datawindows were recreated at runtime allowing for major modifications to the system without having to create executable for distribution.
• Migrated several PowerBuilder applications from version 4.0 to version 6.5. Modified external function calls to the windows API to accommodate for the 32 bit operating system. Modified these same applications and its associated data in the Redbrick warehouse database for Y2K compliance. All Y2K integration testing was done using tests and procedures designed under SQA Team Test.

Confidential

PowerBuilder Consultant

• Responsible for the development of the reporting sub system for the Plant Operations Information System POIS .The reporting subsystem included over 30 reports that required extensive use of datawindow manipulations and some stored procedures. Multiple table joins with unions were used throughout the system. Features included MDI concepts, drill downs, printing, exporting, popup menus and toolbars.
• The front end was developed using Amoco's PowerBuilder application development framework that incorporated all the standard MDI application features in class user objects. The back end DBMS was Oracle.
• Created dynamic tab objects with filters to display the various reporting groups. Creation or removal of a report group and its associated report was handled at the database level requiring no code changes.
• Datamodel had to be enhanced to support Grouping tables used to provide heading data for the report groupings allowing the report display customization of headings without hard coding.
• Composite and Crosstab datawindows with datastores were used to create more complex reports that required multiple set of SQL's for retrieval of data.
• Responsibilities also included installing the finished product on all user machines at the Whiting Refinery Complex, and training over 100 users on the new system. Also responsible for resolving all data issues during the parallel test process which required working extensively with the users at all levels, and having a thorough understanding of the refinery business.
• The development team included 4 members with various levels of PowerBuilder, data modeling, SQL and project management skills.

Confidential

PowerBuilder Consultant

• Developed a financial Alerts system that allowed Northern Trust clients to set up pre-defined investment restrictions for their account portfolio, based on global and domestic data. Upon violation of any of the restrictions, a message was triggered informing the clients of the restriction violation by the account manager. The triggered alert could be delivered through the Internet via e-mail, or through the Northern Trusts internal systems.
• The front end was developed using PowerBuilder and the RDBMS was SYBASE. All SQL in the application was based on Stored Procedures including Inserts, Updates and Deletes.
• Responsibilities included interaction with the users, data modeling, identification of the processes that define the business cycle, and the design and development of PowerBuilder based objects.
• There were over 70 objects that employ the concepts of Inheritance, Encapsulation and Polymorphism. Class User Objects were used to encapsulate connection logic, and Visual User Objects were used for execution of internal functionality.
• Supporting back end databases include DB2 which was downloaded onto the Sybase databases on a nightly basis.
• An Object library that included parent objects for Inheritance and security was used to speed up the development cycle.
• Northern Trust GUI standards were followed that included both IBM and Microsoft defined standards. The system also included extensive on-line help developed using RoboHelp.
• The team included two PowerBuilder front end developers and a back end Stored Procedure expert. Other support staff include Project Managers, DBA's and Mainframe database subject matter experts.
• Complete and accurate external documentation was developed allowing for an easy transition and a short learning curve.

Confidential

Lead PowerBuilder Consultant

• Developed a book printing entry system using PowerBuilder on the front end and Microfocus Cobol on the back end. This project involved 6 PowerBuilder developers and 8 batch programmers. The total cost of the project is estimated at about 2 million dollars.
• The PowerBuilder based entry system will populate the Oracle database with all the necessary information about the book, and the Microfocus Cobol program will extract the information off the database and print the book.
• Powertool Class library was used extensively to inherit all the PowerBuilder Objects. Several layers of inheritance, user events and user objects were used. The Oracle database was modeled after an IDMS database and had over 150 tables. Multiple table joins had to be performed and all datawindow based update issues addressed. Several datawindows were switched dynamically at runtime to allow for flexibility and modularity of design.
• Data integrity and concurrency issues were handled with the Logical Units Of Work technique to perform Commits and Rollback.
• Acted as a mentor to two junior PowerBuilder developers. Coached them on the basics of Object Oriented techniques, Events, Inheritance, Encapsulation, Instances, Window functions and MDI concepts. Also worked extensively with the junior developers to help them understand the conceptual issues related with a relation database.

Confidential

Technical Team Lead FOS Project

• Led the AT T Bill Certification project and interacted heavily with a group of highly talented consultants, in identifying and transferring a core set of technologies necessary for future Ameritech growth. Upon completion of the project Ameritech was well positioned to avail itself of the latest in Client Server technology, reduce development cycle time and provide customer service in a significantly improved manner.
• Project involved COBOL batch processing and DB2 on the back end and a PowerBuilder based application on the user access end. PowerBuilder was deployed to develop over 200 Objects by a team of 4 professionals over a one year period.
• Set up a completely automated data transfer system between IBM mainframes located in the five state Ameritech region. This automated system allowed Ameritech to populate its DB2 database located in Michigan, with data automatically transmitted from all five states over T1 lines, with almost zero human intervention. This automation significantly improved system reliability and reduced employee cost. At the end of each cycle, the system automatically generated paper reports for management use, printed on remotely located printers. The production tools used to develop this data transfer system included NDM Network Data Mover , CA7 scheduler and MVS JCL.
• Worked extensively with the DB2 Database Administrator to generate the DDL Data Definition Language for the creation of the database tables. Also worked with the user and the DBA to identify user access and security needs, defining of Synonyms and granting of access privileges.
• Documented the total batch process and trained team members to take over the regular maintenance and upgrade responsibilities.
• An in-house developed gateway communication package was linked through external DLL'S to facilitate communications between PowerBuilder on the P.C. and the DB2 database on the mainframe.
• Also lead a team effort for the creation of external DLL's for PowerBuilder using the Visual C environment. At the completion of this project several sample DLL's were created and documentation put in place to allow the future application of this technology with extreme efficiency.

Confidential

Remittance Supervisor

• Responsible for the hiring, training, counseling and performance evaluation of a staff of 40 in a very high paced production environment.
• Also responsible for the conversion from a transaction based to an image based processing system.