SUMMARY

• Following several years in managerial positions and subsequently managing an entrepreneurial venture, my thirst for knowledge and a strong desire to learn more led me to one of the most diverse and global MBA programs in the US.
• Class - room learnings combined with the practical experiences help me understand business requirements, analyze impacts of new solutions and attain project goals.
• Overall, I possess 10+ years’ extensive experience in liaising between business and technical departments.

TECHNICAL SKILLS

Modeling Tools: Rational Rose, Balsamiq, MS Visio, Flying Logic

SDLC Methodologies: Waterfall, Waterfall-Scrum Hybrid, Agile-Scrum

Business Skills: SWOT, PESTLE, Change Management, Risk Management, Business & Technical Impact Analysis, Cost-Benefit Analysis

Requirement Management: JIRA(Greenhopper), JAMA, TFS, HP ALM 11.5, Rational ClearQuest, Rally, Version One

Project Management Tools: MS Project, MS SharePoint, Clarity PPM, SmartSheet, Google Docs, Dropbox, Keynote, Slack, DocuSign, GoToMeeting, WebEx

Testing Tools: HP QC v10.0, HP ALM V11.5, Load Runner

ETL Tools: Informatica, Data Stage, SSIS, Business Objects

Reporting tools: Tableau Desktop, IBM Cognos v10, MS Office Suite, Spotfire, MS SSRS, Oracle BI Publisher

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

Databases: MYSQL, WebLogic, Microsoft SQL (T-SQL), Oracle 9i and 10g (PL/SQL)

PROFESSIONAL EXPERIENCE

PROJECT MANAGER/ SR. BUSINESS SYSTEMS ANALYST

Confidential

Responsibilities:

• Produced work estimates, quantitative reports, business performance metrics
• Gathered requirements through brainstorming work-sessions and interviews
• Researched sick leave ordinances for various statutes and discussed with UPS attorney
• Prepared a data grid summarizing all relevant paid sick leave laws
• Developed a UPS facility-mnemonics control-card to be handed over to applications
• Created as-is and to-be activity diagrams using MS Visio
• Developed decision requirements model using a top-down approach with Flying Logic
• Developed project artifacts: BRD, FRD, use cases, context diagram, meeting minutes, BPMNs, narratives, requirements traceability matrix, interface agreement, RACI
• Created screen mock-ups using Balsamiq Mockups 3 (version 3.5.6)
• Part of the panel for selection of rules engine software: Drools, OpenRules, JRules
• Converted business rules in the form of decision tables in OpenRules format
• Developed a standard operatingprocedure for OpenRules artifacts for future projects
• Conducted weekly meetings to track project status
• Conducted unit testing and integration testing by creating test data and test cases to ensure that all business rules combinations are tested
• Involved in stress testing to ensure OpenRules compatibility with mainframe (Server: Tomcat, Protocol: SOAP; Server: WebLogic, Protocol: REST, Language: COBOL)
• Involved in bringing down web services network round trip time from 85 ms. to 30 ms.
• Worked with solution designer and architects to devise architectural approach
• Used Eclipse to fix bugs in the business logic by executing OpenRules decision tables

Confidential

Responsibilities:

• Drafted the project scope document (consisting of in-scope, out-of-scope,risks, issues, dependencies, constraints, assumptions, critical success factors (CSF), requirements approach, high-level business processes, system assessment, business arrangements)
• Involved in data extraction, loading and transformation (ETL) activities
• Decoded 145 SQL stored procedures to extract business rules from application logic
• Created work plan by defining dependencies, milestones and by assigning resources
• Involved in process and security risk assessment (SRA)
• Created functional decomposition document and converted it into a business flow
• Responsible to convert decoded SQL queries into if-then analysis statements
• Drive workshops with medium-large groups of diverse participants in-person/ virtually
• Assist in data governanceby identifying, prioritizing and implementing change while providing status updates measuring impacts across various projects
• Involved in documenting the business requirements, rules, functional and nonfunctional requirements
• Handled communication with the new bank to get information on Interface Agreements
• Assigned action items to the Primary Person Responsible (PPR) for the designated tasks and followed up to ensure completion
• Worked with the project architects to develop a roadmap for ‘to-be’ architecture
• Assisted data modeler in converting requirements into standardized metadata used to create conceptual, logical and dimensional data models
• Managed data dictionary for master data, reporting metadataand metrics glossary
• Developed rules to control the integrity (accuracy, thoroughness, process compliance) of all data within existing databases

Confidential

Responsibilities:

• Documented requirements in the form of INVEST user stories with acceptance criteria
• Conducted daily scrum meetings to review progress and discuss impediments
• Used Team Foundation Server to maintain documents
• Extracted existing reports’ data elements, data sources, datasets, queries and parameters for 85 reports
• Transformed frequently generated user queries into report format

Confidential

Responsibilities:

• Handled communication among remote teams at multiple locations
• Formed cross-functional teams with representation from Human Resource, Payroll, Employee Communication, Information Security (IT), Legal Committees, General & Administrative Portfolio
• Drafted profile grid containing data elements from multiple sources
• Reduced data discrepancies related to employee information by analyzing the data and identifying the authoritative source system
• Created low-fidelity wireframes to define navigation, framework and visual structure
• Captured requirements in the form of user stories along-with acceptance criteria
• Worked with the team to assign story points to user stories on the basis of the priority
• Provided four phased approach for work-effort, timeline and cost roadmap
• Developed lessons learned report
• Conducted bi-weekly status update meetings
• Participated in usability testing for low/ high fidelity prototypes in the design and development processes

Confidential

Responsibilities:

• Utilized SQL to extract data from Oracle databases to prepare reports and insights. As a result of research:
• $8.3 million of the mischarged amount was retrieved successfully
• Additional $9 million were identified as potential refunds due to overpayment
• Customer driver and System driven charges were identified and systemic checks were set-up to avoid those charges in the future
• Additional controls were introduced to correct customer behavior, expected to bring down the penalties by over 70%
• Tracked and compared actual costs to estimated project costs against approved funding
• Designed data flow diagrams to show relationship between data sources and elements
• Delivered signed-off documentation for all phases, including post-production deliverables
• Extracted complex rules from the contracts to be built into the system
• Used excel VBA codes to automate functions, parse data and ease data entry
• Created pivot table reports to summarize raw research data in an easy to read format
• Reverse-engineered a highly complex multiple worksheet model to pull rules to be built into the application
• Used SharePoint to store, organize, collaborate and access information
• Developed wireframes and screen mockups using iRise
• Used Business Process Model and Notation to represent the As-Is and To-Be processes
• Analyzed EDI transactions for supply chain and logistics: 856, 864, 210, 214, 215, 240, 997

ENVIRONMENT: Waterfall Scrum Hybrid SDLC, JIRA/ Greenhopper, SQL Server 2012, MySQL, ASP.net, XML, Web Services, SOA, SOAP UI, HTML 5, SSRS, SSIS, SSA, IIS7, MS Excel, MS Word, MS Visio, MS SharePoint2013, Team Foundation Server 2013, Rally, HP ALM, Slack, Google Docs, GoToMeeting