SUMMARY:

• Seasoned PM/Architect with over 10+ years’ experience in implementing large systems scale systems and Big Data Analytics Solutions.
• Highly regarded as an analytical problem solver and solutions provider with strong organizational and supervisory skills.
• A practiced mentor and advisor; able to establish rapport and trust with diverse groups of people at all levels.
• Proven technical leadership skills include the ability to manage teams, led by example, and thrive in an entrepreneurial environment.
• Hands on SW development experience in both open source and Microsoft stacks.
• Engagements within many large - scale environments as a consultant including Microsoft, Expedia, Boeing.
• Excellent hands on SW dev experience in Scala and Java.

TECHNICAL SKILLS:

Technologies:: Business Intelligence, Data Warehousing, Master Data Management, ETL, Data Migration, Hadoop, Spark.

Development Tools/platforms: SQL Server 2012, SQL Server 2012 R2, SSAS, SSRS, SSIS, SQL Server, IntelliJ, Eclipse, Git, Visual Studio, Hadoop, Cosmos, Power BI, HDInsight, Data Lake.

Languages: SQL, SCOPE, C#.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond WA

Sr. Technical Program Manager/Data Analyst

Responsibilities:

• Worked with analysts and managers to define metrics and report specifications.
• Explored COSMOS datasets and created custom pipelines for POC reports.
• Automated Cosmos workflows in Sangam for automatically creating scheduled streams.
• Wrote custom queries to validate data and trace root cause of discrepancies.
• Worked with managers and stakeholders to prior to making changes to existing data pipelines and reports.
• Prioritized and feature set based on business needs and technical constraints.
• Wrote DAX subroutines to calculate metrics, created visualizations in PowerBI.
• Wrote SQL/Scope queries to validate data.
• Wrote stored procedures to audit and create Data Quality metrics
• Wrote excel macro’s and subroutines (v-lookup) for data analysis.
• Manage product and sprint backlog, conducted daily scrum.
• Define Enterprise Data model for data scattered in different systems, SAP, MSSales, OLS, and Office 365 Usage.
• Create Dimensional data model for Glass and staging DB’s.
• Defined Metrics and Glass dashboard.
• Wrote the High Level Design document for the Audit platform of the FDP project.
• Create source to Target mapping for new measures and KPI’s.
• Manage offshore team coordination and delivery.
• Created detailed functional specifications document for Meta Data based ETL scripts.

Environment: Linux, Oracle, SCOPE, Java, Map-Reduce, WSDL, SQL, JSON, .Net 4.5, C++, C#, XML, Visio, MS Project, MSOffice, PowerBI, Excel Pivot, Sangam, Elastic Search, Kibana, Azure, HDInsight, Excel, Scala

Sr. Technical Program Manager(BI)

Responsibilities:

• Drive the implementation and release management of LPS Analytics system.
• Wrote custom queries for Adhoc reports and investigations.
• Created custom visualizations in Tableau.
• Conduct daily scrums for multiple teams. Manage product and sprint backlogs.
• Coordinate release of new versions of software.
• Analyze existing BI System Architecture and business processes and create gap analysis document.
• Write functional specification for ETL reprocessing engine.
• Negotiate interfaces and SLA with upstream OLTP systems.
• Design and implement ETL monitoring tools.
• Coordination and resolution of daily operations issues raised by various delivery teams.
• Coordinate rollout of new SW builds and releases.
• Rollout of Qlikview operations infrastructure.
• Drive and implement DB2 hygiene and health maintenance processes.

Environment: T-SQL, Oracle, SQLServer 2008, Hadoop, Hive, Tableau, Java, Scala, WSDL, SML, SOAP, AWS, Confluence, SharePoint, JIRA, Exadata, Scala.

Sr. Technical Program Manager

Roles and Responsibilities:

• Performed Trend Analysis of MSP errors from the event log Data Warehouse.
• Create HLSD for Calendar and parallel HAALEX.
• Drive the implementation of parallel HAALEX that improved response time by 300%.
• Implemented the Calendar feature in Windows Mobile client.
• Document changes to MSP protocol and architecture.
• Oversee migration from DS (Delta Sync) 2.0 to 3.0.
• Perform requirements analysis and write Functional Specification Document for the MSP Hotmail calendar feature.
• Conduct the daily scrum meeting and weekly JAD sessions.

Environment: T-SQL, SQLServer 2008, SSIS, SSAS, SSRS, Oracle, Scala, COSMOS, Map-Reduce, WSDL, SQL, JSON, C#, XML, Visio, MS Project, MSOffice, MS SharePoint, Azure, Excel.

Sr. Technical PM

Responsibilities:

