MONIKA GUPTA E-mail: ***************@******.***
Mobile: 408-***-****
SUMMARY
· System Analyst with over 15 years of total IT experience.
· Proven track record of successfully leading complex and highly challenging projects.
· Successfully executed projects with a very steep learning curve.
· Expert in business process engineering and software development life cycle, including analysis, design, testing and implementation of software applications.
· Adept at reducing development costs and providing traceability of projects.
· Excellent communication, analytical, interpersonal, and presentation skills.
· Proficient at requirement specification gathering and documentation.
· Skilled in using root cause analysis to recognize issues and develop process improvements that lead to cost savings.
· Exceptional in planning and implementation capabilities. TECHNICAL SKILLS
Software Development
Methodologies
Waterfall, Agile
Testing Manual Testing
Project Management MS-Office, Omniplan
Operating Systems Mac OS, Windows, Linux
Development Operation
tools
Jenkins, Rundeck
Other Tools Radar, Connectme, Centralstation, Box, Quip Page 2 of 5
EDUCATION
• Certification in Essentials of Business Analysis Villanova University, USA
• Bachelor’s in computer technology
Nagpur University, India
WORK EXPERIENCE
Employer: Quest Global, USA June 2018-Current
Project Lead/System Analyst — Real Estate & Legal Systems
• Working as a Project Lead and helping to drive various application projects through their complete lifecy- cle.
• Partner with business teams to understand, analyze and document the requirements for software develop- ment.
• Facilitate communication between internal business partners, technical team and product vendors.
• Validating the deliverables from dev teams and product vendors.
• Troubleshoot and analyze the system issues.
• Effectively communicate the weekly status of various applications. Employer: Quest Global, USA June 2018-Nov 2018
HRIS QA Analyst — Employee Systems
• Content management on ConnectMe for the project status, project UAT status etc.
• Authoring, executing and maintaining test plans and test cases for manual and automation testing. Page 3 of 5
• Functional Testing.
• UAT Support.
Employer: Introlligent, USA Oct 2016-Sep 2017
HRIS Business Analyst/PM — Talent Acquisition System
• Requirement validation and gap analysis.
• Content management on ConnectMe for the project status, project UAT status etc.
• Content management on ConnectMe for the business analysis tasks in the project.
• Authoring, executing and maintaining test plans and test cases for manual and automation testing.
• Functional Testing.
• UAT Support.
Employer: DGN, USA Feb 2015-Jan 2016
Role: Business Analyst — CRM-SFA (SFDC)
• Requirement gathering from business and documenting for development team.
• Participated in design sessions.
• Authoring, executing and maintaining test plans and test cases for manual and automation testing.
• Functional Testing.
• Attaining daily status meeting and business meetings with end client to take proper clarifications.
• UAT Support.
Employer: DGN, USA Apr 14-Jan 2015
Role: Business System Analyst/QA Manager — Customer Portal
• Gathering development requirement from client’s functional team and from functional design specifica- tion documents.
Page 4 of 5
• Authoring the technical design documents for the given functional design.
• Development Functional Owner.
• Functional Testing.
• Attaining daily status meeting and business meetings with end client to take proper clarifications.
• UAT support.
• Post-production issues support.
Employer: Exilant, USA Nov 12-Mar 14
Role: Business System Analyst/Project coordinator — Development Operations
• Build and release management.
• Infrastructure management.
• Co-ordination with IT teams for resolution of application infrastructure issues.
• Developed and monitored effective project plan and release plan, ensuring timely execution of mile- stones and deliverables.
• Development Operations lead.
• UAT and Production issues support.
Employer: TCS, USA Aug 11-Dec 11
Role: Business System Analyst — Finance System Expansion Project: Expansion of finance administration applications for the new geographical areas added for Apple’s business. Linux migration and Oracle 10g Upgrade of Apple Finance Applications for better performance.
• Gathering development requirement from client’s functional team and from functional design specifica- tion documents.
• Authoring the technical design documents for the given functional design.
• Attaining daily status meeting and business meetings with end client to take proper clarifications.
• Developed and Implemented the applications for the new area.
• Developed the Pl/Sql and Unix code for adding the functionalities for the new geographical area added for Apple's business.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Created test cases for System Testing (Development Environment), Integration Testing (UAT) and Pro- duction (Post Implementation Review).
• Review of the performance testing results and providing input to the testers or Production support team. Page 5 of 5
• Upgraded application servers to Linux and database to Oracle 10g for various finance applications.
• Modified procedures and server configurations to be compatible with Oracle 10g and Linux. Employer: TCS, USA Nov 10-Aug 11
Role: Business System Analyst — Telecommunication Expense Management System: Maintenance of the Telecommunication Expense Management System for Apple.
• Gathering development requirement from client’s functional team and from functional design specifica- tion documents.
• Authoring the technical design documents for the given functional design.
• Attaining daily status meeting and other meetings with end client to take proper clarifications.
• Developed and Implemented the applications for the new geographical areas added for Apple's business.
• Developed the Pl/Sql and Unix code for adding the functionalities for the new geographical area added for Apple's business.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Creating test cases for System Testing (Development Environment), Integration Testing (UAT) and Pro- duction (Post Implementation Review).
• Review of the performance testing results and providing input to the testers or Production support team.
• Upgraded application servers to Linux and database to Oracle 10g for the Telecommunication Expense Management System.
• Modified procedures and server configurations to be compatible with Oracle 10g and Linux.
• Maintaining and supporting the application in production environment. Employer: TCS, USA March 08 - Oct 10
Role: Business System Analyst/Project Coordinator
Dev Ops/HR System Build and Release Automation:
Automated the build and release process for various applications used in the HR Systems of Apple. This involved automation of build process of front-end applications, deploying of web applications and deployment of JBoss servers. The release report developed for the system published the details of development giving the count of warning and errors. This enabled easier tracking of development and testing of multiple projects by the Program Managers.
• Designed the Build and Release System.
Page 6 of 5
• Presented the design details to the Program Managers and developers in the team.
• Attaining daily status meeting and other meetings with end client to take proper clarifications.
• Developed the Automatic build and release System from scratch.
• Creating test cases for System Testing (Development Environment), Integration Testing (UAT) and Pro- duction (Post Implementation Review).
• Developed the Pl/sql and Unix code for various functionalities of the build and release system.
• Developed the Reporting tool for the recurring build release of the day.
• Implemented the build and release process.
• Maintaining and supporting the build and release process in production environment.
• Aided engineers on performance tuning for critical areas.
• Optimized server performance, accuracy, failover and scale.
• Collaborated with development team to troubleshot and resolve issues.
• Implemented and managed framework for evaluating application performance.
• Provided support to conduct system testing and integrated more servers to the infrastructure. Employer: TCS, USA March 08 - May 08
Role: Performance Analyzer — HR System Performance tuning: Performance tuning of the applications used in HR Systems of Apple.
• Diagnosed and improved the slow performing queries by performance tuning of the Pl/Sql code for vari- ous applications in HR Systems of Apple.
• Worked with DBA to optimize the database parameter settings.
• Tuned the Sql queries to improve the performance timing.
• Tuned the Pl/Sql code to improve the performance timing.
• Created Indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Review of the performance testing results and providing input to the testers or Production support team.
• Upgraded application servers to Linux and database to Oracle 10g for various finance applications.
• Modified procedures and server configurations to be compatible with Oracle 10g and Linux.
• UAT and post-production support.
Page 7 of 5
Employer: TCS, India Dec 05 - Feb 08
Role: Team Member — Apple Customer Database
Developed stored procedures and Unix scripts for the business requirements. ACD was supporting the Campaign Management System for Apple. All existing customers of Apple products are emailed the details of the new products launched in Apple as per their privacy settings.
As a software developer, worked on developing Campaign Management System for Apple products launched in mar- ket, responsible for writing business logic using Pro*C, Pl/Sql Stored Procedures, Unix shell scripts and SQL.
• Create low-level design from Business requirements.
• Developed and maintained the system.
• Performed key roles in all major phases of SDLC.
• Quickly learned a wide range of technology skills and business knowledge required for my projects.
• Commended for my ability to easily and effectively transition between the role of a software developer and that of test engineer whenever need arises.
• Instrumental in initiating and developing best practices for software quality enhancement and develop- ment and thus reduced the number of recurring bugs.
• Has done proper documentation of the application I’ve developed, for better future understanding.
• Supported from application side database migration from Oracle 9i to Oracle 10g.
• Performed data migration for very high-volume interfaces.
• UAT and post-production support.