SUMMARY

• A highly talented IT professional with over 13 years of Project Management and Development experience in finance, insurance, banking, digital advertising, and manufacturing industry. As a boost to my extensive experience.
• Strong proficiency in Integration, Scope, Time, Cost, Quality, Communication, Risk and Stakeholder Project Management Knowledge Areas.
• Highly experienced in managing all aspects of projects throughout the project lifecycle including initiation, planning, execution, controlling, and closure for large and complex information technology projects.
• Expert skills and knowledge in Vendor, Contract, Invoice, Risk management.
• Strong background in business process analysis, business process modeling, business requirements, database design, strategic planning, and business.
• Experienced in financial reporting tools and financial planning & analysis processes (FP&A - Forecasting/Budgeting and alignment with Actuals)
• Experience working in a Waterfall and Agile development environment using SCRUM in SAFe framework with using JIRA.
• Demonstrated knowledge of implementing scrum framework as a Scrum Master by leading scrum events, emphasizing three pillars of scrum and scrum values, and removing impediments and obstacles for the development team.
• Demonstrated knowledge of creation and managing of project proposals, SOW (statement of work), job description, business cases, work orders, cost-benefit analysis, project charters, WBS, and project plans
• Strong Expertise in managing on-site and off-shore teams’ coordination.
• Strong Knowledge and Hands-on Experience in Snowflake SQL Data Warehouse.
• Expert skills and knowledge across a broad range of Web tools and technologies including C#, ASP.NET, JavaScript, JQuery, IIS, Visual Studio, SQL, XML, HTML, CSS.
• Strong experience with SQL Server such as creating Databases, Tables, Triggers, Store Procedures, Functions, Jobs, ETL packages, Data marts, and Reports.
• Demonstrated knowledge of SharePoint workflows, InfoPath, Web Parts, SharePoint templates, SharePoint web applications created by Visual Studio and SharePoint Designer.
• Strong oral and written communication, problem solving, decision-making, and analytical skills. Demonstrated ability to effectively communicate at all levels of an organization

TECHNICAL SKILLS

• SDLC (Waterfall
• Agile-SCRUM)
• MS Project
• Cloud Data Migration
• Data Migration
• SAFe
• Kanban
• XP
• JIRA
• PMBOK
• AWS Cognito
• Snowflake SQL Data Warehouse
• Snowpipe Amazon AWS
• Amazon Athena
• Data Lake
• S3
• EC2
• Apache NiFi
• Kafka
• Event Hub
• Airflow SAP BPC
• SAP EPM
• SAP BOBJ
• SAP General Ledger EP1
• SAP BWP
• SAP BP4
• Apptio
• FMIS
• Essbase
• Clarity
• Cognos BI
• Git
• Jenkins
• Selenium
• DevOps
• CI/CD
• Automated Testing
• Context Diagrams (process flow data flow)
• UML Diagrams (Use case
• Activity diagrams)
• JIRA
• BI
• Confluence
• MS SQL Server
• MS SQL Server Integration Services (SSIS)
• SSAS
• MS SQL Reporting Services (SSRS)
• DTS
• SSMS
• Oracle 8i/9i/10g
• IBM DB2
• PL/SQL
• MS-Access
• Erwin
• MS Visio
• Windows Server
• SharePoint Server
• C#.Net
• VB.NET
• ASP.NET
• Java
• C
• C++
• PL/SQL
• HTML
• CSS
• JavaScript
• MS-Office
• Informatica PowerMart
• Bugsnag
• IAM
• Ping Federate
• New Relic
• Appnexus

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Project Manager / Scrum Master

Responsibilities:

