Manager Project
Resume:
Neha Kapil
+1-778-***-**** *** Brunswick Ave, Toronto, ON M5S 2M5, Canada **********@*******.***
Business Analyst
Retail • Data Processing • Finance • Healthcare
1
Manager and Business Analyst Active roles of AGILE manager and Scrum master
Providing solutions, assessments and validation to a broad range of situations by eliciting, planning,
monitoring and analyzing enterprise requirements using modern AGILE methodologies for extremely large
enterprises. Relentlessly improves requirement gathering, streamlines business processes, and cuts
overhead. Known for exceptional strength in following areas:
Leadership: Skilled at building a strong team environment, and have the ability to acclimatize to
•
new technologies, conditions and situations with ease.
Initiative: Excellent understanding of Agile Software Development Life Cycle (AGILE SDLC)
•
methodologies of software development including participation in Sprint’s and daily Scrum’s. Excellent
problem solving, team building, judgment and decision making skills.
Versatility: Six plus years of experience, in IT software management in various industry domains
•
like healthcare, retail, telecom and finance.
Business know how: Hands on experience in creating Unified Modeling Language Diagrams
•
(UML) including use case diagrams, context diagrams, activity diagrams. ITIL based IT service management
along with Software Requirements Specifications Documentation (SRS), and scope documents, requirement
elicitation techniques such as interviewing, questionnaires, brainstorming, focus groups, prototyping,
cost/benefit analysis and risk analysis.
Technical know how: Extended understanding of ER Diagrams along with practical experience in
•
matching models to that of business requirements through tools like ERWin or Abnitio. Adept at using
different databases and related tools, viz. Oracle, DB2, Teradata, SQL server, TOAD etc. Adept at using MS
Team Foundation Server (TFS) to keep track of project status, including entering and prioritizing work items.
Creating use case models with Microsoft Visio.
Team Player: Hands down participation with different teams like QA, DBA and Dev., interchanging
•
roles to speed up the development process, thereby maintaining project deadlines and delivery dates.
Written and oral communications: Present effective use of written, verbal, and non verbal
•
communication, employing relevant knowledge, skills, and judgment in a business setting.
Experience
Boston Pizza Inc. Business Analyst/Project Oct 2012 – Present
(Canada/BC) Manager
Boston Pizza is a fast food restaurant chain. I am working with an AGILE team of architects, consultants and
project managers – delivering requirement documents, scope definitions etc. for the enterprise data ware
house including different data marts viz. marketing, finance, operations, food services, etc. Delivered canned
and ad hoc reports as part of the products and product development.
Resolved through active intervention and the use of different communication mediums the
•
requirements elicitation and documentation from different stake holders residing in multiple time zones.
2
Maintained project deadlines and delivery dates even with limited manpower by actively taking on
•
different roles like that of a developer, QA, manager etc.
Resolved data format discrepancies among multiple data vendors by creating and documenting a
•
standard data format template and transforming the vendor data to this template.
Helped create an in depth project development work flow eliciting key development phases and main
•
stakeholders for transparency and accountability.
Prioritized emergency task/work for immediate action by increasing the delivery order and removing
•
trivial items from the sprint based on product owner’s recommendation.
Resolved poor quality management and development of software by introducing newer technologies
•
like Balsamiq mockups and Team foundation services to the development team and the stakeholders.
Increased the efficiency of the ETL process by almost 20% by removing redundant tasks and fixing
•
erroneous parts of the data flow diagram.
Brought down total project delivery time by almost 15% by delegating to self some of the QA and
•
the SQL tasks.
Environment: AGILE, Team Foundation Server 2012, MS SharePoint, Test Cases, JAD, SQL, XML, FTP,
MS Office, Windows 7, MS Visio, Balsamiq mockups, SQL server 2012/08, Microsoft Outlook
Inovalon / Medassurant Business Analyst Jan 2012 – Sep 2012
(USA/MD)
Inovalon (the new name of MedAssurant) is a healthcare technology company that combines advanced data
analytics with highly targeted interventions to achieve meaningful impact in clinical outcomes and financial
performance across the healthcare landscape. Helped in creation of management products which could be
used to being down operational costs for claims processing and management.
Identified and fixed data anomalies that were being transmitted from the external vendors by
•
refining/ modifying the data transform, ETL and business process’s using UML diagrams.
Brought down considerable development time by working hands down with the Data Modeling
•
Teams on their Erwin models.
Helped the Quality Assurance teams by explaining practical Use Case and Test Case scenarios and
•
also helped perform routine data quality checks by providing sample test data and SQL queries.
Identified PHI information on the production environment for encryption to maintain and conform to
•
HIPPA standards and policies.
Requested a DE identified replica of the production environment for use as UAT. Worked with the
•
DBA teams providing the de identification logic.
Augmented the project workflow to incorporate immediate solutions for escalated work items/ PBI’s
•
as identified by the stakeholders and the product owner.
Became a model team in the company for use of our AGILE project management practices using
•
Team Foundation Server, which included training all the stakeholders in backlog management and
generating daily status reports.
3
Environment: AGILE, Team Foundation Server 2012/08, MS SharePoint, Use Cases, SQL, UML, JAD,
XML, FTP, MS Office, MS Visio, Balsamiq mockups, Windows, Erwin 7.2/4.5 (Data Modeling, ER
Diagrams), SQL server 2012/08, Microsoft Outlook
Vedicsoft Solution Inc.’s client Business Analyst Jan 2011 – Nov 2011
United Health Group USA/MN)
United Health Group is a leader in the health benefits and the health services industry. Was part of a large
focus team developing various world class customer centric web portals like OptumHealth, OptumInsight,
and OptumRx, identifying and documenting requirement’s, user stories, use cases and performing final
user acceptance testing on multiple domains and environments.
Managed constantly changing requirements by performing Gap analysis directly with the
•
stakeholders and educating them on the cost implications and overall development impact as a result of the
change. This resulted in better defined and more stable requirements.
Made the websites more secure by contracting security experts to perform penetration testing on the
•
final UAT versions of the products.
Designed a workflow that took inputs from a wider audience via. a survey and inculcated their
•
responses into the main system, which could be analyzed.
Designed the websites to cross the platform barrier by creating additional mockups and screens for
•
mobile devices which were touch based and were required to use very little data
Reduced development and delivery time by almost 20 %, by recommending the use of existing
•
Single Sign On technologies which were in use within the company.
Greatly increased product efficiency by performing ‘AS IS’ – ‘TO BE’ analysis on the existing
•
system and making appropriate recommendations like Oracle version upgrades and server farm upgrades.
Environment: AGILE, Team Foundation Server 2008, MS SharePoint, Use Cases, SQL, UML, JAD, XML,
MS Office, Windows, Erwin 7.2/4.5 (Data Modeling, ER Diagrams), SQL server 2005, Oracle 11g,
Microsoft Outlook
Vedicsoft Solution Inc.’s Business Analyst / Project May 2009 – Aug 2010
client Meijer’s (USA/MI) Manager (Intern)
Meijer is one of the leading retail stores in the country. Worked along with the data modeling team to gather
requirements for an enterprise data warehouse that focused on integrating the data from different dimensions
like time, transactions, product etc. in the Meijer’s data warehouse.
Shared product specification with IT infrastructure and IT architectural departments using UML and
•
other system diagrams.
• Managed traceability matrix to trace business requirements, functional requirements, and use cases
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user
acceptance testing.
4
Maintained project timeless in spite of resource constraint’s by participating in the development of
•
the conceptual and logical Data Models for an integration layer, defining and identifying different
dimensions.
Reduced the complexity of the Enterprise Data Warehouse by fragmenting and separating individual
•
dimensions in the integration layer and later compiling all the data models.
Increased efficiency of a manual supply –demand – load process by designing and identifying
•
business rules that would help in the automation of this process.
Environment: AGILE, MS SharePoint, MS Office, JAD, UML, SQL, Data Analysis, SDLC, Use Cases,
ER/Studio (Data Modeling, ER Diagrams), Teradata 12.0, PL/SQL, Windows XP, DB2
TELCO Industries Business Analyst Jul 2007 – Aug 2008
(India)
Telco industries are a subsidiary of Tata Industries. Their data warehouse consists of customer, sales and
product information. The reporting division uses the data to increase the sales of the company and for
corporate reporting.
Conducted JAD sessions for requirement analysis, risk analysis, adaptability and feasibility studies
•
with various stakeholders like designers, developers, QA and management staff to identify business
critical and high risk areas of the application.
Collected information from the developer teams and created trouble tickets for business process
•
related issues and improvement requests.
Extensive project coordination experience working on multiple projects of various sizes and
•
complexity utilizing Microsoft Project.
Executed SQL queries to retrieve information from oracle data sources to generate various reports to
•
be submitted to sales managers.
Environment: MS Office, Oracle 8i, JAD, UML, SQL, Data Analysis, RUP, SDLC, Use Cases, SQL/PL
SQL, Windows
M.M. Creations Business Analyst / Administrator Jan 2006 – Jun 2007
(India)
M. M. Creations is a home furnishing export house which designs and manufactures home furnishings. Its
cliental is spread all across Europe, Asia and America. Worked as business analyst on designing an internal
order and manufacturing inventory system which facilitated in managing the companies ever growing
cliental. Features we provided in this system was scheduling, referral tracking, registration, and billing and
collections functionality.
Gathered business requirements, analyzed data/workflows, and defined the scope, financial
•
projections and cost/benefit analysis.
Performed complex analysis of the business requirements from the end user and used UML diagrams
•
to convert them to system specification requirements.
Performed requirements gathering, design analysis, requirements management, business modeling and
•
validation according to the rational unified process (RUP).
5
As a liaison between the developers and end users, was instrumental in communicating user
•
requirements and system requirements among the teams.
• Assisted quality assurance team, by manually testing the GUI of the application.
• Successfully worked with Oracle database and related tools, for example TOAD, SQL/PL SQL etc.
Worked on time critical efforts to develop improved reporting infrastructure and enhanced
•
communications with support partners.
Environment: MS Office, UML, JAD, Six Sigma, RUP, SDLC, Use Cases, Oracle 8, TOAD, SQL/PL
SQL, Windows
Education and Technical Skills
Master’s in Business Administration (MBA): from Eastern Michigan University (Dec 2010):
•
Research and study focusing mainly business analysis, business modeling, document processing, process re
engineering and decision support systems.
Web Tools: Adobe Dreamweaver CS5, Visual Studio 2010/2012, Ultra Edit.
•
Programming Languages: SQL Server T Sql, Oracle Pl Sql
•
Applications: MS Office, Visio, ERWin, TOAD, Team Foundation Server, Visual Studio
•
2010/2012, Balsamiq, Power view
Database: MS SQL Server 2008/2012, MS Access, DB2, Teradata, Oracle
•
Operating System: Windows (32 & 64 bit)
•
Methodologies: AGILE, RAD, RUP, SDLC, Waterfall, Six Sigma, ITIL, etc.
•
6
Contact this candidate