Pallavi Tyagi

LinkedIn: www.linkedin.com/in/pallavistyagi

SUMMARY

Over 8 years of proven track record of analyzing business processes and leading project management responsibilities. Has worked managed national, international projects. Splits evenly between applications and infrastructure, leading local and offshore project teams and interfacing with project sponsors and Executive Management to ensure customer satisfaction through project success. Expertise lies in planning and executing highly complex projects that unify and coordinate multiple projects teams, stakeholders, executive management and outside vendors to provide stakeholders and business value.

EXPERIENCE

Company

Projects

Position

Project Industry

Tenure

Ameritech Global

Houston Independent School District

Lead BSA / Scrum Master

Education

Sept 2017 – Present

Azket E - Intelligence

Houston Independent School District

Lead BSA / Scrum Master

Education

May 2015 - Aug 2017

Express Scripts

Sr. Business Systems Analyst

Healthcare

Nov 2013 – May 2015

TAP Management

Business Analyst

Oil & Gas

Feb 2013 – Oct 2013

Hannover Milano Fairs

Food and Hospitality World

Sr. Marketing Analyst

Retail & Hospitality

Jan 2012 – Nov 2012

Asian Business Exhibitions & Conferences

Economic Times - ACETECH

Project Manager – Marketing and Communication

Retail & Hospitality

Aug 2010 – Jan 2012

PROJECTS

Houston Independent School District Lead BSA/ Scrum Master May 2015 – Present

Lead Student Information System (SIS) replace and reimplementation project streamlining Data Management/ Synchronization thru Automation of K-12 school student information, Budget: 30M – Methodologies: Agile Scrum

Responsible for development and maintenance for the A4E dashboards for teacher, principals and administrators

Deal with ad-hoc requests from Advisory board members and executive level members of HISD

Manages projects through all phases of the development life cycle, including project initiation, requirements and specifications, design construction, testing, installation and post implementation review.

Act as Scrum Master and lead the scrum meetings

Felicitate dependencies between other Scrum teams (Scrum of Scrum), third parties, and other non-agile waterfall teams

Managed IT portfolio of BI and Datawarehouse team on $65 M SAP FI re- implementation and SAP HCM implementation

Provide on – going support to existing SAP data users and various downstream applications.

Work closely with HISD external venders to ensure the success or the end to end process.

Participated in multiple data integrations projects including implementation of Online Student textbooks for the school district

Work as Application support analyst and provide continuous support to more than 30 data warehouses downstream HISD applications.

Collaborate with multiple Stakeholder groups across the matrix organization to define Key Performance Indicators (KPIs) in alignment with strategic objectives – Identify Process Improvements, Cost Savings and Revenue Generation

Prepare Business Process Models / Workflows to ensure that selected / implemented technology was in strategic alignment

Facilitate Joint Application Development (JAD) Workshops with Business Stakeholders focused on eliciting Critical Success Factors / Success Vision

