Technical Project Manager

* ** *

Ritul Shah

Email: *****@*******.***

Cell: 201-***-****

SUMMARY

Over 13 Years of IT experience.

Experience in managing resources on-site and off-site and ability to manage multiple projects/releases simultaneously in a deadline driven environment.

Experienced Senior Analyst in the field of Information Technology with expert domain knowledge in Healthcare, Finance (Card System), Unemployment Insurance, Healthcare (Medicaid), Juvenile Court, Voter Registration industries.

Expertise in gathering requirements, designing artifacts, developing project plans and managing and tracking project executions.

Expertise in designing, developing ETL (Datastage) jobs to load interface data to an Oracle 10g database.

Applied extensive knowledge of Software Development Life Cycle towards design and development of custom document management and imaging application

Ability to quickly understand business requirements and analyze large amounts of data

Experience in interacting with client and other external agencies for requirement gathering, supporting user acceptance testing, discussing production defects and providing solutions.

Experienced in writing technical specification

Proficient in writing, tuning and optimizing complex SQL queries for maximum performance results

Adaptive, resourceful and quick learner of new technologies

Experienced in developing GUI applications in VB.Net and HPC (HighView – Document Imaging Tool)

Experienced in reports development and deployment using Crystal Reports XI, v10 and Oracle Reports 9i

Excellent communication, presentation, analytical skills

Experience in providing Production Support

Advanced degrees in information systems, management, and commerce

A Green Card Holder. Authorized to work in USA for any employer. No Visa sponsorship required. TECHNICAL SKILLS

Operating Systems: Microsoft Windows 95/98/2000/XP, Knowledge of UNIX, Linux, and Sun Solaris

Languages: PL/SQL, HTML 4.0 Transitional, and DHTML

Front End Tools: VB.NET, Visual Basic 6, Crystal Reports XI (and v10), Microsoft .NET Framework, Oracle Reports 9i, Oracle Forms 9i, Oracle Designer 9i, Oracle Warehouse Builder 3.0 (OWB), SQL Loader

Other Tools: Macromedia Dreamweaver, Microsoft Front Page 2000, Macromedia Flash 5.0, and Adobe Photoshop 6.0, Interwoven, TOAD, Rational Manual Tester, Rational ClearCase

Databases: Oracle 9i, SQL Server 2000, Microsoft Access, Sybase and Microsoft Visual FoxPro, DB2, Vertica

Imaging Tools: HighView 4.0.1, Kofax Ascent Capture 6.1

Portal Tools: MS SharePoint

Business Intelligence: Knowledge of OBIEE

RELEVANT PROFESSIONAL EXPERIENCE

2015-Present Princeton Information Newark, DE

Technical Project Manager

Client: Bank of America

Project: BACARDI RDA INIT Projects 02/16 – Present Bank of America Card Information (BACARDI) Warehouse is one of the systems that is in the process of complying for Risk Data Aggregation (RDA) as per Basel Committee on Banking Supervision (BCBS). As part of RDA there are Small Adhoc Project Initiatives that are received to send and/or receive data to/from TSYS and other departments utilizing CARD data.

Managed multiple small initiative projects from estimation, forecasting, and resource management.

Developed design document template, workflows, design process flows, and system context diagram for understanding of developers.

Conducted JAD sessions with stakeholders to get complete requirements (business/technical).

Conducted analysis by running queries against the database (DB2/Vertica) to validate the data.

Validate High Level and Low Level Design (HLD/LLD) design documents including technical details (data mapping, technical design, scripts, scheduling details, protocol, etc) created by off-shore resources.

Created design and developed Project Plan of BACARDI and synced it up with the overall Project 2 of 7

Managed the development of the projects with reference to technical issues, resources and also transition to different environments.

Discussed issues with Leadership that would impact the projects with possible resolution.

Created Test Plans for the projects and worked with Testing Project Manager to get projects End-to-End tested in the various environments

Role: Technical Project Manager

Environment: IBM DB2, HP Vertica, Datastage 9.3, Unix, Linux, TOAD Data Point 3.7, MS-Visio, MS-Project, MS Word, MS Excel, HP-ALM

Client: Bank of America

