We provide IT Staff Augmentation Services!

Program Manager / Technical Project Manager Resume

Peapack, NJ

PROFESSIONAL SUMMARY:

  • Information Technology Expert providing Consulting, Management and hands on support to Senior Executives at Fortune 500 Pharmaceutical, Life Science, Financial, Banking and Insurance industries.
  • Extensive experience as a hands - on Senior Project Manager / Solutions Architect/Data Modeler (Dimensional, Relational) /Release/Change Manager in all facets of project lifecycle in Agile/ Waterfall methodologies including analysis, planning, resource management, budgeting, tracking milestones, risk management, stakeholder relationship, mentoring, communication and vendor management (onshore and offshore).
  • Consistently managed multiple concurrent projects, allocating resources to appropriate projects to ensure all projects are completed on time and within budget.

TECHNICAL SUMMARY:

Databases: Amazon Redshift, Postgre SQL, Teradata 12.0, DB2 UDB 8.0, Sybase Enterprise Server 11.5, Oracle 11g, Green plum 3.3, MS-SQL Server 2012, DMS-II

Software: Erwin 7.2, Power Designer 16.5, Enterprise Architect SP1, Tortoise SVN, TOAD 9.0, PVCS Version Manager 6.5, Rational Clear Quest., Business Objects 5.0, White Light Workbench, Data Stage 11.5, Informatica 7.1, Share Point, Remedy, Jira, Confluence 5.9.6. MS Project 2010, Service Now Istanbul, SharePoint, Alteryx 2018.3

OS: Sun OS 5.6, Windows NT, NCR 3.0.2, MCP4.5 (Unisys), UNIX RSX-11M, Novel Netware

Hardware: Sun Ultra Enterprise -6500, NCR5100C, Unisys ‘A’ Series NX 4800

PROFESSIONAL EXPERIENCE:

Confidential, Peapack, NJ

Program Manager / Technical Project Manager

Responsibilities:

  • Performed detailed analysis to define policies on objects to segregate Consumer data from Confidential for the initiative.
  • Implemented Virtual Private Database (VPD) to secure Confidential data from Consumer users..
  • Managed the complex Confidential Consumer Healthcare Joint Venture with GSK program and successfully completed Day 1 with not a single issue reported.
  • Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms. Prepared detailed work breakdown structures (WBS), and instilled shared accountability for achieving project milestones.
  • Defined generic QA steps in ALM for testing to perform their steps.
  • Utilized Track wise to create Change tickets and move them thru various stages for Action Item approvals.
  • Led teams across broad technical and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time and with desired results.
  • Mitigated risk factors through careful analysis anticipated and managed change effectively in rapidly evolving global business environment.
  • Worked collaboratively with internal and external teams to ensure successful project outcomes.
  • Conducted weekly cell meetings with business and technology teams, checkpoint calls, developed weekly status report decks for Sr. Management and, set and adjusted project timelines.
  • Worked with cross functional teams like DBA, QA, Compliance, Business and technology.
  • Successfully managed and worked with Onsite/Offshore model.
  • Performed multiple technical roles from initial analysis to setting up of ALM test cases for UAT.

Environment: Oracle 11g, Toad 11.5, Microsoft Project 2010, HP ALM Quality Center 11.5. Trackwise 6.0 (Change Control tool)

Confidential, Bridgewater, NJ

Sr. Consultant - Data Analytics & Strategies

Responsibilities:

  • Partnered with various members of team for successful Release of SSOT (Single Source of truth) for Medical devices group of Confidential & Confidential Data Lake/Data Warehouse
  • Worked closely with Data Modelling team to build the new Canonical/LDM/PDM for new SSOT application.
  • Worked with Business to get data discovery artifacts, defining the business rules, Target to Source mapping, Data Profiling.
  • Collaborate with Architecture and Solutions team for defining and maintaining the metadata for the new application..
  • Worked with Application Services team to define SIT and UAT strategies for validation of newly designed product..
  • Defined the Sematic layer for segregating the needs of various companies within the group incorporating business rules specific to the business.
  • Worked with business partners for procuring Milestone and Incremental data for Production run.
  • Create detailed Implementation strategy and plan to rollover from existing to new application.
  • Followed the Agile/Scrum methodology for Development adhering to Kanban board timelines

Environment: AWS, RedShift, Postgre SQL, Alteryx 2018.3, Spectrum, Oracle 11g, Server 2014, Erwin 7.2, Service Now, Jira

Confidential, Plainsboro, NJ

Solutions Architect

