Project Manager Sql Server

Summary:

. Over * years of experience in business Analyst, driven by creative ideas

and backed by strong Analytical and methodical problem solving skills to

identifying causes and suggest corrective actions to provide innovative

solutions to meet project needs.

. Built strategic partnerships with senior business leaders, clients and

team player to work together as team to meet overall business goals.

. Extensive experience in creating training manuals for corporate and

internal users on Business Process Re-engineering, Business Process

Modeling and SOA (Service Oriented Architecture).

. Certified Associate in Project Management, exposure to Change Integration

methodologies & used lean methodology for continuous process improvement.

. Skilled in working in diverse teams of professionals (IT & non IT) for

enterprise-wide technical transformation projects.

. Project manager and hands on senior business analyst with experience of

working in Healthcare projects.

. Worked as PM for creating a customized Learning Management System for in-

house Employee Training and Development for Larsen & Toubro.

. Documented the Requirement Traceability Matrix for tracing the Test Cases

and requirements and documented and assisted the QA Team with the Test

Plans.

. Expertise in Software Development Life cycle (SDLC), Project Life cycle,

Business Process Modeling (BPM), Lean methodology and Software

Development Methodologies including Rational Unified Process (RUP),

Waterfall, and Agile

. Additional working knowledge, in understanding Organizational Culture and

Development for overall project morale enhancement.

. Extensive knowledge and working experience in creating UML diagrams using

and MS Visio for process simplification for non-technical clients and

users.

. Extensive experience in producing documents Business Requirements

Documents (BRD), Functional Requirement Specifications (FRS), Software

Requirement Specifications (SRS), Request for Proposals (RFP)

. Experience in developing and imparting pre and post implementation

training, conducting GAP Analysis, User Acceptance Testing (UAT), SWOT

Analysis, and ROI analysis.

. Created Key performance indicators (KPI) for Enterprise Risk Management,

Business Continuity Planning (BCP), and Change Management.

. Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio,

Rational Suite and SQL.

. Excellent communication skills to work with diverse personnel (technical

& non-technical) in a wide variety of business and technical

environments.

. Proven track record to comprehensively understand short and long term

business objectives, to identify and report key metrics to PM for

performance metrics.

. Followed a structured approach to organize requirements into logical

groupings of essential business processes, business rules, information

needs

. Development of feasibility studies and strategies expressed in business

artifacts to analyze with different levels of the organization the

project scope and life cycle, to edit/fine tune them according to the

needs

. Periodically checked for any deviations in project scope of against

client requirements and budget.

. Created Training programs and Training manuals for internal users during

new software deployment.

. Extensively interacted with developers in terms of creating, reproducing,

fixing and testing the new builds.

. Created and executed complex SQL Queries as a part of luminance

traceability and identification testing.

. Written Test Cases for ETL to compare Source and Target database systems

TECHNICAL COMPETENCIES

Operating Systems Windows

Engineering Programs AutoCAD, Solid Works, Pro-Engineer, Photopia

Software Tools / HP Quality Center, MS Office, IBM Rational Requiste

Programs Pro, ADP, Business Objects

Project Management Microsoft Project, MS-Visio

Tools

Reporting Tools Business Objects6.5, Cognos 8.0 Suite

Defect Tracking Bugzilla, Quality Center, Test Director and Rational

Tools Clear Quest.

PROFESSIONAL WORK DETAILS

Boys & Girls Village, Milford, CT Oct 2013 - Till Date

Business / Data Analyst

Responsibilities:

BGV's HR & Finance department required updated workforce solutions and

switched to ADP's HR and Payroll system but rigorous analysis on the

enterprise-wide legacy system and help in implementing the new ADP system.

My role was to closely with various functional groups involved groups to

gather requirements, troubleshoot and resolve issues in Implementation,

customized Product Management and reporting.

. Work closely with IT and the data owners/subject matter experts for

requirements gathering

. Assisted in creation of knowledgebase articles, technical notes, how to

documents for change control and application code deployments

. Primary functional and technical liaison ensuring that ADP application is

implemented on time and per client specifications.

. Provided information and explanation of product functionality/design to

client and project stakeholders

. Participated with PM in the development of project schedules by providing