Create Functional and Technical documentation (by emphasized Assumptions, Dependencies, Constraints, Business Requirements, Key Business Indicators (KPI) and Risk Assessments

Successfully Design / develop Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML

Express Scripts Sr. Business Systems Analyst Nov 2013 – May 2015

Performed extensive Requirements and Data analysis and mapped various data sets like Members, Enrollment, Eligibility, Benefits, Providers, Plans, Products, Benefits, Payers, Medical Claims, Pharmacy Claims, Vision Claims, Dental Claims, Mental Health Claims, Billing, Medical Vocabulary, Privacy Codes, ICD-9/ICD-10, SNOWMED Codes, Hospital Census, Health Surveys, Census, Labs & Vitals etc. from the source tables to the target tables, as per the project requirements.

Worked closely with Business users and other team members to clearly understand the business needs and objectives underlying the defined requirements.

Performed field-by-field mapping of interface between parent EMR system - EPIC and downstream system.

Lead the necessary project activities between Express Scripts and external vendors like Cognizant.

Helped in modeling the data warehouse and the underlying transactional database.

Conducted and coordinated SME reviews that include one to one interview with the SMEs.

Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.

Completed Dataflow analysis using use cases, dataflow diagrams and activity diagrams.

Worked closely with Developers, User Representatives and participated in the product design process including specifications and other document reviews.

Created Class diagrams and ER diagrams and used SQL queries to filter data within various databases like MS SQL Server 2010

Supported data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.

Worked on Analyzing the HEDIS (Healthcare Effectiveness Data and Information Set) measures that need to be used for the product implementation

Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.

Used SQL to test various reports and ETL load jobs in development, QA and production environment.

Conducted UAT to confirm that all derivative products can be successfully processed through stages of the project life cycle.

Utilized a corporation developed Agile SDLC methodology.

TAP Management Business Analyst Feb 2013 – Oct 2013

Co-authored / implemented a standardized Change Management Process to support continuous improvement focused on software quality, increasing productivity, and decreasing cycle time for product development

Assist Product owner to prioritize Product Backlog Items (PBI), & felicitates meeting between Scrum teams

Prepared Business Process Models / Workflows to ensure that selected / implemented technology was in strategic alignment

Facilitated Joint Application Development (JAD) Workshops with Business Stakeholders focused on eliciting Critical Success Factors / Success Vision

Created Business Requirements’ Documents (BRDs) by emphasized Assumptions, Dependencies, Constraints, Business Requirements, Key Business Indicators (KPI) and Risk Assessments

Successfully Designed / developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio

Hannover Milano Fairs Sr. Marketing Analyst Jan 2012 – Nov 2012

Directed exhibit projects through production

Ensured project quality standards are met and a timely project completion.

Conducted weekly meetings with account teams (AEs and AMs) on each project from start to finish ensuring each project is up to company’s standards along with meeting the client’s expectations

Attended put to work meeting to discuss the best way to execute upcoming projects

Build files for production (Service Group, Wood Shop, and Detailing) send task to each department involved on each project and ensured relevant files are attached to projects and have been approved for production

Provided design team with correct requirements.

Worked with purchasing to make sure the proper materials are ordered.

Ensured manifest and packing list are completed and uploaded to project.

Worked with technician packing down outbound exhibits to ensure that photos, metal specs, manifest and packing list are included inside the crate.

Managed inbound property to ensure that inbound work order instructions are completed.

Asian Business Exhibitions & Conferences Project Manager – Marketing & Communications Aug 2010 – Jan 2012

Organized and managed ACETECH portfolio run jointly with The Times Group. ACETECH happens thrice a year, across the major regions in the country including Mumbai, Delhi and Bangalore.

Majorly took care of Domestic and International Participation.

Designed and developed presentations for new business opportunities and client business reviews.

Propose client according to their requirements, negotiate and take decisions of the deal.

Led company efforts in the business development resulting in adding new deals and total solutions for increased revenues, new clients, and improved margins.

ACHIEVEMENTS

Established Projects, HISD’s A4E Dashboards and PWR user environment – Gold Medal

IMS Global - Learning Impact Leadership Institute - 2017

https://www.imsglobal.org/sites/default/files/LILI17/LIAAwards/HISDA4E.pdf

Innovative New Projects and Research, Houston ISD & ItsLearning – Silver Medal

IMS Global - Learning Impact Leadership Institute - 2015

http://www.prweb.com/pdfdownload/13178794.pdf

APPLICATIONS/ENVIRONMENTS

SAP HCM

People Soft

OneNote

CFR 21 Part 11

SharePoint

Chancery

PowerPoint

Confluence

MS Visio

Infinite Campus

JIRA

R.A.C.I Charts

Microsoft Projects

IBM Cognos BI

Office 365 Suite

IBM Cognos Analytics Power User

Microsoft SQL Server 2012

SnagIt

HP ALM

Informatica Power Centre 9.x

IBM Cognos BI 10.2

Microsoft Dynamics

SAP BIBW

AREA OF EXPERTISE

Agile Methodologies

SDLC

Project Management Methodologies

Scrum Agile

Business Analysis

Requirements Analysis

IT Project Coordination

Performance Leadership & Team Motivation

Training and Development

KanBan

AdHoc Reporting

Sales and Marketing

Waterfall

EDUCATION

Master’s in Business Administration, 2010

MIT School of Business, Pune, India

Bachelor’s in Computer Applications, 2007

Bhopal School of Social Sciences, Bhopal, India

Advance Diploma in Computer Programming and System Management, 2006

All India Computer Education Society (AICES), New Delhi, India

CERTIFICATION

JIRA Software & Confluence

The Complete SQL Bootcamp

Efficient Time Management

Database Administration Fundamentals

Business Intelligence & Data Analytics

Business Analysis & Scrum Agile

ADDITIONAL INFORMATION

H1B Visa holder. Valid until June 2020

Relocation considered – Up to 25%

Travel considered – Open

Houston, TX, USA. Phone: +1-713-***-**** Email: ac6qhb@r.postjobfree.com

Contact this candidate