• Analyze existing System Architecture and business to road map and create gap analysis document.
• Create source to Target mapping for new measures and KPI’s.
• Created detailed functional specifications document for ETL development.
• Write SQL queries to audit data in staging DB.
• Negotiated interfaces and SLA’s for ETL jobs.
• Worked closely with the lead architects and analysts to develop high level architecture, system design, system requirements, helped in project phasing and provides assessments with LOE estimates.
• Lead cross system design functional reviews and JAD sessions.
• Coordinate release of new releases with upstream systems and stake holders.

Environment: T-SQL, SQLServer 2008, SSIS, SSAS, SSRS, Oracle, SCOPE, COSMOS, Map-Reduce, WSDL, SQL, JSON, C#, XML, Visio, MS Project, MSOffice, MS SharePoint, Azure, Excel.

Sr. Product Manager

Responsibilities:

• Drive the implementation of key features of Vanguard (Next Generation TOS).
• Investigate and prototype reporting and BI solution architecture for Vanguard.
• Created project plan and schedule. Performed feasibility analysis, risk analysis and gap analysis for current and new processes.
• Assured that all artifacts are in compliance with corporate SDLC Policies and guidelines.
• Analyzed and updated use case scenarios and documents (BRD).
• Translated business requirements into detailed functional specifications documents (FSD).
• Created and managed product and sprint backlog.
• Lead cross system design functional reviews and JAD sessions.
• Managed product and sprint backlog.
• Communicated on a regular basis with development team to track & identify potential escalation of risks and communicate those, changes to business clients in order to modify requirements as needed. Managed & tracked changes to requirements.

Environment: Java, PL/SQL, FLEX, Linux, Oracle 11g, OBIEE 10g, SQLServer 2005/2008, SAP OTC, SOAP, WSDL, XML, Visio, MS Project, MSOffice, MS SharePoint, VersionOne.

Sr. Systems Engineer

Responsibilities:

• Prepared business case to support project initiative decision thru cost/benefit analysis and customized business modeling.
• Created Statements of Work (SOW) and Request for Proposals (RFP) documents and revised as needed to meet changing needs and requirements.
• Provided all team visibility and maintained tractability among requirements, use cases and change requests.
• Liaised with Customers, Developers, and Test team to resolve bugs.
• Created, managed the change request process and analyzed the impact of the change request on the application with regards to Project Plan, Project Scope and Project Schedule.
• Worked closely with QA to ensure all requirements have corresponding test cases and to ensure requirements traceability throughout software development life-cycle.
• Preformed User Acceptance testing and used SQL extensively to create queries to verify, validate data tables and data integrity.

Environment: SQL, SOAP, WSDL, XML, XMLSchema, Eclipse, Spring, CSS, MVC, Oracle, Apache Tomcat, RenderX, Eclipse, Java, J2EE

Sr. Technical Program Manager

Responsibilities:

• Conduct the daily scrum meeting and weekly JAD sessions.
• Manage product and sprint back log, conducted daily scrum.
• Managed and configured team Share Point site.
• Drive the migration effort for Office 10 and Office 12 products over to GCH from legacy system.
• Coordinate development and testing activities with offshore team.
• Triage live site issues and drive their resolution.
• Participated in UAT activities.
• Organized Cross functional meetings/activities to assess upstream & downstream impacts (Impact Analysis) and resolve issues.
• Created, managed the change request process and analyzed the impact of the change request on the application with regards to Project Plan, Project Scope and Project Schedule.

Software Environment/Platforms: T-SQL, SQLServer 2000/2005, SOAP, WSDL, IIS 6.0, XML, XMLSchema, Visual Studio .Net 2.0, C#, VSS. MS Access, SQL Analysis 2000/2005, SQL Server 2000/2005, SSIS 2000/2005, SSRS 2005, OLAP, XML, XSD, XPath, XSLT, MS Project, Visio, WM 6.1. SOA, SOAP, TFS, MS SharePoint.

Software Engineer

• Drive the EAI project for Confidential ERP systems and the POS controller.
• Drive the data migration effort from Mainframe to Confidential ERP system.
• Worked closely with the lead architects and analysts to develop high level architecture, system design, system requirements, helped in project phasing and provides assessments with LOE estimates
• Prepared functional specifications, including proposed system architecture for internal BTP projects.
• Wrote high level and detailed level design documents for the project.
• Design and implemented the Java/J2EE WebServices interface for Confidential ERP
• System Integration (EAI).
• Implemented the Confidential E-Collaborator MAPS for XML document (SOAP) based order processing.
• Wrote test plans/scripts (PYTHON) for performance testing and integration testing.
• Wrote ETL Specifications and Optimized MDX queries.

Environment: SQL, SOAP, WSDL, XML, XMLSchema, Eclipse, Oracle, Apache Tomcat, MovexX, Eclipse, Java, J2EE, Spring, MVC.