project progress via comprehensive status reports on work progress,

effort, etc. relative to strict project deadlines, and clearly identifies

risks in schedule and scope.

. Created workflow diagrams, UML diagrams, process models using MS-Visio.

. Microsoft SharePoint, used to manage the project related deliverables to

client and maintained internally for the audit purpose

. Conducted user training sessions for new applications while training and

trouble shooting for new application launch

. Developed guidelines/ best practices to reduce costs & turnaround time

for data collection & analysis.

Environment: MS SQL, Igate, COBOL, CICS, SQL Server, JCL, Web Share point,

Quality Center, MS Visio, Tumbleweed, BAM

University of New Haven, West New Haven, CT Mar 2013 - Sep 2013

BA / Data Analyst in Tri-Solar Power Project

Responsibilities:

CL&P partnered with UNH to build luminance analysis software to analyze the

efficiency of solar energy for generation of light, heat and electricity.

Rigorous data collection, data analysis and data tracking were a major

portion of the project for comparing results and to test of software

credibility. PM was in-charge of creating user manuals for internal users.

. Developed guidelines/ best practices to reduce costs & turnaround time

for data collection & analysis.

. Created workflow diagrams, UML diagrams, process models, activity

diagrams, use cases, for incorporating design changes in the legacy

software system

. Worked with the PM & 3rd party vendors for tracking project progress and

resolved any project related issues or technical clarifications.

. Extensively interacted with developers in terms of creating, reproducing,

fixing and testing the new builds.

. Created and executed complex SQL Queries as a part of luminance

traceability and identification testing.

. Written Test Cases for ETL to compare Source and Target database systems

. Analyzing the system/business requirements for migrations of grouped

data.

. Analyzed and translated business requirements into system specifications

utilizing UML and RUP methodology. Documented and assisted the QA Team

with the Test.

. Documented the Requirement Traceability Matrix for tracing the Test Cases

and requirements.

. Managing project with agile-scrum methodology for successful execution

with Joint Application Sessions (JAD) to collect and report requirements,

perform data analysis / reconciliation

. SQL server and various SQL queries used to validate the ICD 9 and ICD 10

values in the backend database system

. Cycle's execution for the latest ICD 10 project and defects tracking and

validating the results.

. Involved in analysis, detailed design, development, testing (UI)

. Assisted Data Architecture process through Business Rules definitions,

Data Acquisition and Data Transformations

. Identified Data Quality, Data Integrity issues and provided Data

Governance solutions to satisfy data needs of Business Users

. Extract, Transform and Load (ETL) and BI tools have been used in the

projects on loading the data and maintain the data for reporting

Environment: MS SQL, Igate,, MS Visio, Java 1.6, COBOL, CICS, SQL Server,

Web Services, XML, HTML, QTP, Quality Center,, JAD, ETL, BI, JIRA

Edible Arrangements International, Wallingford, CT Apr 2012 - Feb

2013

BA in Kiosk Software

Responsibilities:

EAI is launching pre-order automatic ordering kiosks for brand enhancement

and additional revenue generation all over the US. The back-end of the

kiosk software is connected to EAI's franchisee inventory and technical

support team while the front end is customer (public) facing with an

absolute need to be simple & user friendly. Few locations were selected for

product testing and feedback on the kiosk performance was obtained used

focus groups from both public, in-house team and 3rd parties for product

enhancement.

. Performed all the high level requirement analysis to design new modules

and functionalities

. Modified and used Project Templates to gather the requirements and carry

on the project.

. Worked with in-house team to developed the logical and physical design of

the database, and created the necessary specifications for the developers

. Reviewed the Business Requirement Documents with the cross functional

team to analyze the High Level Requirements.

. Wrote business requirements specification (BRS) and functional

requirements specification (FRS) documents as per the business

requirements and process flow.

. Performed document analysis involving creation of Use Cases and Use Case

narrations using Microsoft Visio, in order to present the efficiency of

the gathered requirements.

. Interacted with the development team and product marketing experts making

sure that the development of the project is meeting the business

requirements.

. Interacted with client and the Technical Team for requirement gathering

and translation of Business Requirement to Technical specifications.

. Reporting via web server IIS (Internet Information Services) to create,

