SUMMARY

• Technical Project Manager with 14+ years of experience taking progressive responsibilities in a blend of business and technical roles of project manager and developer using Microsoft technologies.
• 6 years of Project Management experience with PMP and Certified Scrum Master.
• Expertise in Agile Scrum and Waterfall methodologies of SDLC
• Ability to work independently in highly ambiguous environments
• Defining and prioritizing customer journeys (epics) and scenarios (user stories) that focus on optimizing end customer experiences
• Expertise in writing technical and functional specification
• Demonstrated success building strong relationships and delivering results in cross - functional teams.
• Demonstrated ability to influence without authority
• Successfully delivered multiple medium and large scale projects
• Experience in project planning, defining project definition, preparing process flow diagrams, communication plan, configuration management, stakeholder management, identifying, analyzing risks and defining mitigation plan
• 8 years of experience as data warehouse/BI developer.
• Experience in SQL Azure, Hadoop/Big Data, Sqoop processing.
• Expertise in SQL Server, SSIS, SSAS, SSRS, ETL, Data mining model, Cognos, performance tuning, query optimization, C#, ASP.NET, Metadata Modeling, relational database design, data modeling, pivot tables and ER model.
• Expertise in Excel data Analysis, Visualize data and statistical reporting.
• Experience in Visual Studio Online, TFS , Rally, O365.
• Knowledge in Power BI (Power Pivot, Power View, Power Query).

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Technical Project Manager

Responsibilities:

• Delivering multiple projects in DEVOPS model.
• Prepare project plan and communication plan.
• Prepare Project metrics and tracking projects.
• Prepare Release tracker on effectively manage release schedules.
• Experience in Escalation management.
• Document root cause analysis and track down issues.
• Plan for resources for migration of Server to handle critical issues.
• Develop and review Bi-weekly/ Quarterly Business Reports with leadership and business users.
• Identify Risks and plan to mitigate risks.
• Conduct Sprint planning, daily scrums and retrospective meetings.
• Co-ordinate with Architects, Analysts, Developers, DBA and Source teams.
• Fix technical issues of SSAS and SSRS.
• Collaborate with cross functional teams.

Confidential, Bellevue, WA

Technical Project Manager

Responsibilities:

• activities surrounding the creation and changing of Offers within Digital Supply Chain Information and Services to support the launch of Office 15, XBOX, and OneDrive .
• Offer Management which is really a series of written (text) requirements needed to permit the sale of Microsoft products to customers within global marketplace.
• Provides ESD, POSA, POSAR data to other groups. An Offer can be defined as a “sellable product”, and may have multiple channels of sales, with variables such as: Countries, Multiple languages , Currencies, Price structures and Payment Methods as points, Cash (cards) and PayPal,
• Interaction with business and gather requirements.
• Analyze the requirements and create user stories.
• Impact analysis on the creation of Offers and Tokens.
• Identify the dependency of the data to other teams like CIS, POSA.
• Involved in Backlog grooming, Sprint planning and facilitating scrum and retrospective meetings.
• Generate reports on modes of payments across different geo locations and reviewed with business.
• Prepared data migration plan from Sql Server to SQL Azure.
• Prepare schedule for sprint.
• Prepared process flow document.

Confidential

BI Project Manager

Responsibilities:

• Analyzing the requirements and writing functional specification document.
• Prepare the estimation plan for the allocation of the resources.
• Prepare project plan.
• Prepare the Database design document.
• Document Data mapping and Stored Procedures scripts.
• Conduct scrum meetings.
• Prepared communication plan and process flow document.
• Scheduled meetings with business.
• Triage bugs.
• Generated the SSRS Reports.
• Created the screens in Visio.
• Review the Customer requirement document.
• Involved in preparing the WBS.
• Configuration management.
• Performs Integration Testing.
• Worked on change requests.
• Collect daily status and prepare weekly status report.

Confidential

Technical Project Manager

Responsibilities:

• Participate in customer requirement meetings.
• Capturing requirements, analyzing the requirements and writing functional specification document.
• Prepare the estimation plan for the allocation of the resources.
• Responsible for aggregating data from multiple data sources using ETL (SSIS) solutions.
• Prepare the Database design document.
• Create views, tables and setup database using SSMS.
• Developed the SSRS Reports based on the requirement.
• Created the screens in Visio.
• Integrated multiple applications through web services.
• Review the Customer requirement document.
• Involved in preparing the WBS.
• Triage bugs.
• Configuration management.
• Managing offshore team and have sync-up calls.
• Scheduled weekly status meetings and prepares weekly status Report.
• Performs Integration Testing.
• Worked on the Change Requests.

Confidential

Technical Project Manager

Environment: Framework Model, Cognos/SSRS Reports, Sharepoint, Wiki Site, Sql Server, BI, SSIS, SSAS, Clear Quest

Responsibilities:

• Gathered requirements from various users and documented the Requirements.
• Prepared the multi-tier Process Flow document of the project.
• Involved in documenting Data mapping sheet for the entire database.
• Designed Logical and Physical model in ER Studio.
• Designed a data model in Star schema and created Dimensions and hierarchies
• Involved in the Data Modeling meetings and validated the Model.
• Verified and validated the DDL model.
• Developed Metadata Model in Framework Manager and generated multiple packages.
• Extracted data from multiple sources and loaded data into data warehouse using SSIS.
• Resolved the issues during the ETL process.
• Provided multidimensional and aggregated data using SSAS.
• Developed complex reports and adhoc reports using Cognos Report Studio and SSRS.
• Developed graphical reports and dashboard include pie charts and graphs.
• Developed an integrated portal page for multiple databases.
• Created a Wiki Page for the Sales and Marketing Data warehouse.
• Scheduled meetings with User and presented the Reports.
• User Trainings on Adhoc Reporting.
• Prepared Weekly Status Reports.
• Documented the Change Requests and updated in Clear Quest.
• Documented the release plan and move sheets for the releases.
• Presentation of the Reports to the User group.
• Worked on the Sharepoint documents and archived older documents.
• Prepared the Report/Portal/Wiki Usage documents for Users.

Confidential

Project Leader/BI Developer

Environment: Framework Model, Cognos/SSRS Reports, Sharepoint, Wiki Site, Sql Server, BI, SSIS, SSAS, Clear Quest

Responsibilities:

• Generated project metrics on monthly basis.
• Created tasks and assigned tasks to team members.
• Participated in the project Audits.
• Involved in the Quarterly PMR’s and the generation of UPP.
• Drive weekly status meetings with the team.
• Created Business Logic layer and Data Access layer classes and methods in C#.Net.
• Involved in Analysis and design of Database.
• Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation.
• Involved in writing SQL Scripts, Joins, and User Defined Functions using Confidential -SQL of Query Analyzer.
• Developed Front end application for end users.
• Implemented Stored Procedures for Data Retrieval and Updating.
• Developed and unit tested SSRS reports.
• Work with end-users to understand reporting requirements and translate and develop and test reports.
• Implemented Unit Test Cases for each module.
• Worked on optimizations and enhancements of the existing setup.
• Supported the applications of Siebel, Portal and DWH.
• Created jobs for the SSIS Packages and monitor and fix the issues using BIDS.