Project: BACARDI RDA ADS Compliance 07/15 – Present Bank of America Card Information (BACARDI) Warehouse is one of the systems that is in the process of complying for Risk Data Aggregation (RDA) as per Basel Committee on Banking Supervision (BCBS). As part of RDA the data must be accurate, clearly defined and available from trusted sources to support effective risk management and business decisions (EDM – Electronic Data Management). The process of cross-line-of-business provisioning strategy, which includes defining the Authorized Data Sources (ADS) for domains of transaction data, reference data and derived data is Electronic Data Architecture (EDA).

Conducted JAD sessions with Upstream (sending data to BACARDI) and Downstream (sending data from BACARDI) in order to gather requirements or during analysis for ADS Certification

Documented evidences by executing scripts against the DB, working with other teams (architecture, other departments referencing Card data) in order to submit to EDA QA/QC team

Created reports using Crystal Reports to be submitted as evidence to the Basel Committee from BACARDI standpoint

Validated existing Datastage jobs to make sure it includes all the elements are captured in the pull mechanism format of the job

Updated existing DataStage jobs to make the transition from pull to push mechanism Role: Senior Technical Systems Analyst

Environment: MS-Visio, MS-Project, MS Word, MS Excel, IBM DB2, HP Vertica, Crystal Reports XI, Datastage 9.3 2014-2015 Acclaim Systems Philadelphia, PA

Manager

Client: Geneia (a Capital BlueCross Company)

Project: Theon @home 09/14 – 04/15

Capital BlueCross acquired Geneia as a for profit company. Geneia implemented a platform/framework based on which new products and services are being designed and developed that can be sold to the clients in order to take care of their complete healthcare requirement. The @home service is a new feature that will be used to monitor patients/candidates remotely by a nurse. The @home service is currently limited to CHF and CHF w/Diabetes patients.

Gathered requirement and conducted analysis for the different devices that will be used from an @home Program standpoint.

Created wireframes for @home Program in order to display reading and/or measurement, alerts received from the devices.

Managed and maintained vendor relation from a technical and business aspect with respect to data interaction through API, contract, device supplies, pricing, issue tracking, co-branding, and any other requirements with Covidien (now Medtronics)

Working with various teams (Clinical, Data Modeling, Program Manager, Testing) to complete the design and analysis for

@home Program

Designed the specification (data mapping, data validation) for reports

Worked with the Tableau architect on implementation and User Acceptance Testing of the Tableau Reports

Coordinated deploying of the devices with the nurses during patient enrollment

Worked with the data modeler in designing the database for the @home Program

Worked with the external vendor (Appian) in architecting the Business Process Model (BPM) flow for the @home Program

Used Agile methodology during design, development and testing phases of SDLC Role: Product Manager (Technical and Service Operation) Environment: Balsamiq, MS-Visio, MS-Project, MS Word, MS Excel, Appian, Tableau 3 of 7

2013-2014 Accenture Philadelphia, PA

Software Engineering Associate Manager

Client: Sonepar USA

Project: Sonepar Business Intelligence (BI) 05/14 – 09/14 Sonepar partnered with Accenture in 2007 to define its information strategy with the vision of creating a best-in class business intelligence solution to deliver a consolidated view of key data and provide accurate, consistent and timely analytics and reporting.

Managed a team of 5 off-shore resources to get development and other technical analysis completed.

Created Project Plan, Project Estimation, Project Forecasting for bigger tickets that were treated as projects.

Gathering requirement by interacting with the client and evaluating existing tickets

Conducted analysis by verifying/validating the mapping defined in Informatica Power Center 9.1.0

Conducted analysis by executing SQL queries against SQL Server 2008 databases to validate data from the source Data Warehouse and verify the data is loaded correctly in the BI Data Warehouse

Conducted analysis by verifying reports in IBM Cognos and validating the query used in the report creation. Role: Functional Lead/Project Manager

Environment: Informatica Power Center 9.1.0, SQL Server 2008, IBM Cognos, IBM TM1, MS Visio, MS Project, MS Word, MS Excel

Client: Sonepar USA

Project: Sonepar eBusiness (B2B) 09/13 – 05/14

