SUMMARY

• Confidential has more than 17 years of IT experience with 10+ years of experience in Project & Program Management, 8+ years of experience in Data warehouse design and solution implementation.
• Have been working as Technical Project Manager / Engagement manager at State of New Jersey since June 2013 until present date.
• 10+ years of experience of working with C - Suite executive management teams for various clients.
• Currently working on 2 of the top 5 projects for Chief Technology Officer, State of New Jersey.
• Successfully executed a data warehouse enhancement project for Director, New Jersey Office of Management and Budget.
• Managed the full life cycle implementation of ServiceNow Discovery and Software Asset Managementat State of New Jersey.
• Experience of servicing as Single point of Contact (SPOC) between the client and multiple software vendors for seamless project execution and ensuring the client requirements are well defined and delivered.
• Extensive experience in software size estimation, cost and resource estimation, RFP - proposal writing, BRD’s, SRS’s, Project WBS, Project charter, scope statements, resource requirements and allocations, Technical assessments, and preparation of statement of work and project management skills, technical presentation, client liaison.
• Strong exposure to functional matrix with experience of working with cross-functional / technical teams and subject matter experts (SME’s).
• Strong experience in execution of IaaS and PaaS projects to setup database, infrastructure & private cloud involving coordination with multiple vendors, internal and external technical teams.
• Implemented and Lead projects at all stages of Software Development Life Cycle (SDLC) and Agile Methodology, experience of working in Offshore, Onshore and Onsite mode.
• Excellent Interpersonal Skills with the ability to work independently and within a team.
• Lead, engage, develop, and invest in talent to create a highly motivated, expert, and diverse workforce.

AREAS OF EXPERTISE

• Project Portfolio Management
• Project Prioritization
• Process Improvement
• Stakeholder Management
• Change Management, Resource Planning & Estimation
• Project Implementation
• Management Reporting
• Team management (onshore - onsite / Offshore model)

PROFESSIONAL EXPERIENCE

Confidential, Trenton NJ

Technical Project/Program Manager/Scrum Master

Responsibilities:

• Responsible for execution of Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) projects to setup database, infrastructure & private cloud involving coordination with multiple vendors, internal and external technical team’s projects to accomplish the State’s primary mission of a single centralized infrastructure / Platform strategy for State of New Jersey (SoNJ).
• Plan, initiate, and manage information technology (IT) programs / projects at Confidential including evaluation of business implications for each Software Development Life Cycle (SDLC) phases.
• Lead and guide the SoNJ staff at external agencies, Confidential and multiple vendors for organizing multiple workshops across executive branch agencies to complete comprehensive requirements gathering.
• Serve as liaison between Confidential senior leadership team and multiple cloud computing vendor teams in evaluating different Software as a Service (SaaS) solutions for in-depth feature based analysis & shortlisting COTS products satisfying SoNJ's IT needs.
• Coordinate with multiple SoNJ internal and external vendor(s) procurement teams to seamlessly on-board the software providers on the SoNJ contracts.
• Staying current on solution requirements, documentation and latest software releases to support the Proof of Concept (PoC) implementations for Confidential .
• Document and present PoC evaluation reports to Confidential management for shortlisting of a solution for implementation.
• Represent Confidential at multiple vendor forums to review and comprehend their product features and abilities.
• Revise estimates for scope, cost, resource, and schedule and ensure new budget estimates are approved by the client and agreed upon.
• Provide mentoring and training to peers and orientation to new team members joining the Confidential Project Management Office (PMO) team to enhance and create a robust local talent pool.
• Provide program / project status reports on a periodic basis for project team, team leads, group leads, and project sponsors, executive sponsors and Confidential stakeholders.
• Accountable to schedule and monitor status reviews, peer reviews, project management inspections, and software quality assurance work product and process reviews with the appropriate designated resources.
• Notify team leads on project timelines, milestones, phases, work requests target dates, and approved executable work package.

