SUMMARY:

• 12 years of experience in IT industry as Project Manager, Business Analyst and Business strategy consultant
• Excellent analytical, problem solving, storytelling and business presentation skills
• Led cross functional teams and delivered demanding business requirements, on time and with highest quality
• Designed market expansion and market entry strategy for clients; resulting in revenue increase by ~13% within 2 months
• Supervised 7 multi - million-dollar value projects in last 6 years (from conception to completion)
• Implemented processes of IT Service Management (ITSM) across projects and organizations
• Extensive experience with modern project management techniques and support systems including MS Project and Confidential Project and Portfolio Management system.
• Strong knowledge and understanding of SDLC methodologies including Agile SCRUM

KNOWLEDGE SET:

Management Skills: Project initiation & planning, Budgeting & controlling, Effort estimation, Project execution & closing, Reporting, Agile, Scrum, Strategy planning, Leadership, Negotiation, Risk Management, Communication

Software Knowledge: Oracle, Microsoft Access, ALM Quality Center, JIRA, Confluence, Unix, Linux, MS Office, SQL Server, Hadoop, Rational ClearCase, SVN, @Risk, MS Project, Tableau, QTP, WebMethods 6.5, Visio, SSIS, SSAS, SSRS, Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Project Manager/Program Manager

Responsibilities:

• Managed multiple ecommerce projects running across different geographies
• Drove requirement gathering, project planning, estimations, execution, report preparation and delivery to stake holders
• Designed and implemented process changes from mid to senior managers to ensure on-time delivery
• Facilitated iteration planning, led work within individual sprints, and coordinated retrospectives and demos
• Developed strategies to help them double their annual transactions and revenues from this product
• Prepared and published various monthly and quarterly governance reports to Senior Directors of the company
• Analysed shopping pattern data of customers to reveal new CRM growth opportunities to enhance consumer spending.
• Implemented push notifications, online surveys and customer segmentation modelling; share best practices with global teams.
• Developed a suite of win back, retention and renewal campaigns that extended lifecycles and increased customer response 35%.
• Executed CRM campaigns to cross-sell and up-sell new and existing products to current user base.
• Devised email and push notification program to inactive users that lifted engagement rates by 18%.
• Restructured existing confluence pages and included various other required process oriented frameworks at project level, resulting in higher efficiency of the team
• Created detailed project plans using Confidential PPM or Microsoft Project based on estimation and resource input from IT leads.
• Analysing and reporting upon JIRA usage and activity.
• Generated various Monthly, Quarterly, Bi-Yearly and Yearly reports using SSRS (SQL Server reports)
• Led and managed functional organizational project team
• Ensure cross functional coordination (analysts, developers, and testers) is occurring early and often
• Created detailed project work breakdown structure (WBS) to organize and define project work scope, identified project tasks, dependencies, resource requirements, costs, critical path activity, risks and risk mitigation strategies.
• Used extensively Microsoft Project (MS Project) for preparing and scheduling master project plan
• Used MS Visio for planning processes and workflows across verticals for the group
• Prepare and track all the baselines (namely schedule, cost and scope) across the lifecycle of the project
• Coordination with Multi-functional teams to understand and define business logic
• Relate policies and complex process into product capability to support the portfolio vision and roadmap
• Prepare and present governance reports to executive managers (CCO, VP’s, SVP’s etc.)
• Update project plan, presentations and other project related documentation

Confidential, San Jose, CA

Project Manager

Responsibilities:

• Assist in developing and implementing a Scrum Agile Framework.
• Own, prioritize, and maintain the Product Backlog, including definition of epics, user stories, and acceptance criteria.
• Prioritize requirements/Product Backlog based on Delivery schedule, SPRINT summary.
• Help in developing roles and responsibilities appropriate for specific programs that accommodates Agile framework.
• Facilitate iteration planning, lead work within individual sprints, and coordinate retrospectives and demos.
• Assist key business users (product owners) with backlog creation and grooming.
• Ensure cross functional coordination (analysts, developers, and testers) is occurring early and often.
• Maintain and publish agile metrics (e.g. velocity and burn-down).
• Coach Product Owners and Developers with regards to the application of Agile practices and worked as Scrum Masters.
• Project Planning and Execution using Agile Methodology.
• Working on Pre-sales requirements and executing them in short time span.
• Engaged new employees and co-workers in improvement by empowering them to discuss and implement changes leading to high morale and continuous process improvement.
• Successfully bagged, supervised and delivered the product to 3 clients for newly developed in-house product - iAcuity, with deal valued USD 4M, USD 3.5M and USD 3.3M.
• On boarded, mentored, and trained IT project managers on Confidential PPM and project management processes.
• Employed ITSM processes to implement a customer first attitude in the IT services team.
• Increased customer satisfaction resulting in higher quality and faster business processes.
• Designed and implemented a set of standards, policies, and procedures to more efficiently manage workflow and reporting.
• Increased gross profit of the department by 400% in first year as service manager.
• Integrated Project Management responsibilities with SharePoint and Excel.
• Established user administration procedures and procedures for customer relations to manage users for client facing SharePoint sites.
• Training internal department members on administration of SharePoint, governance and best practices.
• Entry level design and customization of SharePoint Lists, Content Types, Workflows, Views, Sites, etc.
• Wrote queries, procedures and functions to extract required data in SQL and Oracle
• Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration
• Loaded flat and Excel files into Access database and developed SQL scripts to create desired queries (views) for data analysis
• Generated variety of business reports from SQL server using excel with pivot table and pivot chart.
• Used Unix/Linux Commands & Shell Scripting to verify data, logs and errors.
• Good Exposure in Unix/Linux Commands & Shell Scripting.
• Created detailed project work breakdown structure (WBS) to organize and define project work scope, identified project tasks, dependencies, resource requirements, costs, critical path activity, risks and risk mitigation strategies.
• Reviews all Enterprise Management processes and procedures for accuracy and completeness. Assists with bringing outdated operating procedures up to date.
• Exceptional experience in scheduling project with help of Microsoft Project (MS Project).
• Prepare and follow Project Plans to track all tasks and deliverables and publish status reports, executive briefings, meeting minutes and other collaboration tools to effectively communicate project activity.
• Effort estimations and Budget Projections.
• Coordination with Multi-functional teams to understand and define business logic.
• Hiring and mentoring of new team members.
• Product presentations to prospective customers.
• Process implementation across the projects.
• Supervision of 2 projects throughout SDLC (Conception to completion).
• Relate policies and complex process into product capability to support the portfolio vision and roadmap.
• Manage dependencies with other programs within portfolio and with other portfolios.
• Follow up with leaders on scheduled changes to ensure the project remains on track.
• Update project plan, presentations and other project related documentation.
• Extensively used various Microsoft suite products such as Visio, Word, Excel, Access, PowerPoint and Microsoft Project

Confidential, Alpharetta, GA

Project Manager

Responsibilities:

• Developed the project management plan documenting the actions necessary to define, prepare, integrate and coordinate all subsidiary plans.
• Identified project stakeholders, analysed their interest, influence and impact on the project, and accordingly developed a communication strategy.
• Prepared and published the Project Charter after interacting with business stakeholders during the initiation, design, execution and release phases of the business projects, understanding product roadmap, monitoring customer expectations, project performance, and key deliverables.
• Defined project milestones, resource allocation, dependencies in ALM tools for the stakeholders.
• Tracked project/program progress, identified and escalated issues, identified resources to provide solutions to ensure that program tasks are completed according to established timelines.
• Analysing and reporting upon JIRA usage and activity.
• Built templates and dashboards for customized views of the data specific to each group and line of business.
• Conducted walkthroughs at various stages of development with stakeholders.
• Developed project schedule by analysing project activity sequences, durations, requirements and constraints.
• Facilitated release management activities for deployments.
• Provided consulting to managers across the account to implement process improvements in task creation, order waving, and workload balancing
• Prepare and deliver PMO communications, including those related to project management process changes, template modifications, and Confidential PPM enhancements, upgrades, and outages.
• Designed and implemented ad hoc reports using existing report models in SSRS
• Extracted data from internal data warehouse system to SSRS
• Wrote database scripts & PL/SQL stored procedures, functions and triggers
• Wrote queries, procedures and functions to extract required data in SQL and Oracle
• Risk Evaluation and Risk Management.
• Develop, maintain and track detailed work plans, including WBS, milestones, risk assessment, staffing needs and project timelines.
• Developed and implemented repeatable processes and fostered an environment for continuous improvement.
• Implement process improving parameters by performing root cause analysis etc. after every release.
• Review and provide ongoing feedback on the quality and accuracy of the work for entire team.
• Implemented various processes of IT Service Management (ITSM) to improve process and project deliverable qualities
• Increased revenue (15%) and decreased costs (20%) by improving business processes and implementing project management best practices
• Lead and manage a cross functional team of 7 on a pilot project and acquire the 3-year contract valuing USD 3M.
• Drive requirement gathering, project planning, estimations, execution, report preparation and delivery to stake holders.
• Implement solutions that can shorten the delivery cycle considerably.
• Successfully built empowered teams by building strong communication channels and implementing engineering practices like Test Driven Development, Pair Programming, Test Automation and Continuous Integration.
• Built metrics like ‘Burn-up charts’, ‘Burn-down charts’, ‘Iteration Velocity charts’ and utilized them to tune or adapt development of product backlog to meet Release plan.
• Encouraged customer collaboration that brought significant value to the product quality during iteration demos and review meetings.
• Managed changes, cross application dependencies, deadlines, resource sharing, application releases & implementations.