edit, delete and move files and directories, and share documents

. Streamlined processes to re-define project scope, milestones, and

deliverables in alignment with stakeholder requirements for new

technology/application deployment.

. Created some data mining structures to help the client to find patterns

and advanced informative queries to be applied to the backend analysis

. Worked with in-house application developers for installation,

configuration and upgrading of Microsoft SQL Server, to establish and

maintain backup and recovery policies and procedures for stored customer

info.

. Identified /recommended product customizations, enhancements, or

alternative solutions based on focus groups to meet client requirements.

Suggested methods for to achieve cost-effective services with increased

quality, efficiency and satisfied customer service

. Worked closely with the PM to suggest inputs on project planning and

control and progress.

. Successfully utilized project management software to increase recovery

rate.

. Performed User Acceptance testing and documented results.

. Trained several internal teams on new processes and operational

procedures

. Conducted GAP Analysis at various stages of the project to flush out high

level requirements from the business users and clients.

. Helped in preparation of test plan/test script for monitoring User

Acceptance Testing. Also helped in preparation of User's Manual and

conduct user training.

. Resolved requirement conflicts across programs/portfolio and between

Operation Support and Saba Vendor.

Environment:, MS Visio, Java 1.6, COBOL, CICS, SQL Server, Web Services,

XML, HTML, QTP, Quality Center, JAD, ETL, BI,IIS, GAP Analysis,CRM

FAVARH - The Arc of Farmington Valley (Non-Profit) Dec 2011 - Mar

2012

Business Analyst - HRIS Implementation

Responsibilities:

Most of the all employee related data were stored, performed and tracked on

paper and with a generous donation FAVARH decided to upgrade to HRIS. The

role of the BA was to bridge information and communication and

technicalities from various departments and work mainly with the PM & in-

house IT team to move FAVARH employee info to HRIS. The BA works supports

the implementation and use of the FAVARH's HR information, including

processes and reporting (non-profit).

. Oversaw & data integrity for implementation of HRIS system, analyzed

complex data for creation of customized reporting metrics.

. Worked collaboratively with in-house I.T team, Finance team and HR team

to maximize HRIS value.

. Analyzed requirements and system capabilities to provide feedback and

insights for improving efficiency and service to internal users.

. Created standard operating procedures for HRIS processes and worked with

Training & Development team for creating basic user manuals for staff

training.

. First-hand experience of HR functionalities and suggested methods for

electronically improve specific HR processes.

. Assisted QA team in SIT and involved in planning, execution, coordination

of entire testing cycle.

. Assisted the QA team in SIT and Business in UAT

. Liaison between Human Resources and Payroll on all FLSA and compensation

issues to ensure legal compliance. Served as a link between management

and employees by handling questions, interpreting and administering

contracts and helping resolve work-related problems.

. Managed and coordinated all HR system related projects and processes

including design, training and implementation of HRIS software; employee

and manager self-service; performance evaluation process.

. Supported and implementing changes to applications for Open Enrollment,

Change of Status and New Hire Enrollment.

. Worked with members of the HR, IT, Payroll and Benefit teams.

. Identified and clearly defined functional issues and supported IT

development staff throughout the design, development, unit testing, and

implementation phases of the software development life cycle.

Environment: People Soft, KRONOS, ADP, SMART, COBOL, CICS, SQL Server, Web

Services, XML, HTML, QTP, Quality Center, JAD, ETL, BI, MS-Excel

Larsen & Toubro, Chennai, India Oct 2010 -

Aug 2011

Project Manager

Responsibilities:

The LMS will establish, implement, and manage all learning management

strategy and system in support L&T's employees, based on industry best

practices and requirements. The LMS PM serves as SME, technical point of

contact, and vendor relationship manager. The LMS system delivered a

technology-astute vision for E-Learning, training reporting, and

performance tracking in support of the L&T Learning model.

. Lead all program communication to business &operational heads across the

board.

. Responsible for creating and maintaining all project related

documentation and reports (BO)

. Scheduled meetings with developers, System Analysts (SA) and testers to

collaborate resource allocation and project completion using MS Project

. Periodically met with stakeholders to gather business requirements during