Responsibilities:

  • Partnered with stakeholders to understand, analyze and evaluate data needs.
  • Analyzed the requirements for developing Logical model, Physical model and Source to Target Mappings.
  • Collaborate with Business Analysts, Product Owners and Business Customers to identify data usage patterns and formulate business names, definitions and data quality rules for data elements.
  • Serve as a Data-Modeler using Enterprise Architect to model new data architecture normalization.
  • Created entity relationship diagrams and multidimensional data models, reports and diagrams based on the requirements.
  • Analyze multiple sources of structured and unstructured data to propose and design data architecture solutions for scalability, high availability, fault tolerance, and elasticity.
  • Partner with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
  • Ensure design reflects appropriate business rules, and facilitates Data integration, data conformity and data integrity; Ensure data structures are designed for flexibility to support future business needs and enhancements.
  • Design and architect the Reconciliation process to validate various data entry points from source through the Data Mart.
  • Collaborate with Onsite and Offshore teams to ensure seamless handover of activities.
  • Create detailed Implementation strategy and plan to switch over from current to new EDW.

Environment: SQL Server 2014, Data stage 11.5, IBM Enterprise Architect SP1

Confidential, Boston, MA

Systems Architect / Sr. Data Modeler

Responsibilities:

  • Managed data architecture design delivery, data model development, review and Data warehouse implementation.
  • Responsible for content creation, review and used Agile Methodology for Data Warehouse development.
  • Partnered with Business SME's on requirement gathering, understanding the business and functional requirements. Provide high level Strategic/Tactical solutions for the complex business scenarios, Data anomalies, and requirements.
  • Maintained all metadata relating to the EDW’s, descriptions of data objects, access methods and security requirements.
  • Involved in relational and dimensional Data Modeling for creating Logical and Physical design of the database and ER diagrams using Sybase Power Designer.

Environment: Oracle 12c, Power designer 16.5, Jira, Service Now, Scrum/Agile methodology

Confidential, New York City, NY

Data Warehousing Architect/ Data Modeler

Responsibilities:

  • Lead efforts to create, introduce, rollout and establish Change and Release Management processes based on industry best practices. Chaired Change Management Advisory Board discussing all change issues with business groups.
  • Partnered with Business sponsor (Stakeholder), IT, Incident Management and Production Services supporting and prioritizing work and managing the Gateways set for releases.
  • Acted as Scrum Master to facilitate daily standup, backlog refinement, sprint and release planning, retrospectives, and demos.
  • Designed and implemented Automation of Runbooks for global releases for Risk IT related to Regulatory and Compliance supporting BCBS239 and other regulations.
  • Identify and provide data from master data sources and map to logical and further to physical data model.
  • Reviewed and participated in Data Governance Standards revision discussions, such as Metadata Standard, Data Quality Standard, Data Life Cycle and Control Standard.
  • Provide audit information for data lineage to answer impact analysis and regulatory requirement for Data Governance initiative.
  • Conducted Run book walkthroughs with global teams and created standards in Deployment/Post Deployment Validation, QA Checks, User Checks and running the release management function end to end.
  • Collaborated with Developers within the RTB / CTB and other team to ensure timely delivery of projects using Kanban dashboards.
  • Analyzed, Designed and Developed Data Access for the entire Nomura’s Data Warehouse application.
  • Lead the Data Modeling team to model Nomura Application to successfully achieve SOX compliance. Facilitated IT best practices and SOX compliance in accordance with regulatory requirements.
  • Increased BI user adoption through improved Data Governance and data quality ease of use reporting.
  • Designed and Implemented audit process for data quality that is loaded into the Data warehouse from the Core system generating the pass and fail scenarios to track proper loading of data by ETL. This process also enables the Business Analyst to check for accuracy and Business Rules.
  • Enhanced existing Data Warehouse architecture to integrate new source for Fixed Income into existing Data Warehouse.
  • Analyzed and designed processes for Data Access into Nomura’s Centralized Data Warehouse for Global users.
  • Proposed, implemented and recommended physical object structures and their design, i.e. materialized views, indexes, partitioned tables, etc.
  • Performed Data analysis and profiling of new sources that were sourced into the Existing Data warehouse.
  • Managed modeling physical structure for the new product and created naming standards for objects adhering to industry standards.
  • Liaison between the Production DBA and application team on various initiatives.

Environment: Oracle 11g, Erwin 7.2, Power designer 15.0, Informatica Power Center 7.0, TOAD 9.0, SQL Server 12.0, Jira, Remedy Admin, Autosys, CTRL M. Rivermuse, Confluence 5.9.6, Visio, MS Project 2010, Service Now.

Confidential, Salt Lake City, UT

Senior Consultant