• Facilitated all SAFe Scrum Ceremonies, tracked dependencies, removed impediments for the team and made sure stories are groomed properly and prioritized at least for the next two sprints in JIRA.
• Hold accountable for ensuring that all the project deliverables are implemented on time, on budget, and within scope, to meet the expectations of the program/project stakeholders.
• Actively direct and manage the project life cycle from project kickoff through development, testing, and deployment
• Handled Project Financials. Tracked budget and monthly invoices, provided, EAC, monthly forecasts, accruals and re-accruals.
• Created required status reports on the project for the project sponsors, stakeholders, and management
• Identify, assess and mitigate/resolve risks and issues on the project; provide management with early warning; escalate as appropriate.
• Collaborate with project stakeholders, build, develop, and grow any business relationships vital to the success of the project.
• Initiate and plan projects successfully by setting up required meetings, involving the right SME's, allocating resources, developing project release plans and producing the right deliverables during each phase.
• Handled Vendor management, contract, and invoice management.
• Ingested multiple datasets to the Modern Data Platform by registering and ingesting them to Source zone in Data Lake with Nifi, and moved them to Publish Zone either applying the transformation or directly with Auto publisher.
• Performed Snowflake POC: Assessed the viability of the Snowflake Cloud Data Warehouse against four primary Confidential use-cases: Enterprise Reporting (DashDB & Cognos), Ad-Hoc Analysis & Data Engineering (AW -IBM SoftLayer), Above Property Reporting (Tableau), and ETL Migration (Netezza).
• Four target use-cases were executed on Snowflake POC environment with measured results for each evaluation category: performance, capabilities, and cost. Specific recommendations were also provided to determine next steps for Snowflake deployment based on POC results
• After completing the POC successfully, we provisioned Snowflake Dev, Test, Perf and Prod Environments, implemented Ping Federate SAML SSO integration. Created Data Pipeline Architecture using SnowPipe, Copy statements, and Informatica
• Ingested multiple data domains to Snowflake. Designed and Implemented RBAC (Role-Based Access Control) for IT, Community and Team users. Integrate Tableau, Cognos to Snowflake.
• Ingested data to Snowflake via different data ingestion tools (Spark, Informatica DEI, SnowPipe), gathered use case-based data load statistics (Cost and Perf) and provided suggestions when to use which tool.
• Created custom frameworks on Snowflake to handle Monitoring, Exception Handling, Alerting, Metering and Chargeback.
• Created Tableau Dashboards to monitor and understand Snowflake account usage.
• Organized Business User Snowflake Enablement Sessions.
• Created Naming Standards for whole MDP program and worked with the Data Governance team to enforce it.
• Initiated a project for Tableau Server Migration from IBM Softlayer to AWS and performed POC on Linux machines.
• Developed a Test Data Management tool and generated masked data for all domains in Lower Environment.
• Worked closely with Data Lake, Data Ingestion and Registration, Data Science Toolkit, Data Engineering toolkit, Event Hub, Data Transformation and Data Governance workstreams in the program to identify and track dependencies.

Tools: & Technologies: JIRA, Confluence, MS Project, SAFe Scrum, SDLC, Cloud Data Migration, Snowflake SQL Data Warehouse, SnowPipe, IAM, Ping Federate, AWS Cognito, Amazon AWS, Data Lake, S3, EC2, Lambda, SQS, Auto Publisher, Tableau, Spark, Informatica DEI, Snowpipe, ETL, ELT, Cloud Data Warehousing, Apache NiFi, Kafka, Event Hub, Github, Airflow, DevOps, CI/CD, Jenkins, EventHub, Kafka, IBM Cognos, SAML, IBM DB2, DashDB, DB2, Data Integration, Event & Bulk Refinery, Python, Apptio

Confidential, New York, NY

Sr. Project Manager / Scrum Master

Responsibilities:

• Handled overall project coordination including management of resources and tasks.
• Created and maintained, SOW, job description, WBS, work orders, project plans and worked through Executing, Monitoring/Controlling and closing of the project management process groups (Multiple Projects)
• As a Scrum Master, proactively identified and removed blockers, analyzed metrics to identify and implement improvements
• As a Scrum Master, communicated dependencies and potential risks to the completion of the sprints
• As a Scrum Master, facilitated scrum sprint planning sessions, backlog grooming, sprint retrospectives & reviews, and daily stand-ups
• As a Scrum Master, performed capacity planning, maintained sprint backlog, velocity charts, and burndown charts
• Led all project plan development activities, including identification of phases, activities, tasks, deliverables, milestones, dependencies, schedules and assignment of resources.
• Led Application Development call (onshore and offshore teams) on a daily basis to get the status of resources to track down WBS tasks and created biweekly Hydra Reports for senior management
• Worked with the business owners and product managers to determine and document the requirements for technical solutions that meet the strategic needs of the business
• Worked with SMEs to design integrated driver-based forecasting processes and platforms with analytical /reporting tools
• Actively managed the scope of business requirements and keeping the focus on project deliverables
• Coordinated with offshore teams and maintained RACI & RAID & Query logs
• Led the design of companywide Profit & Loss (P&L), Expense/GOE and management summary reports by Line of Business, Function, Cost Center, GL Accounts/COA, Profit Centers, and Entities with Pre and Post allocated views
• Worked with application architects, design leads and developers to develop the conceptual design of the system components, ensuring the high-level design including documenting the architecture requirements mapping to the approved requirements.
• Assisted and directly involved with the QA team in the creation of Testing Strategy, Test Cases, and Test implementations
• Supported the design and development of a ledger-based actual data built on a common financial language (CFL)
• Conducted and led iteration review meetings to showcase the partial build to users and obtained feedback from project stakeholders

