We provide IT Staff Augmentation Services!

Technical Program / Project Manager Resume

Malvern, PA

SUMMARY:

  • A 19 - year experienced IT Post graduate, self-motivated, PgMP certified Technical Program / Project Manager / Solution designer with 12 year of experience (7 Year US experience) in designing and implementing multi-Million Dollar projects in Finance Domain (Lending / Leasing, Factoring and AML)
  • Agile (Scrum / Kanban) and Waterfall project management methodologies using tools like JIRA, MPP, Visio
  • Facilitate scrum ceremonies such as release planning, Daily scrum, Sprint planning,
  • Exceptional interpersonal and communication skills, Motivation Skill, Conflict Management skill, Team Leadership & Collaboration, Critical Thinking and analytical mindset.
  • Work with PMO to prepare Project / Program Management plan, Scheduling, Resource Management, Vendor (Procurement) management, change management, Risk Management, Finance Management / Budgeting.
  • Setting up Financial Frame work and prepare financial plan which includes Budgeting, Payment schedules, collection schedule.
  • Highly skilled in developing solutions, procedures & service standards for project transformation and business excellence, possesses in depth experience of designing effective solutions, transitioning multiple projects and ensuring seamless end to end delivery of services in onsite & offshore model
  • Oversees all projects of the program and provide necessary support and leadership to project managers and team to ensure that all aspects of key stakeholder’s requirements are appropriately prioritized and managed
  • Engaging with customers / stakeholders for customer delight experience and manage their expectation and escalation.
  • Prepare weekly/monthly reports on key performance indicators (KPIs), Velocity and other metrices
  • Excellent working knowledge of Software Development Life Cycle (SDLC) and UML Methodologies
  • Grooming & Prioritizing the product back log and track backlog health regularly to make sure that stories are ready for the coming sprints.
  • Involved in designing the system architecture to be hosted on AWS
  • Hand on experience in C#, Angular, Java coding and Oracle PL/SQL
  • Employing Data Warehousing (ETL) and Business Intelligence best practices with proven ability to build, lead and manage high performing teams.
  • Experienced in creating entity relational & dimensional relational data models using Kimball Methodology i.e. Star
  • Schema and Snowflake Schema.
  • Involved in contract life cycle management activities
  • Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases, XML and Flat Files using SSIS package.
  • Assist defect resolution and environment issues. Responsible for coordinating across several IT teams in order to align project deliverable dates, milestones, and resolve issues.
  • Writing Business case and preparing Project / Program Management plan and other subsidiary plans which includes Risk Management plan, scope Management, and other plans
  • Personnel management including hiring/ and performance appraisals

SKILL:

Program / Project / Product Management using Waterfall and Agile methodology, Oracle PL/SQL, SQL Server, DB2, My SQL, AWS,AIM, RDS, JAVA, .NET, Java Script,, Angular, MVC,CSS, SOAP, REST, ETL, SSIS, Windows, Unix, Linux, Web logic, ISS,JBOSS, Web Sphere, BIRT, Crystal Report, Tableau, OBI, SharePoint, JIRA, MPP,PowerPoint and Ms. VisioRetail & Corporate Mortgage Finance, Personal Finance, Auto Finance, Anti Money Laundry- AML, Factoring, Invoice discounting, Supply chain finance and Retail / eCommerce (OMS/PayPal).

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Technical Program / Project Manager

Responsibilities:

  • Project management using Scum methodology in JIRA.
  • UAT Execution, Integration Management, Post Production support, Bug tracking and resolution using Kanban methodology in JIRA.
  • Assisted with management efforts in escalating issues, working with venders and SMEs to resolve issues. Created, processed and track JIRA’S for process improvement, business requirements, functional specifications and enhancing procedures.
  • Assess test coverage, risk management, impact analysis with new requirements. Create test strategy approach between projects for specific release Perform reverse engineering of physical data models from databases and SQL scripts.
  • Solution design and the development of key artifacts including, but not limited to architectural models, process diagrams, concepts of operation, etc.
  • Collaborate with SMEs from other specializations to author solution design documents tailored to individual client requirements. Translate business requirements in to technical requirements.
  • Defined the architecture for the new ETL process and the target data flows by conducting technical workshops with the business and IT stakeholders and performed Data Modelling on Oracle using Erwin
  • Creating SQL statements and creating automated jobs using DTS, Query Analyzer, SQL Server Agent, T-SQL, DTS Export and Import Wizards, TOAD and SQL Navigator. Proficient in development of Stored Procedures, Functions, Database Triggers, Cursors, Packages, User Defined Functions using T-SQL and PL/SQL.

Technical Environment: J2EE, Oracle, MVC, REST, APIs, XML,ETL,SQL Loader, and Crystal Report, MS. Word, PowerPoint, Visio, SharePoint, PowerPoint, Scrum and JIRA