Confidential, Providence, RI

Senior Business Analyst and Onshore/Offshore coordinator

Responsibilities:

• Interact with various stake holders to gather requirements & manage documentation.
• Documented, understood, prioritized and validated requirements using use cases, user stories and wireframes.
• Analysed interfaces to expose interoperability early in the project.
• Performed gap analysis to derive requirements for existing system requirements using process models.
• Communicated Product Scope and Project Status to stakeholders.
• Create Project Management Plan; Utilized Waterfall project management strategies to provide required structure.
• Risk Evaluation and Risk Management.
• Change Request handling, Delegation, End-User Interaction.
• Participated in resource allocation.
• Manage, lead and direct multi-disciplined onshore and offshore project team of 5 members.
• Improve quality, cut lead time and cut overall costs.
• Create various testing metrics to keep track of the status of the project.
• Experienced in testing the application on UNIX/Linux Environment.
• Implemented SSRS Business Intelligence Life cycle such as Configuration of Report server, Deployment of reports, creating report subscription (Data Driven) in Development, Test and Production environments
• Created data queries and reports using SQLServer, SSRS, and Excel.
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization
• Analyzed data models, data relationships, and dependencies for greatest optimization
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Created Stored procedures, User defined functions, Views.
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet.
• Extensively used joints and sub-queries for complex queries which involved multiple tables from different databases.
• Designed and implemented ad hoc reports using existing report models in SSRS
• Expertise in extraction, transformation and loading (ETL) of data flows using SSIS withcomplex integration of SQL Server tables, oracle, flat files, excel files, comma separated files (.CSV), MS access files, MySQL 5.0 and DB2 tables
• Expertise in creating Indexes and appropriate triggers to facilitate efficient data manipulation to maintain data consistency

Confidential, Lowell, MA

Systems Analyst and Onshore/Offshore coordinator

Responsibilities:

• Create Project Management Plan, manage Project Schedule and Budget; implemented Waterfall methodology.
• Responsible for Turnaround / Recovery project exercise.
• Responsible for High Level Design discussion.
• Coordination with Multi-functional teams to understand and define business logic.
• Risk Evaluation and Risk Management.
• Change Request handling, Delegation, End-User Interaction.
• Assist the team in the development of test plans for new applications and oversee unit testing and system testing to ensure the delivery of functional, low-error systems and solve critical business problems
• Identifying critical Design issues during the design review process at the early stages of the project, effectively saving a lot of effort and potential customer impact.
• Created Store procedures, User defined functions, Views, T-SQL scripting for complex business logic.
• Generated various Monthly, Quarterly, Bi-Yearly and Yearly reports using SSRS
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Created and managed SSAS Tabular models; created Dimension and Fact Tables.
• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Proactively identified, managed, and corrected data quality issues with reports provided to CR managers
• Designed ETL flows to extract data from various sources and stored in DB
• Create QA Test Strategy, Test Plan along with High Level Test Scenarios and Requirements Traceability Metrics.
• Conduct Test Case reviews with development and business teams.
• Test Result and Defect Reporting.
• Arrange Defect Status Calls with Development, Design and Business Leads to follow up on QA / UAT Defects.

Confidential

Systems Analyst and Onshore/Offshore coordinator

Responsibilities:

• Responsible for requirement gathering and analysis for service delivery projects (complete flow of different types of Customer Orders). Utilized Waterfall methodology to provide required structure.
• Responsible for test case planning and design, test case reviews and upgrades.
• Involved in UAT on behalf of client; Defect logging and tracking.
• Prepared daily status report and hosted triage calls to discuss the status of project progress with stakeholders.
• Responsible for installations of new releases and troubleshooting in Windows and UNIX/Linux environment along with the usage of SQL/PLSQL.
• Worked extensively on UNIX/Linux env. to ensure successful release deliveries in client env.