Sonepar partnered with Accenture in 2007 to perform assessment of Information Management, eBusiness, Business Intelligence systems. Sonepar then awarded Accenture to provide on-going services for enhancements or modification or any new requirement to the eCommerce platform (mainly Business Intelligence, eBusiness, Product Information Management and Intranet) at Sonepar.

Gathering requirement and conducting analysis by interacting with the client, evaluating existing website(s)

Facilitated business and technical JAD sessions with business and technical team at Sonepar.

Created/update new/existing Functional Design document to accommodate new requirements.

Created/update new/existing Use Case document to accommodate new requirements.

Created/updated new/existing wireframes to accommodate new requirements.

Working with offshore team to get development completed Role: Business Systems Analyst

Environment: IBM Websphere Commerce 7, Solr Search, Axure RP Pro 5.6, MS Visio, MS Word, MS Excel Client: Bank of America (Newark, DE)

Project: Bank of America Card Information (BACARDI) 06/13 – 08/13 Accenture was awarded multiple data warehousing, data mining projects for Bank of America’s Card Information System (BACARDI). The projects included multiple integrated systems; mainly mainframe, source retirement, external parties like TD Bank.

Managed a team of off shore resources mainly from a development standpoint.

Facilitated technical JAD sessions with Bank of America Technology Infrastructure team as well TD Bank Data Team.

Gathering requirements and conducted technical analysis with respect to the different types of data that needed to be transferred to TD Bank, Canada.

Developed queries to conduct data analysis.

Architected the technical design for implementation.

Created High Level Design Document (HLDD) and Low Level Design Document (LLDD) depicting system context diagram, detail specification of smaller pieces of the design.

Created Statement of Work (SOW), Project Plan, Project Forecasting, budgeting and cost estimation for the various projects.

Developed db2 scripts to retrieve data for extraction purposes for POC. Role: Project Manager

Environment: Datastage 8.5, Vertica, Hadoop, MS Project, MS Visio, Unix, DB2, TOAD for DB2 4 of 7

2010-2013 IBM Mechanicsburg, PA

Senior Consultant

Client: Florida Department of Children and Families (FL-DCF) Project: Florida Safe Families Network (FSFN) 02/13 – 05/13 IBM was awarded to provide on-going maintenance and operations services and perform additional project work of existing Department of Children and Families system. The system was to capture data received from the Hotline (call) and conduct investigation and provided services to the child or the adult.

Gathering requirements for each Interface by reaching out to BA, architects and other team members on the project.

Created test scripts in word and then uploaded them in RFT.

Managed a team of testers by assigning activities, getting status updates, gathered issues raised by test team members and worked on resolving them.

Tested webService between CRM and FSFN using SoapUI Role: Interface QA Analyst

Environment: MS Visio, Rational Quality Manager (RQM), Rational Team Concert (RTC), Rational Functional Tester (RFT), Rational Clearquest (CQ), SoapUI

Client: Pennsylvania Department of Labor and Industry (PA-DLI) Project: Pennsylvania Unemployment Compensation Modernization System (PA-UCMS) 08/10 – 11/12 IBM was awarded to replace Department of Labor and Industry’s (DLI) 40 year old Assembler System. This legacy unemployment compensation system will be replaced with a new, Service-Oriented Architecture (SOA) framework based custom application that would manage unemployment taxes, wage records, benefits and claims for employers and constituents of the Commonwealth.

Managed a team of QA’s for complete end-to-end testing, interface developers (Datastage, $Universe, WebMethods – including MQ) and BA.

Lead the integration process of data flow between various components (DataStage, $U, webMethods, BPEL, Portlet) of the application.

Updated existing ETL jobs in Datastage 7.5/8.1 to accommodate design change requests.

Designed new ETL jobs in Datastage 7.5/8.1 for new interfaces, which receives data from other agencies and sends data to other agencies introduced from change request.

Identified scope creep and raised Change Request during testing to append new requirement.

Provided cost estimation (including design, development, testing hours) for design changes.

Created technical specification (source to target mapping with validations) for interface developers.

Facilitated JAD sessions for requirement gathering business and technical.

Interacted with various agencies (state/federal) to exchange unemployment data.

Performed business requirement analysis, function and data analysis.

