Summary

• 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
• 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.
• Imaging Tools: HighView 4.0.1, Kofax Ascent Capture 6.1
• Portal Tools: MS SharePoint

Relevant Professional Experience

Confidential

Senior Consultant

Confidential

• 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

Confidential

• 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 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.
• 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.
• 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 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.

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.

Confidential

• 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.
• Interacted with various agencies within and out of state to exchange unemployment data.
• 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.

Confidential

Senior Consultant

Confidential

• 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.
• 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

Confidential

• 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.
• 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

Confidential

• 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

Confidential

• 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

Confidential

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.