Anshu Khakural

Email: acxt37@r.postjobfree.com

Contact Number: 651-***-****

**** **** ***** *** ***** NC 27310

I am a technical professional with proven expertise in Business Intelligence analysis, Enterprise Applications Support, Testing, Documenting, Process and Project Management seeking an IT Business Analyst position.

PROFESSIONAL SUMMARY:

•9 + years of IT experience in HealthCare and Manufacturing projects from conceptualization to implementation and support.

•Experienced in complete Software Lifecycle Management process from capturing business requirement, functional/non-functional requirement documents, data flow diagram, data mapping document and UML diagrams for Enterprise Applications.

•Experienced using SQL and SSMT for data extracting and analyzing. Experienced working with relational databases.

•Proficient in broad range of technologies including business process tools such as MS Project, Excel, Access and Visio.

•Exposure to large healthcare database table design, stored procedures and understanding of system process flows.

•Excellent conceptual and experienced knowledge across different software development life cycle process.

EDUCATION:

Bachelors of Science - St Catherine University St Paul MN (May 2005)

CERTIFICATION:

Six Sigma Yellow Belt Certification

TECHNICAL SKILLS:

Requirement Tracking:

HP Quality Center and SharePoint

Change Management Tools:

Servicenow

Operating Systems:

Windows XP/7/10

Databases:

SQL Server, Oracle and MS Access

Office Tools:

Microsoft Office Suite (MS Word, Excel, Access, PowerPoint, MS Project and Outlook)

Modeling Tools:

Visio and IBM Rational Modeler

Customer Relation Management (CRM):

Salesforce and Microsoft Dynamics

Enterprise Resource Planning (ERP):

Oracle and SAP

PROFESSIONAL EXPERIENCE

PepsiCo - Winston- Salem, NC Sept 2016 – Present

Business and Quality Analyst

•Serve as an interface between software developers and system users/stakeholders to create requirements documents, create functional specification documents, design, develop, test, and implement projects (oracle e-suites and web applications) on time.

•Work closely with stakeholders to understand business needs, document process, test new features in projects and help implement new applications to Business.

•Create, execute and analyze functional tests, unit tests, regression tests and smoke tests.

•Collaborate with business and technical partners to implement and rollout of new processes and systems. Track and document changes for functional and business specifications.

Environments:

Oracle Business E-Suite, HP Quality Center, MS Excel, MS Access and MS Word

WellSpan Health - York, PA May 2014 – March2016

Applications Systems Analyst

•Assisted in ambulatory clinical and hospital software upgrades (AllScripts TouchWorks Electronic Health Record Hot Fix v10 and v11), security changes and architectural enhancements so that the data can flow from patient registration, patient care, patient discharge to patient personnel electronic portal.

•Served as an interface between vendors, software developers and stakeholders for software enhancements and change request.

•Developed test cases for effective traceability and developed detailed requirements specifications for software upgrades following Waterfall and Agile methodologies.

•Served as a leader for data integration project with different internal departments to insure successful Go-Live of new software implementation.

•Performed Regression, Smoke, Stress, Graphical User Interface (GUI) and Integration Testing among other Healthcare application such as Pathnet, Cerner, Sunrise, Flowcast and Lawson.

•Extracted and loaded data using ETL tools like Starter Set Migration Tool (SSMT) to modify and upgrade and transfer data from one database to another.

•Provided systems and data analysis, problem resolutions and process enhancements; documented, tracked and reported all system support activities.

•Served as a subject matter expert for operational system and procedural issues for business, HR and IT.

Project Quality Analyst May 2013 –May 2014

•Collaborated with business to design, develop and execute test plans for new application such as Cerner Case Management.

•Created test cases, validate results, relevance and completeness of test coverage to maintain quality of the Integration applications such as Allscripts, Cerner and General Electric.

•Provided final sign off to the key stake holders for requirements traceability of test plans, results for Case Management and All Scripts application changes.

•Understood underlying data structure, data modeling and flow of information to build solution by testing to ensure timely bug resolution.

•Lead and managed testing processes with multiple internal departments and key vendors which included defect identification and resolution.

Environments:

Application Lifecycle Management (ALM) v11,Starter Set Migration Tool (SSMT), All Scripts, Crystal Report, Oracle, SQL Server 2008,MS Excel, MS Word, SharePoint 2010

UnitedHealth Group - Minneapolis, MN September 2011 – February 2013

Business Systems Analyst

•Analyzed business needs, document workflow analysis and translate needs into functional specification documents (FSD).

•Presented FSD to the stakeholders and the IT team to ensure IT deliverables aligned with business requirements with measurable results.

•Conducted Joint Application Design (JAD) sessions and identify risks and issues. Conducted walkthrough of all completed design documents with the team to make sure the documentation is complete and development estimates are accurate.

•Served as a main liaison between Business and System Analysts, Quality Assurance, Developers, and Project Management Groups within UnitedHealth Group non production and production environment for the ad-hoc projects and updates.

•Delivered requirements, performed analysis, and evaluated downstream business impact. Worked closely with Developers and Quality Assurance Analysts to ensure requirements and designs are completely understood.

Environments:

HP Quality Center, SQL Server, TOAD, SQL Developer, SQL Navigator, SQL Plus, MS Project, SharePoint and MS Visio

Wells Fargo Home Mortgage - Minneapolis, MN

Business Analyst January 2011 –September 2011

•Gathered information from end users, conducted business process analysis, evaluated the output requirements and created regular scheduled crystal reports and special reports.

•Extracted and analyzed Wells Fargo Home Mortgage data from multiple source systems and created reports for Wells Fargo managers.

•Worked with computer programmers on database and designed reports for automation.

•Created, supported, and maintained ongoing operational, managerial, and executive reports (i.e. daily performance status reports, online lead report, call report, sales pipeline report).

•Implemented and built new reports using Business Objects/Crystal Reports.

•Developed supporting business case/reports for suggested enhancements. Automated various reports using Visual Basic for Excel.

Environments:

MS Visual Basic, MS Access, Crystal Reports, MS Visio, PowerPoint, Word and Excel

Ecolab Inc. - St. Paul, MN

Project Coordinator February 2005 - December 2010

•Acted as a lead liaison between Marketing, Sales and Information Technology for Water Care division to ensure project timeliness and accountability.

•Served as point person for communication between the division and IT to ensure readiness and compliance of production and pre-prod environment.

•Worked with Marketing Managers, Research & Development, Regulatory Services and Operations to launch rationalize and maintain divisional products and marketing literatures.

•Organized and coordinated divisional annual meetings to communicate group strategy, summarize customer’s needs, and delivered key messages to the sales field.

•Conducted and developed customer analysis using Access to gain marketing business insights; managed and tracked marketing budget.

•Proactively communicated and collaborated with sales, marketing, IT and other divisions to identify opportunities for Water Care business process redesign and improvement.

•Worked on Lean Six Sigma efforts to create efficiencies in managing products and simplifying the product lines for sales personnel.

Environments:

SharePoint, SAP, Visio, EPIC, MS Word, Ms Excel, Ms PowerPoint, Ms Adobe and HTML

Contact this candidate