Confidential, Florida

Technical Program / Project Manager

Responsibilities:

  • Epic and Story writing, Capacity planning, Estimation using story point using scrum poker and Release planning.
  • Project Management and tracking using JIRA, MPP, Visio, Ms. Office and Power point.
  • Defining product road and master schedule.
  • Solution design and the development of key artifacts including, but not limited to architectural models, process diagrams, concepts of operation, etc.
  • Collaborate with SMEs from other specializations to author solution design documents tailored to individual client requirements. Translate business requirements in to technical requirements.
  • Facilitate ceremonies such Release planning, Daily scrum, Sprint planning, Sprint Review and retrospective.
  • Involved in complex debugging and troubleshooting related to conversion and environment issues with all source systems. Resolved day to day production issues.
  • Performed Data Modelling on Oracle using Erwin
  • Created Test plans, Use Cases for Provisioning & De-provision work flow and performed Dev Testing, UAT/IT testing and finally Prod testing prior to turning on the switch
  • Build ETL workflows in Microsoft SSIS to migrate data from Sybase to SQL server using ODBC connection
  • Developing business case, program Management plan and make sure that business case is valid thought out the program and always meeting the organization strategic objective

Technical Environment: Net, C#, Angular, SQL Server, Xamarin, AWS, MPP, Visio, JIRA, PowerPoint, Scrum / hybrid

Confidential

Technical Program / Project Manager

Responsibilities:

  • This program is structured using 4 interdependent projects; 1.Loan Origination / on boarding System - 2.Loan Management, 3.Escrow system 4. AML- Anti Money Laundering
  • Worked as Customer’s Program / Project manager.
  • Coordinating with 4 vendors for smooth implementation of their respective systems and Integration.
  • Data migration from DB2 database to Oracle using SQL loader
  • Coordinating with Legal, Compliance and accounting department.
  • Prepared detail design for the application and built the ETL components
  • Responsible for generating source views and target definitions.
  • Worked effectively with complex mappings, reusable transformations and used incremental updates for control tables.
  • Project Management and tracking using JIRA, MPP, Visio, Ms. Office and Power point.
  • Participate in ceremonies like Daily scrum, Sprint review and sprint retrospective.
  • Implement organization strategy, draw roadmap, define delivery model and prepare program schedule
  • Program Level Status reporting, tracking and overseeing all projects under program.
  • Oversees all projects of the program and provide necessary support and leadership to project managers and team to ensure that all aspects of key stakeholder’s requirements are appropriately prioritized and managed

Technical Environment: J2EE, .NET, C#, DB2,Oracle, MVC, REST, APIs, XML,ETL,SQL Loader, and Crystal Report, MS. Word, PowerPoint, Visio, SharePoint, PowerPoint, Scrum and JIRA

Confidential

Program / Project Manager

Responsibilities:

  • This program is structured using 4 interdependent projects; 1. Mortgage / Home Finance - 2 Personal and Auto Finance, 3.Goal Loan 4. Micro Finance
  • Writing, testing and debugging code in Java, spring boot, Java Script, Angular and Oracle PL/SQL
  • Created Test plans, Use Cases for Provisioning & De-provision work flow and performed Dev Testing, UAT/IT testing and finally Prod testing prior to turning on the switch
  • UAT Execution, Integration Management, Post Production support, Bug tracking and resolution Hand on experience of writing code using Oracle PL/SQL and Unix shell script
  • Responsible for architecting solution, scope, expectation management and communication to all stakeholders.
  • Facilitate project managers and support them in achieving the Program goal.
  • Facilitate story writing workshop, writing stories, preparing and grooming product backlog, sprint retrospective
  • High level / Epic level estimation and Release planning using scrum poker, Capacity planning, story point estimation, coordinate with scrum teams, facilitate them to complete the delivery on time.
  • Get involved with technical team to work on system architecture, designing the proposed application.
  • Project Management and tracking using JIRA, MPP, Visio, Ms. Office and Power point.
  • Participate in ceremonies like Daily scrum, Sprint review and sprint retrospective.
  • Work with PMO to prepare Project / Program Management plan, Scheduling, Resource Management, Vendor(Procurement) management, change management, Risk Management, Finance Management / Budgeting.
  • Implement organization strategy, draw roadmap, define delivery model and prepare program schedule
  • Program Level Status reporting, tracking and overseeing all projects under program.

Technical Environment: JEE, Oracle, Jboss, Struts, MVC, SOAP, APIs, XML,ETL,SQL Loader and Crystal Report, MS. Word, PowerPoint, Visio, Scrum JIRA.

Confidential, Atlanta, GA

Technical Project Manager / Business Analyst