Responsibilities:

  • Consulted design discussions with business stakeholders based upon the new requirement, understand gaps in existing Data Mart and design and recommend more flexible data mart.
  • Coached the organization on Scrum and Agile practices. Work closely with Product owner to support sprint, planning, keep backlog groomed and work prioritized.
  • Converted database functions in Oracle to Greenplum/Postgre SQL and created YAML-formatted files for flat file bulk loading into Greenplum environment.
  • Partnered with business analyst and developers, ensuring development is in line with the design standards and mappings and conducted review with BA and developers.
  • Performed data quality activities such as cleansing, matching, and consolidation using Business Objects Data Services.

Environment: Oracle 10g, Erwin 7.2, Green plum 3.3, Data Services, Scrum/Agile methodology

Confidential, New York City, New York City, NY

Data Architect / Data Modeler/Project Lead

Responsibilities:

  • Collaborated with users to understand the business requirement which was leveraged by many downstream users.
  • Performed data analysis and data profiling and gap analysis of upstream sources that fed into Sandbox application.
  • Standardized data governance process around the upstream and downstream applications.
  • Designed and Created logical model for Sandbox application and leveraged it for physical model implementation.
  • Automated data load and multiple views of old data through parameters which were modeled to provide additional functionality.
  • Implemented physical object structures and their design, making effective use of materialized views, indexes, partitioned tables, etc.
  • Coach leaders, teams in agile practices and mindset. Facilitate Agile/ Scrum ceremonies such as sprint planning, retrospectives and daily huddles.

Environment: Oracle 10g, Erwin 7.2, Informatica 8.1 Autosys

Confidential, New York City, NY

Enterprise Data Architect /Data Modeler

Responsibilities:

  • Lead in architectural deliverables associated with Portfolio Management and SDLC.
  • Core member of Data Architecture COE providing design/development expertise for Database across the IT.
  • Conducted performance gap analysis for the new data needs against existing data warehouse data model and identified data model enhancement / impact analysis for captured requirements.
  • Followed the AGILE methodology for software development and played the role of SCRUM master.
  • Oversaw the data load production process and implemented new data load files in accordance with the departments change management process.
  • Designed and implemented the audit process of capturing data and loading it through the ETL process.
  • Created Performance tuning document for Oracle developers and supported performance tuning of various applications using Oracle best practices and rolled out Oracle Enterprise Manager to developers.

Environment: Oracle 9i, Erwin 7.2, Informatica 7.1 SVN, MySQL

Confidential, NYC, NY

Senior Data Modeler/Data Architect

Responsibilities:

  • Designed and created new architecture for Business Management Dashboard which assisted in high-level management reporting.
  • Perform analysis to determine information requirements on existing models to ascertain functionality.
  • Modeled the Financial Analyst information model for the Data warehouse and integrated it with the Core Party Data Model.
  • Modeled the current application changes for Mutual Fund Trading, Choice Billing, Business Management Dashboard, Small Business Retirement and other application.
  • Created Conceptual, Logical and Physical models for OLAP / OLTP applications that provided flexibility for future enhancements.
  • Reverse Engineered-exiting models to synch up with the Model Mart.
  • Partnered with DBA group to create a robust Architecture for Data Access to the application that was used for
  • Performed Data profiling of new data sources that were used to source data to the Warehouse..

Environment: Teradata 12.0, Erwin 4.1, DB2 9.0

Confidential, NYC, NY

Data Architect/Data Modeling/ Data Warehousing Specialist

Responsibilities:

  • Analyzed, Designed and Developed Data Access for the entire Nomura’s Data Warehouse application.
  • Created and Maintained Data Models (using Kimball’s Methodology) for Core NCDI, EUC (End User Computing), Interfaces, Rolfe and Nolan and BONY feeds.
  • Active Player of SOX Compliance Data Modeling team that modeled the Application for Nomura to achieve the SOX compliance successfully.
  • Increased BI user adoption through improved Data Governance and data quality ease of use reporting.
  • Facilitated IT best practices and SOX compliance in accordance with regulatory requirements.
  • Designed and Implemented audit process for data quality that is loaded into the Data warehouse from the Core system generating the pass and fail scenarios to track proper loading of data by ETL. This process also enables the Business Analyst to check for accuracy and Business Rules.

Environment: Oracle 11g, Erwin 4.1, Power designer 15.0, Informatica Power Center 7.0, TOAD 9.0, SQL Server 12.0, Jira, Remedy Admin, Autosys, CTRL M. Rivermuse, Confluence 5.9.6, Visio, MS Project 2010, Service Now.

Hire Now