Tools: & Technologies: JIRA, MS Project, SDLC, Data Migration, Agile Scrum, Kanban, XP, Waterfall, SAP BPC, SAP EPM, SAP BI / BOBJ, SAP EP1, SAP BWP, IBM DB2, FMIS, Essbase, Oracle, SharePoint, MS-Visio, COGNOS BI, Clarity, Rally, DevOps, CI/CD, Jenkins, Selenium, Continuous Integration, Continuous Delivery, Automated Testing, Service Now

Confidential, New York, NY

Project Manager / Scrum Master

Responsibilities:

• Created project proposals, SOW, project charters, business cases with detailed cost-benefit analysis
• Created the detail Project Charter by collaborating with the senior management of the Controls Room business and technology communities.
• Created and maintained WBS and project plans, and worked through executing, monitoring/controlling and closing of the project management process groups (Application Development/QA team).
• Led the team to work with the Controls Room business owners and product managers to determine and document the requirements for technical solutions that met the strategic needs of the business.
• Worked with Application Development Leads (Qlikview, Dotnet, and ETL) to analyze and develop the conceptual design of system components, ensuring high-level design -- including architecture requirements -- was accurately documented and mapped to the approved requirements.
• Actively managed the scope of business requirements while keeping the focus on project benefits.
• Engaged with Data COEs for physical and logical data model design.
• Provided input into the logical design and development of data models to be used for reporting and dashboard information delivery.
• Led Scrum calls of Application Development (onshore and offshore) teams (Qlikview, Dotnet, ETL) on a daily basis to get resource statuses in order to track down WBS tasks during CUT, SIT, UAT phases.
• Measured project performance by looking for deviations from the baselines (Scope, Schedule, Cost)
• Updated Project Plan with AD team toward CUT, QA SIT, and SME UAT completion % s on a weekly basis.
• Led the team to maintain Traceability Matrix for the current business requirements and proposed change requests.
• Oversaw and led the extraction of defects report from HP ALM on a daily basis during the SIT and UAT phases, and perform root cause analysis to identify issues/ bugs.
• Created weekly scorecards (Status Slides) for Controls Room Executive Directors.
• Met with project team and stakeholders for periodic reviews of prototypes and final products.
• Managed the creation of the Master Mapping Sheet (Phoenix sourced CR specific enriched/derived attributes and metrics mapping into Force).
• Led the team to work closely with AD team for Force mapping - Design Specification Document of Dashboards.
• Had the team capture, review and finalize detailed IT requirements to support the business, and extensively worked in functionality testing to track defects.
• Had the team assist on-site and offshore QA team in creation of Test Cases and tests implementations.
• Led the team provide Production Support and saved lesson learn, closing documentation in SharePoint.

Tools & Technologies: SDLC, Agile Scrum, Data Migration, Kanban, XP, MS Project, JIRA, Confluence, SharePoint, HP ALM, SharePoint, BluePrint, MS SQL Server 2005, Qlikview.

Confidential, Lawrence, MA

Project Manager / Sr System Developers

Responsibilities:

• Managed the project life cycle from project kickoff through development, deployment, User Acceptance Testing support and launch.
• Hold accountable for ensuring that all the project deliverables are implemented on time, on budget, and within scope, to meet the expectations of the program/project stakeholders.
• Handle Contract, Invoice, and Vendor management.
• Manage vendor selection process and ensure performance based on contract definition.
• Create required status reports on the project for the project sponsors, stakeholders, and management
• Evaluate the project progress (actual vs planned).
• Lead the delivery of selected projects in accordance with Project Management Institution Methodology.
• Ensure satisfactory transition of care, custody, and control of the project’s product upon completion
• Identify, assess and mitigate/resolve risks and issues on the project; provide management with early warning.
• Review deliverables before passing to clients and/or stakeholders.
• Ensures project documents are complete, current, and stored appropriately.
• Enhances department and organization reputation by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.
• Collaborate with project stakeholders and product owners on an ongoing basis to prioritize work across multiple team iterations and actively manage the project scope and key decisions. Build, develop, and grow any business relationships vital to the success of the project.
• Initiate and plan projects successfully by setting up required meetings, involving the right SME's, allocating resources, developing project release plans and iteration plans and producing the right deliverables during each phase.
• Maintain project release plans and ensure the project is conforming to standards by using the PMI’s well-defined project management methodologies.
• Created technical design documents by translating business and functional requirements into system requirements, prototype and implement solutions. Ensured performance, reliability, scalability meet enterprise needs.
• Developed SharePoint Sites for each department by creating web parts, lists, libraries, workflows, BCS’s in Visual Studio and SharePoint Designer.
• Designed and created SQL Server Databases and developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for many applications.
• Developed various intranet web applications by using ASP.NET, C#.NET, JavaScript, JQuery, CSS in Visual Studio.
• Created many SSIS packages and scheduled them to provide data flow between servers located in the USA and China.