Interacted with the client for functional and technical analysis of various interfaces.

Designed a graphical Process Flow of interface data received from various sources to the portal through the different components involved.

Created an application in Visual Basic 6 to scrub (sanitize) the data (production) received from the client (DLI and external to DLI)

Involved in assisting developers to write SQL queries and PL/SQL procedures for Reports.

Developed SQL queries and shared it with testers and other developers to conduct data analysis.

Developed Test Scripts for the interfaces in Rational Manual Tester.

Created an applications in Visual Basic 6.0 to extract data from flat file and MS-Access database and write to flat files for scrubbing purposes

Delivered Interface Strategy Documents for Release 1,2 and 3 and received sign off from client.

Provided support during UAT and transition to Production of Release 1/2 systems.

Providing Production Support for Release 1 and 2 by interacting with the users, analyzing defects, providing solutions, updating design artifacts.

Used Agile methodology during Development and Testing phases of SDLC. Role: Lead Interface Analyst/Interface Architect

Environment: IBM Data Stage 7.5/8.1, MS-Word, MS-Excel, MS-Access, Visual Basic 6.0, Oracle 10g, Rational Manual Tester, Rational ClearCase.

5 of 7

2008-2010 HP Mechanicsburg, PA

ITO Service Delivery Consultant III SPE

Client: IBM/PA-DLI (PA Dept. of Labor & Industry) 02/07 – 08/10 Project: Pennsylvania Unemployment Compensation Modernization System (PA-UCMS) The Department of Labor and Industry (DLI) had a 40 year old Assembler system. IBM was awarded to replace its legacy unemployment compensation system with a new, Service-Oriented Architecture (SOA) based custom application that would manage unemployment taxes, wage records, benefits and claims for employers and constituents of the Commonwealth.

Created technical specification (source to target mapping with validations) for interface developers.

Facilitated JAD sessions for requirement gathering business and technical.

Interacted with various agencies within (and out of) state to exchange unemployment data.

Created new and Updated existing AS-IS and TO-BE process models using WebSphere Business Modeler.

Performed business requirement analysis, function and data analysis.

Developed Test Scripts for the interfaces in Rational Manual Tester.

Created an applications in Visual Basic 6.0 to extract data from flat file and MS-Access database and write to flat files for scrubbing purposes

Delivered Interface Strategy Documents for Release 1,2 and 3 and received sign off from client.

Provided support during UAT and transition to Production of Release 1 system. Role: Interface Lead

Environment: Ascential Data Stage, MS-Word, MS-Excel, MS-Access, Visual Basic 6.0, Oracle 10g, Rational Manual Tester, Rational ClearCase, WebSphere Business Modeler.

2003-2008 Saber Consulting, Inc. Salem, OR

Senior Consultant

Client: Department of Human Service (OR-DHS – Office of Forms and Documents) 09/05 - 01/07 Project: Oregon Medicaid Management Information System (OR-MMIS) The Department of Human Services (DHS) wanted their 27 year old mainframe system replaced. EDS was awarded to implement a new Medicaid Management Information System (MMIS). Electronic Document Management System

(EDMS) was also a part of the new system, which will support workflow and scanning of Medicaid paper claims and other documents.

Installed and Configured Crystal Reports XI Server and Client.

Created groups and added members (users) on Active Directory.

Established SSO (Single Sign On) for Crystal Reports Server through LDAP authentication.

Designed and developed reports in Crystal Reports designer based on client requirement.

Created stored (PL/SQL) procedures in Oracle that was called by the reports.

The reports were published using Crystal Reports Sever and were viewed in a browser.

Created and modified forms/tabs in the COTS (Commercial off-The Shelf Product) product - HighView (Document Imaging Tool) as per client’s requirement using Oracle 9i as the backend.

Designed the database using Oracle 9i Designer.

Developed an application in VB.Net to integrate indexed data (metadata) along with the images scanned from Captiva

(large scale Document Scanning application) to be viewable in HighView. Role: Technical Lead