Confidential, Trenton NJ

Engagement Manager

Responsibilities:

• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures
• Project-managed multiple large-scale initiatives involving the transition of programs to new platforms and the merger of disparate systems from acquired client companies
• Design project plans, which identify needs and define major tasks and milestones, based on scope, resources, budget, and personnel.
• Prepares project status reports on a periodic basis for project team, team leads, group leads, and project sponsors and appropriate stakeholders.
• Accountable for the final project management evaluation review with stakeholders for approval upon project completion. Responsible to tailor and baseline all project templates.
• Accountable to schedule or monitor status reviews, peer reviews, project management inspections, and software quality assurance work product and process reviews with the appropriate designated resources.
• Notify team leads of project timelines, milestones, phases, work requests target dates, and approved executable work package.
• Manage, coordinate, and establish priorities for complete life-cycle of projects including the planning, design, programming, testing, and implementation of business solutions designed to meet requirements of various departments in the organization.
• Provide mentoring and training to peers and new team members joining the team.

Confidential, Hoboken, NJ

Onsite ETL Lead

Responsibilities:

• Worked on all phases of this implementation, from gathering requirements to testing, implementation, and support.
• Experience in preparation of the High Level Design (HLD) and Low Level Design (LLD) documents for ETL implementation.
• Developed several jobs to load Slowly Changing Dimensions, Fact and Summary Tables.
• Designed and developed complex mappings that involved Slowly Changing Dimensions, Error handling, Business logic implementation
• Performed Informatica Folder/Object Level Migration using Repository Manager.
• Performed Code review of mappings of various applications.

Confidential, Stamford, CT

Onsite production support lead

Responsibilities:

• Interaction with Business Analysts, resolve existing problems and improve the application stability.
• Answering the technical queries, driving the product initiatives and metric collection and analysis.
• Reviewing of work products and deploying the application in the test environment and initiate the process of user acceptance testing. It includes fixing of bugs and fixing technical errors that may come up during this phase.
• Regular interaction with the Client, Database administrators, Network Administrators, Application Users - all belonging to different departments and divisions of GE to ensure the smooth running of the applications.

Confidential, San Jose, CA

ETL Lead Onsite / Offshore

Responsibilities:

• Worked extensively with business analysts, data analysts and business partners for understanding the business rules
• Converted Functional specifications to Technical specs
• Developed the ETL logic to load data from various heterogeneous systems such as Oracle, Teradata, Flat files
• Writing Stored Procedures, SQL scripts and calling them at pre and post session.
• Implemented database performance tuning techniques for improving the performance of the application
• Extensively used Teradata utilities FastLoad, Multiload to load from Teradata database to Oracle
• Involved in production support on a rotational weekly basis

Confidential, Research Triangle Park, NC

Sr. ETL Developer

Responsibilities:

• Documented business requirements and functional requirements and automated Extract Translate Load (ETL) process for enterprise data warehouse (EDW).
• Prepared the technical specification documents for all the interfaces pertaining to Master, Transactional and Reference data and then delegate it to the development team.
• Database Admin activities like Creation and Modification of views on Databases.
• Automated incremental loads into the Teradata Enterprise Data Warehouse by
• Performed code reviews and Unit & System Integration Test in DEV and QA.

Confidential 

ETL Developer

Responsibilities:

• Participated in meetings with Business team and analyst to gather the requirements and finalize the Erwin Logical and Physical Models. Understanding the functionality of the system & understanding business rules.
• Involving in testing of entire view models which were designed as part of Business views.
• Design and Development of Business Views, Loading of Test Data for QA testing and Application Testing.

Confidential

ETL Developer

Responsibilities:

• Production Server Maintenance
• Migration of the application across QA, UAT & Production environments.
• Extraction Routines, Loading Routines and Backup Routines.
• Analysis Services Cube Design and Development
• MDX Scripting and Development.