Tools: & Technologies: Microsoft Visual Studio 2005, 2008, 2010, MS SQL Server 2005, 2008, T-SQL, SSIS, DTS, SSRS, SSAS, MS Access, SSMS, C#.Net, ASP.NET, VB.NET, HTML, CSS, JavaScript, JQuery, Informatica PowerMart, SQL Server Agent, Oracle, MS Projects, Data Migration, MS Access 2010, MS Visio 2010, PL/SQL, IBM DB2, Wonderware, MS-Office 2010, Share Point 2010, SharePoint Designer, PowerShell, AS400.

Confidential, Jersey City, NJ

Sr. Business Analyst / Project Manager

Responsibilities:

• Created Detail Project Charter to see vision statement, and in scope, out of scope items.
• Worked on project estimation process to develop Project Plan / Major milestones.
• Created and maintained WBS and project plans, and worked through executing, monitoring/controlling and closing of the project management process groups (Application Development/QA team).
• Conducted small group workshops with Product Owner’s Manager to help them understand the objectives of the project.
• Conducted small group workshops with Product Owners to create process flows.
• Conducted weekly requirement walkthrough sessions with the application design team to review the referential & bridge table’s design (attributes list /child-parent relationship).
• Had the team to write BRD (capture, review and finalize detailed business/ IT requirements).
• Led the team to developed UML Use Case description document and use case diagrams (Add a new product/Edit attributes/ Audit Product Tables/ Sunset a Product).
• Worked on Ataccama (RDM) tool User Guide doc/ Training Deck to train the Product Data Owner/ Data Stewards.
• Coordinated with the business testing team (Product Data Owner/ Data Steward) to explain and develop the Test Plans, Test cases, Testing & Evaluation strategy and methods for user acceptance testing (UAT).

Tools: & Technologies: Waterfall, Ataccama, SharePoint, MS-Visio, MS Project. MS SQL Server

Confidential, NY

Business Analyst / SQL Developer

Responsibilities:

• Collaborated with the project manager to define project scope, job description, risks and determined appropriate methodologies to apply based on Scope/Vision documents, and developed project timelines for on-time delivery based on SDLC methodology.
• Widely involved in maintaining necessities traceability and communicating any changes to these requirements to different business groups and programmers.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Designed the system, prepared UML and sequence diagrams using Rational Rose and Visio.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Created SQL Server objects such as tables, triggers, store procedures, functions, and jobs
• Created SSIS Packages using Derived Columns, Pivot Transformation, Fuzzy Lookup, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task, etc.
• Managed all the requirements in MS Word templates, making requirements available to all team members.
• Coordinated and prioritized outstanding risks and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
• Performed Feasibility Analysis and Risk Analysis of vendor/third party tolls.
• Helped prepare a test plan for the system. Developed and implemented test cases on the GUI interface to ensure that requirements were met.

Tools: & Technologies: Waterfall, MS Office Suites, Windows, MS SQL Server (2000&2005), Oracle (8i, 9i&10G), UML, MS Visio, and

Confidential, Princeton, NJ

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse.
• Created interface stored procedures used in SSIS to load/transform data to PRMS
• Hands-on experience in complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.
• Created OLAP Cubes and was responsible for OLAP processing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes
• Designed and developed matrix and tabular reports with drill-down, drill through and drop-down menu option using SSRS.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
• Successfully created a subscription for the windows file share and implemented three-layer securities for the reports, SSRS website, and in the Intranet web application.
• Created Alerts for successful or unsuccessful completion of scheduled jobs.
• Diagnosed and tuning the server optimal performance using SQL server 2005, Dynamic management views, Profiler and Index Tuning Wizards.

Tools: & Technologies: Microsoft SQL Server 2005 Enterprise Edition, Data Migration, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, MS-Visio, Windows server 2003 and IIS 5.0,