Responsibilities:

  • Worked as Customer’s Program / Project manager.
  • Coordinating with 4 vendors for smooth implementation of their respective systems and Integration.
  • Data migration from DB2 database to Oracle using SQL loader
  • Coordinating with Legal, Compliance and accounting department.
  • Prepared detail design for the application and built the ETL components
  • Responsible for generating source views and target definitions.
  • Worked effectively with complex mappings, reusable transformations and used incremental updates for control tables.
  • For performance, used many tuning techniques both in Mapping as well as in Session level.
  • Involved in writing code in Oracle PL/SQL and JAVA
  • Project Management and tracking using MPP, Visio, Ms. Office and Power point.
  • Participate in ceremonies like Daily scrum, Sprint review and sprint retrospective.
  • Work with PMO to prepare Project / Program Management plan, Scheduling, Resource Management, Vendor(Procurement) management, change management, Risk Management, Finance Management / Budgeting.

Technical Environment: J2EE,, Oracle, MVC, REST, APIs, XML,ETL,SQL Loader, and Crystal Report, MS. Word, PowerPoint, Visio, SharePoint, PowerPoint

Confidential, CA

Dev Project Manager / Business Analyst

Responsibilities:

  • Reviewing Technical specification document prepare by the development team
  • Preparing and executing Database migration script and data reconciliation
  • Conducting requirement gathering sessions with respective stakeholder using best elicitation techniques and convert requirements to solution mapping document to deliver quality product with best customer satisfaction. Liaison between Business team and Technical team.
  • Preparing Scope Management plan after having discussion with stakeholders for setting up the processes to be followed for requirement gathering and delivering quality solution.
  • Prepare the Functional Specification document and test scenarios / cases to make sure that quality solution is delivered to customer by using 20 Quality Metrics.

Technical Environment: Delphi, Sybase, ASP.NET, Crystal Report, MS. Word, PowerPoint and Visio

Confidential, CA

Dev Project Manager / Business Analyst

Responsibilities:

  • Reviewing Technical specification document prepare by the development team
  • Preparing and executing Database migration script and data reconciliation
  • Conducting requirement gathering sessions with respective stakeholder using best elicitation techniques and convert requirements to solution mapping document to deliver quality product with best customer satisfaction. Liaison between Business team and Technical team.
  • Preparing Scope Management plan after having discussion with stakeholders for setting up the processes to be followed for requirement gathering and delivering quality solution.
  • Prepare the Functional Specification document and test scenarios / cases to make sure that quality solution is delivered to customer by using 20 Quality Metrics.

Technical Environment: Delphi, Sybase, ASP.NET, Crystal Report, MS. Word, PowerPoint and Visio

Confidential, CA

Dev Project Manager / Business Analyst

Responsibilities:

  • Reviewing Technical specification document prepare by the development team
  • Preparing and executing Database migration script and data reconciliation
  • Conducting requirement gathering sessions with respective stakeholder using best elicitation techniques and convert requirements to solution mapping document to deliver quality product with best customer satisfaction. Liaison between Business team and Technical team.
  • Preparing Scope Management plan after having discussion with stakeholders for setting up the processes to be followed for requirement gathering and delivering quality solution.
  • Prepare the Functional Specification document and test scenarios / cases to make sure that quality solution is delivered to customer by using 20 Quality Metrics.

Technical Environment: Delphi, Sybase, ASP.NET, Crystal Report, MS. Word, PowerPoint and Visio

Confidential

Oracle Developer and Java Developer

Responsibilities:

  • Serve as technical lead of an offshore team for the design and development of new enterprise web-based applications as well as new versions of existing ones written in and Oracle PL/SQL.
  • Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
  • Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures
  • Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, cursors, and other database objects.
  • Create PL/SQL packages, standalone procedures, and standalone functions.
  • Write complex SQL queries with sub-queries, analytical functions, and inline views

Technical Environment: SaaS, J2EE, Oracle, Jboss, Struts, MVC, SOAP, APIs, ETL,SQL Loader and Crystal Report, Domain- Finance (Factoring)

Confidential

Oracle Developer and .Net developer

Responsibilities:

  • Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
  • Use Collections like variable arrays, nested tables
  • Design and create entity relationship diagrams (ERD) for Oracle based applications and interfaces.
  • Provide on call and daily production support of applications and Oracle PL/SQL ETL processes.
  • Manage the packaging and release of applications to the, UAT and production environments.
  • Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
  • Design and develop ETL processes in PL/SQL to pull data from multiple sources into a single database source for end user reporting purposes
  • Use DBMS JOB and DBMS SCHEDULER create and schedule the execution of packages, standalone procedures and emailing of reports from the database.

Technical Environment: Oracle PL/SQL and .NET

Hire Now