system & program improvements. (continuous)

. Worked with learning consultant to create a blended learning program

using LMS and achieved 91% participant engagement

. Researched and assessed technologies and applications for adoption into

our suite for future expansion plans and products

. Suggested customization, system usage, operations & online content

integration (AICC, SCORM).

. Provided the development, proofreading and editing of relevant, required

written materials. Like: system overview summaries, on-line help screens

and product documentation booklets & metrics

. Conducted JAD session with learning consultants, stakeholders to

understand, gather and elicit program requirements.

. Documented the Requirement Traceability Matrix for tracing the Test Cases

and requirements

. Responsible for all dashboard, metrics & analytics for weekly project

updates to PM and clients.

Environment: People Soft, KRONOS, ADP, SMART Services, XML, HTML, QTP,

Quality Center, JAD, BI, MS-Excel

Centers for Medicare and Medicaid Services - 20/20 LLC, Baltimore, MD

July 2010 - Oct 2010

Business Analyst

Responsibilities:

The Five Star Quality Rating System is a CMS initiated effort to help

educate consumers on quality of nursing homes across the US to make

quality data more transparent for choosing their service providers. Data

to support these star ratings come from surveys, administrative (claims)

data, and medical records. The health reform legislation (Affordable Care

Act) ties federal reimbursement rates for insurance carriers

administering Medicare Advantage products to performance, as measured by

the Stars rating system.

. Elicited requirements via interviews, requirements workshops, used cases,

and workflow analysis.

. Supported all change management efforts to roll out new processes across

Five Star project

. Facilitated Joint Application Design (JAD) or other design sessions while

creating technical specifications to be used by developers.

. Worked with SME on Medicare, Medicare Advantage regulations and all other

compliances in rules for designing the Five Star Quality System.

. Documented the Requirement Traceability Matrix for tracing the Test Cases

and requirements.

. Used IBM Rational Requisite Pro &RTM to manage business and functional

requirements.

. Worked cross functionally with various teams to plan project timeline

dates and release notes.

Environment: IBM Requiste Pro, MS Visio, XML, HTML, QTP, Quality Center,

JAD, F2F, BO

Accenture - Texas Medicaid &Health Partnership, Austin, TX July 2009 -

July 2010

Business Analyst

Responsibilities:

. Conducted JAD sessions to gather business requirements on new tool and

design improvements, and liaise with developers in technical

implementation.

. Attended HL7 training for healthcare plan system upgrades to X12 gateway.

. Experienced in EDI transactions 835-I and 837-P under HIPAA 5010

compliance.

. Developed Data Conversion Strategy using ETL functions for converting

existing data to the new database.

. Assisted Project Manager to complete the project approval process.

. Conducted in depth interviews with data providers to ensure comprehensive

understanding of data operating logic and data in use.

. Analyzed the 5010 business requirements and created the impact analysis

document to create the test cases and scenarios for the EFE system.

. Coordinated with performance team using load runner to make sure the

performance of the claims

. Used analytical skills to convert customer's business needs into

operational/technical requirements

. Performed Use-Case analysis using UML to capture the dynamic aspect of

the application.

. Used MS-Visio as process simplification tool to non-technical

stakeholders.

. Collaborated with project managers and SMEs to align business goals with

technical functionalities.

Environment: Java 1.6, COBOL, CICS, SQL Server, Web Services, XML, HTML,

EEDIFECS QTP, Quality Center, EDI, GEMS, Agile, JAD, ITIL, Jira, Selenium,

Junit, ETL, BI

Mikco Manufacturing, Wallingford, CT

Junior Engineer/ Design Analyst

April 2006 - Apr 2009

Responsibilities:

. Supervised international projects for quality which led to increased

revenue and clients' satisfaction.

. Used knowledge of Lean methodology for and process improvement and

inventory control.

. Designed machine parts using Pro-E and AutoCAD.

. Hands on skills to manufacture prototypes and worked with customers to

enhance product manufacturing.

PROFESSIONAL CERTIFICATIONS AND TRAININGS

Certified Associate in Project Management - International Institute of

Project Management

Change Integration Workshop with Alpesh Bhatt, Mel Toomey and Daryl Conner

Contact this candidate