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: *************@*****.***