MONIKA SAINI
Senior IT Analyst - Business Analysis
CHICAGO,IL USA
Summary
- 20+ years of professional experience in Leading Trainings in North America on Company's standard tools, Business Analysis, Validation, Requirements Engineering, Project Management and Team leading background in various industries such as Automotive, Healthcare, Education and E Commerce domain.
- Administering JFrog Artifactory for different projects in ZF Group worldwide and working on MS Azure DevOps application to follow our daily business work items.
- Experience in gathering user requirements, preparing and analyzing both Business Requirement Documents (BRD) and Functional Requirement Documents (FRD), and proposing changes for process improvement with use of the various internal and external requirements gathered
- Comprehensive understanding of the Organizational Framework that helps to map the AS-IS and TO-BE model using the GAP Analysis and plan and monitor effective approach to build/buy solutions to the business problems/needs/opportunities
- Adequate knowledge in EDI/HIPAA health information and health care services regulatory environment working knowledge and compliance experience along with proficiency in using ICD10/ CPT/ANSI/HL7 coding standards
- Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members
- Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams
- Ability to perform Data Mapping and Data Migration
- Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Reports
- Active involvement in User Acceptance Testing (UAT) and training of end-users
- Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Self-Starter, Analytical, Presentation Skills, and Leadership Qualities
Overview
22
22
years of professional experience
Work History
Sr. IT Analyst – Business Analysis
ZF Group
04.2017 - Current
- Responsible for administering JFrog Artifactory requests, issues, controlling end users roles and rights, granting permissions by following ZF security standards, organizing training with JFrog and supporting other team members to enhance their knowledge on this topic.
- Working on MS Azure DevOps application, responsible to create Epics, Features, Product Backlog items, Tasks, Impediments and follow the complete lifecycle by going through the following states at every level, which helps our end users to understand the status of their work items. Providing hands-on training to the ZF colleagues on how the hierarchy works and making them familiar with different states to complete the work on PBI's.
- Leading trainings in ALM Integrity tool (ZF's central tool) in different regions of North America in ZF Group (automotive company) and set up training environment to make users comfortable with Builds, Deliveries, Open Points, Change Requests, Tasks, Actions and so forth to understand the complete Integrity Application Lifecycle and implement in their daily business.
- Successfully led and implemented the File Vaulting Project which helped us to recover Integrity DB space back and also impacted positively to lower our cost and less burden on the DB, improved DB performance at the same time.
- Successfully led and supported the Test Management module of Integrity, collected business requirements, dependencies on different modules and interpreted them to the development and implementation teams. Deeply involved how we were setting up the configuration for this module.
- Participated in annual audits (internal and external) of Integrity tool; responsible to provide details to the auditors, how the lifecycle works, providing evidence if users are following the complete process and following ASPICE standards and a lot more to answer based on the auditor's in-person inquiries.
Onsite Project Manager
Lear Corporation
05.2016 - 03.2017
- Working on Data mapping, Data validation and Data Migration from Legacy System (AS/400) and SAP SRM System to LPRS (Lear's Purchase Order Retrieval System) Database Repository.
- Creating LPRS Web Application to facilitate Buyers and Suppliers by providing the mirror image of their current system with more advanced features.
- Generating PO PDF's with ETL process using SQL Server Reporting Services Tool (SSRS) and conducting tests to compare it with SAP SRM PO PDF's.
- Responsible for Managing and Tracking Project Plan Activities, gathering Business Requirements, creating a BRD, Reviewing Project Design and Code with Business Clients and their IT team.
- Responsible for supervising work activities with offshore (Development, Testing Teams) to ensure that they are well-performed, coordinated among team members and consistent with the approved work plan.
- Single point of contact for Offshore and responsible to facilitate Daily Meetings with Internal Team (which includes: DBA, Developers and QA).
- Responsible to facilitate Weekly Status Review Meetings with Business and Internal Management Team.
- Responsible to create Change Requests (CRF) as per changing Business needs.
- Responsible for publishing all the updates on SharePoint which includes Weekly status, MOM, CR's, updated BRD's, Signed-off Design documents (ERD's, Table Structure etc.), UAT Test Results and uploaded local files etc.
- Responsible to create Test Cases and run Unit Test, Functional test, Integration and Performance Test.
- Conduct back-end testing of the application using SQL Queries and log all the defects in the defect tracker.
- Performed validation testing on all the data coming from SAP SRM to LPRS Database system.
- Setting up a UAT environment for end-users to test the LPRS Database Repository which includes database tables, stored procedures and views developed in SQL Server 2012 environment.
- Setting up UAT environment for end-users to test the LPRS Web Application (second part of Project) which includes web pages, developed in .Net.
- Setting up UAT environment for end-users to test the LPRS PO PDF's (third part of Project) which includes generation of PO PDF's using SSRS (Reporting Tool).
Data Analyst / Business Systems Analyst
Integrated Health Associates
01.2013 - 05.2016
- Worked on numerous dashboard and reporting solutions such as BMI Report for Washtenaw county patients and demographics data for 2014, Medco Report to view provider of all charts that have Medco listed as their Pharmacy in their demographics or Express home script Columbus, Ohio; MMP and IHA Urology patients (By using: Linked Server). Numerous SSRS reports on diabetic patients with different end user requirements. The dashboards were designed using MS SQL Server 2008, SSIS, SSRS, MS Excel (Macros, Pivot Tables, vLookups and Charts) and SQL.
- Worked on gathering the high-level requirements and documenting it in the business requirements document (BRD).
- Prepared the UML and Use Case Diagrams for different measures requested by the BU.
- Prepared the mockups for the BU to help them understand As-Is and To-Be process.
- Prepared Technical Specification Document for the development team with diagrams built in MS Visio.
- Identify the reporting requirements, source data, destination data, and create functional requirements for the reports.
- Conducted Database analysis via Microsoft SQL Server to run ad-hoc reports weekly/monthly for upper management using SQL queries to generate excel reports/charts.
- Worked with the SSIS packages to understand the logic behind As-Is reporting for the aspect reports.
- Worked extensively on the SQL Server 2008 to understand the tables and views being developed by the development team and connect those views with SSRS to build the dashboard.
- Created multiple reports in SSRS based on the requirements from the functional document and discuss it with the project stakeholders.
- Environment: SSIS, MS SQL Server 2008/2012, MS Visio, MS Office, MS Excel (Macros, Pivot Tables, Charts and Graphs), SQL Server Management Studio 2012 (SSMS), Visual Studio 2008, SSRS, SSIS
IT Analyst
Eastern Michigan University
08.2011 - 01.2013
- Worked on Design, Development for the upgrades to the Eastern Michigan University Web portal and Tracking System Project for Eastern Michigan University's Website of Community College Relations (CCR).
- Analyzed, documented and managed all project requirements by creating Business Requirements and Functional Requirements.
- Coordinated and Conducted individual and group (JAD) sessions with the Director and Assistant Director of CCR and technical units at Eastern Michigan University (EMU).
- Worked with PM to prepare Project Charter, Project plans, daily, weekly and monthly team deliverables for each phase, drafting WBS and RBS systematically using MS Project.
- Created critical Use Cases and did intensive use case analysis.
- Developed activity diagrams, use case diagrams and other UML notations with RUP methodologies.
- Authenticated technical designs, User Interface (UI) created by IT developers and ensured if they tallied with the functional specifications.
- Communicated with Director of CCR throughout the lifecycle of the project and kept them updated with the progress of the same.
- Ensured that all the artifacts are in compliance with corporate SDLC Policies and guidelines.
- Coordinated with the Project Manager and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time to ensure accuracy and consider deadlines.
- Environment: MS Access 2010, MS Office, My SQL (Apache Server), PHP
IT Analyst
Simply Pennies
07.2008 - 08.2010
- Worked on design and development of the Payroll System and Plotting Marketing Strategies.
- Gathered requirements using methods like personal interviews, questionnaires, and team meetings with Business Team.
- Organized walk through with system developers to explain the business and system requirements and validate end-user requirements.
- Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS) and Test Cases.
- Environment: MS SQL Server, SQL, MS Visio, MS Office, MS Excel
Lecturer / Instructor (Computer Science Department)
Lala Laj Pat Rai Institute of Engineering and Technology
08.2004 - 08.2007
- Responsible for preparing and delivering lectures, designing project assignments, setting up the terminal exams, preparing quarterly reports, attendance reports etc.
IT Analyst
Sify Ltd
06.2004 - 08.2005
- Worked in their E-Solutions group to upgrade SIFY India's web portals and worked on revamping Indian Airlines website.
- Facilitated (JAD) Joint Application Development sessions to identify the business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
- Studied and analyzed competitor's applications and brainstormed to gather effective requirements for a quality product.
- Engage in project initiation activities such as developing the Project Charter, Project Scope and assisted the management in resource and budget estimation.
- Created Business Requirements Document and converted them into System Requirement Specifications Document.
- Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application.
- Prepared Test cases and Performed Unit Testing, Functional Testing, Performance Testing.
- Environment: MS Office, ASP.NET
Education
Master of Science - Information Systems
Eastern Michigan University
Ypsilanti, MI08.2013
Master of Computer Applications - Computer Science
Punjab Institute of Management And Technology
Punjab, India07.2005
Bachelor of Computer Applications - Computer Science
KMV
Punjab, India07.2002
Skills
- Azure DevOps, JFrog Artifactory, BMC Helix, BMC Remedy, PTC Integrity ALM platform (Configuration Management, Change & Release Management, Test Management), Agile/SCRUM, JIRA, ProjectLibre, Waterfall, Spiral Model, MS Visio, MS Access, SQL Server, SQL Server Management Studio 2012 (SSMS), Visual Studio 2008, SSRS, SSIS, SQL, NET, C, C, Visual Basic, Java Script, HTML, DHTML, Flash, CSS, Xml, Microsoft Office Suite (Word, Excel, PowerPoint, Access, Outlook, SharePoint 2010), Microsoft Project, MS Teams, Shoretel Communicator, Ivanti Communicator, Pulse Communicator, Skype Business, Confluence, SVN Tortoise, Testing Strategies – Black Box, Integration, Unit, Performance Testing and User Acceptance Testing (UAT), Healthcare Tools: EMR, EPM, EHR
- IT service management
- DevOps principles
- Application development
- Test planning and documentation
- Data analysis
- Support documentation
- System architecture
Languages
English
Full Professional
Hindi
Native or Bilingual
Punjabi
Native or Bilingual
Timeline
Sr. IT Analyst – Business Analysis
ZF Group
04.2017 - Current
Onsite Project Manager
Lear Corporation
05.2016 - 03.2017
Data Analyst / Business Systems Analyst
Integrated Health Associates
01.2013 - 05.2016
IT Analyst
Eastern Michigan University
08.2011 - 01.2013
IT Analyst
Simply Pennies
07.2008 - 08.2010
Lecturer / Instructor (Computer Science Department)
Lala Laj Pat Rai Institute of Engineering and Technology
08.2004 - 08.2007
IT Analyst
Sify Ltd
06.2004 - 08.2005
Master of Science - Information Systems
Eastern Michigan University
Master of Computer Applications - Computer Science
Punjab Institute of Management And Technology
Bachelor of Computer Applications - Computer Science
KMV