Environment: VB.Net, HighView 4.0.1, Crystal Reports XI, Oracle 9i, TOAD Client: Snohomish County, Washington 04/04 - 09/05 Project: Snohomish County (SNOCO) Document Imaging The Snohomish County (Everett, WA) Juvenile Court awarded Saber Consulting to implement an Electronic Document Management System (EDMS). The system supported scanning, workflow and retrieval of documents (with images). The new system also included integrating with their existing legacy system (Mainframe).

The project consisted of designing and developing forms in HighView (Document Imaging Tool) with Oracle 9i as the backend.

6 of 7

Designed and Developed a Graphical User Interface (GUI) for execution of reports for 4 different departments.

The interface was created in Visual Basic 6 and Crystal Report Viewer was integrated with it for viewing of reports.

Created customized forms/tabs as per user requirements and implemented within HighView.

Few of the forms fetched and inserted data to a SQL Server database while others inserted to an Oracle database.

Created various reports using Crystal Reports v10 that helped TRACE (Total Records and Case Exhibits) Administrators with system administration.

Integrated the reports with HighView and displayed the output in Crystal Reports Viewer.

Designed and developed a macro using VBA to retrieve data from an Oracle database and display it on the header of every section. The macro also retrieved all TIFF images for the data and displayed it in the body of the document.

Developed an application to print Barcode Labels of the data being retrieved from an Oracle database in VB6.

Created a connection from Oracle to SQL Server database.

Integrated TIFF images with data received on a CD with HighView.

Configured EDMS (Electronic Document Management System) HighView Web Gateway, which included web server setup and web page design for retrieving document on the web.

Configured HighView Print Server to control printing of large documents in sequential order.

Created PL/SQL procedures to migrate non-relational data from legacy FoxPro based system to an Oracle RDBMS.

Created database triggers to enforce business rules and to prevent invalid transactions.

Created a reporting application using Visual Basic 6, Crystal Reports and Crystal Report Viewer and integrated the reports with the application.

Role: Technical Lead/Analyst

Environment: HighView 4.0.1, Crystal Reports v10, Oracle 9i, TOAD, Visual Basic 6, VBA (Word) Client: State of Oregon 11/03 – 03/04

Project: Oregon Centralized Voter Registration (OCVR) The Federal Help America Vote Act (HAVA) of 2002 requires all states to create a centralized voter registration database. Saber Consulting was awarded to develop a comprehensive statewide database for all registered voters (voter registration) and election management system that will be made available to all counties to replace existing legacy system.

Created control files (.ctl) for purpose of data loading.

Used SQL loader to load data received in different formats into an Oracle database.

Migrated data using Oracle Warehouse Builder (OWB) from databases like Informix, FoxPro, Dbase, and Access to an Oracle database.

Role: Data Migration, Analyst/Programmer

Environment: Oracle Warehouse Builder 3.0, TOAD

Client: San Diego Workforce Partnership (www.sandiegoatwork.org) 05/03 – 10/03 Project: San Diego Workforce Partnership (SDWP)

Generated 4.01 Transitional HTML Web page for SDWP using Interwoven TeamSite (CMS Tool).

Configured TeamSite for SDWP staff to use application as content management system (CMS).

Trained SDWP staff on the CMS tool.

Created reports using Oracle 9i Reports Builder.

Created PL/SQL procedures that were linked to the reports.

Prepared one of the Functional Requirement Specification (FRS) documents. Implemented Dynamic Systems Development Methodology (DSDM) techniques in project processes and procedures. Role: Assistant Systems Analyst/Programmer.

Environment: Oracle Forms 6i, Oracle Reports 6i, Oracle8i, Interwoven, TOAD 2000-2002 NJIT, Department of Continuing Professional Education Newark, NJ Responsibilities:

Provided customer support online and by telephone.

Administered student registration system website and maintained system database.

Updated the website for class schedules, news, and other timely information.

Prepared Microsoft Excel reports on a monthly basis for management analysis.

Created FTP accounts for students and provided technical support for FTP issues.

Configured the Local Area Network using TCP/IP and provided network support. 7 of 7

Role: Webmaster Assistant Program Manager/ Technical Assistant EDUCATION

M.S. (Information Systems), New Jersey Institute of Technology (NJIT)

B.S. (Management), New Jersey Institute of Technology (NJIT)

BCOM, R.D. National College, University of Bombay

Contact this candidate