Project Manager / Sr Business Analyst
Resume:
POOJA ARORA GUPTA
*****.*****.*****@*****.***
PROFESSIONAL SUMMARY:
Project Manager / Sr. IT Business Systems Analyst offering over 9-years of experience and hands-on
technical skills in systems and requirements analyses and documentation, team building, project scope
designs, customer relationship building, database and computer programming.
Highlights of qualifications:
• Expert in business process engineering and software development life cycle, including analysis, design, development, testing and implementation of software applications.
• In-depth knowledge of Rational Unified Process (RUP); risk engineering; data modeling and mapping; and design using UML, Rational Rose, and Visio.
• Familiar with current industry standards, such as HIPAA and ISO; currently participating in HIPAA 5010 requirements gathering and analyses
• Skilled in facilitating JRP, JAD Sessions with technical and business users in order to obtain business requirements. Experienced in translating JAD information into technical specifications.
• Versed in analyzing, developing and documenting various work flow diagrams including Use Cases, ER Diagrams, Activity Diagrams and User Documentation
• Fluent in analyzing, creating and maintaining business requirements trace ability matrices, process flows, and use cases (day in the life flows)
• Experienced in preparing system documentation to include functional specifications, testing documents, user manuals, and training materials.
• Possess solid experience in databases including developing and executing complex queries, writing stored procedures and developing and executing complex and custom reporting
• Solid experience in application testing including performing System, Integration and Performance Testing
• Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.
TECHNICAL SKILLS:
• Applications: IBM - DB2, Oracle 9i, Crystal Reports, Visio, SPSS, TOAD, HTML, QMF, GIS, Stat Graphics, Oracle 9i, SAS, SQL, Rational Rose & MS Project, Rational Quality Manager (RQM), CA-MMIS system, SharePoint, ClearQuest
• Languages: VB.Net, C, C++, Java & Pascal.
• Operating Systems: MS DOS, UNIX, Windows 2000, Windows XP & Office 2007
• Databases: Microsoft Access & FoxPro
• MS Office: Word, Excel, PowerPoint & Outlook
PROFESSIONAL EXPERIENCE:
ACS, A Xerox Company, West Sacramento CA June 2011 to Present
Sr Business Systems Analyst - CA-MMIS System
• Responsible for analyzing the electronic claims transactions and creating mapping documentation for conversion to HIPAA 5010 EDI Transaction format
• Responsible for documenting requirements for 270/271, 276/277, 999 transactions for the HIPAA 5010 Enhancements.
• Provide support to the following transactions: 835, NCPDP, 837 I &P.
• Oversee Test Team in development of specific testing scenarios for HIPAA 5010 transactions, test scripts and execution to validate that the CA-MMIS system is functioning appropriately.
• Analyzed business processes, performed needs assessments to align CA-MMIS information technology solutions with DHCS business initiatives.
• Acts as a communication co-coordinator between DHCS, ACS, CGI for Enhancement project.
Maximus Inc., Folsom CA Dec 2007 to June 2011
Systems Analyst – Medi-Cal Account
• Responsible for leading Medi-Cal related transactions for MAXIMUS.
• Adheres to the approved life cycle work patterns, standards, and procedures for systems development, as well as assigned roles in change, issue, risk and project management processes
• Responsible for analyzing the electronic claims and creating mapping documentation for conversion to HIPAA 5010 EDI Transaction format.
• Serves as the lead point of contact and primary client interface for data analysis (host JAD sessions) and business process improvements.
• Creates and maintains business requirements trace ability matrices, process flows, and use cases (day in the life flows) supporting the development of system applications.
• Serves as the liaison between the business and technology staff, with users to identify, define, and confirm system requirements.
• Participates in system testing activities, to include the preparation of test plans, cases, scenarios, and data as well as the execution of system integration testing and system acceptance testing.
• Assists in providing system training in accordance with the project contract requirements.
• Prepares system documentation to include functional specifications, testing documents, user manuals, and training materials.
• Participates in project meetings to represent MAXIMUS in addressing needs of the client and other project stakeholders.
Medinitiatives, Rancho Cordova, CA Feb 2007 to Dec 2007
Data View Analyst/Developer
• Served as an effective member of the solutions development team for the development and deployment of reports for Medinitiatives products/services.
• Provided reporting on pharmacy claims data by encountering data, membership and external industry information as well as ancillary data such as formularies, provider files, prior authorization files, and medical care quality measures.
• Developed SQL Data Flows and create reports in user preferred formats.
• Developed technical documentation necessary to completely describe report use in Medinitiatives products and services.
• Performed business analyses necessary to identify and develop fully functional reports for products/services consistent with Medinitiatives business model.
• Developed functional specifications, develop technical specifications, and deliver fully functional reporting for software solutions consistent with Medinitiatives business model.
Pacific Health Advantage, Roseville, CA Aug 2005 to Oct 2006
IT Business Analyst
• Assisted the organization in making strategic data-related decisions by analyzing, manipulating, tracking, and internally managing and reporting data.
• Designed and documented procedures for Ad-Hoc Reporting.
• Facilitated JAD Sessions to get the business requirements from the users and translate into technical specifications to the technical/programming department.
• Developed and analyzed work flow diagrams, Use Cases, ER Diagram, Activity Diagrams, User Documentation and online help.
• Participated in the development and documentation of business process changes required to support the business requirements.
• Created Data Dictionary for the database.
• Created SQL queries and writing Stored Procedures in DB2 environment to get data from the database and create reports using Crystal Reports.
• Performed System, Integration and Performance Testing.
• Created a database in Access for Marketing Department.
• Worked closely with the internal stakeholders to gather business requirements to create System Requirement Documentations.
• Performed quality assurance assessments, quality assurance support on project implementation activities
Softmatrix Inc. (Hewlett-Packard), Roseville, CA Apr 2005 to Aug 2005
Business Analyst Consultant
• Developed SQL queries and created reports using Excel, Visio and Crystal Reports.
• Analyzed HP worldwide product data for the Sales and Marketing Department.
• Report generation and analysis for the Sales and Marketing Department.
Informatix Inc, Sacramento, CA Jan 2005 to Mar 2005
Data Analyst
• Developed a Database in Access for Customer Call Tracking System for the State of California.
• Tested various databases and recommend solutions for error correction.
• Developed Data Capture Best Practice Policies and Procedures for the State of California.
• Served as liaison between client management, finance team, and project groups.
• Researched and resolved missing and discrepant data and created reports.
• Responded to requests for proposals, made presentations to customers, and negotiated project timelines and deliverables.
St. of CA Dept. of Health Services, Sacramento, CA Dec 2002 to Aug 2004
Project Intern
• Developed GIS maps and other visual presentations for Women’s Health Survey or related data.
• Gathered, compiled, edited and analyzed quantitative data using QMF and SPSS.
• Established, maintained, documented and managed several libraries based on ACCESS application, VB.net, SQL, and related applications.
• Worked with survey data to develop and research statistical reports and conduct presentations.
• Developed a database in Access for Project Tracking and Ad Hoc reporting.
• Worked with various data to develop end-of year reports.
• Designed and implemented web-based process management tool and job aid.
EDUCATION:
California State University Sacramento
BS – Business Administration/Management Information Systems
Delhi University, India.
BS – Finance & Accounting
Informatics Computer Institute, New Delhi, India
Diploma in Computer Science
Contact this candidate