We provide IT Staff Augmentation Services!

Sr. Program Manager Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Significant progressive experience in business analysis, design and implementation of enterprise solutions for the Financial/Banking sector, Healthcare, and Telecommunication industries.
  • Experience with industry leading data management systems, programming languages, operating systems, and commercial software applications.
  • Comprehensive understanding of software development lifecycle, project management and software quality principles.
  • Demonstrated ability to deliver enterprise scale business solutions to global partners.
  • JAD session facilitator for Enterprise level application.
  • SCRUM master for large scale projects.
  • Consolidate development tools and standardized computing environment provide lower TOC and increased cross application portability.
  • Established center of excellence to promote best practices and knowledge sharing.
  • Created a framework to integrate, secure and share of "Data as an Asset" using PasS paradigm.
  • Interacted with process owners to create a unified vision and roadmap of milestone deliverables.

TECHNICAL SKILLS

OS Environment: Unix, Linux, Mac OS, Windows (System Admin/Development) iOS (Development)

Enterprise Application: Jira, ServiceNow, Subversion, Git, Tideway, confluence, AutoSys

Design/Development/tool: ERwin, Toad, SQL Developer, Tableau, Power BI, IBM Cognos, MS Reporting services, Informatica, IBM DataStage, Oracle data warehouse builder

RDBMS Environment: Oracle, SQL Server, Teradata, Informix, Sybase, dbase/fox pro

Language: C/C++, Java, Visual Basic, C#, Bourne and Bash shell, JavaScript, dBase, PL/Sql, T - Sql, SAS, R, Python

Exposed to: Hadoop, MR2, hive, pig. VMware, HL7, Machine learning, design pattens, UML, ITTL, Agile, Scrum

PROFESSIONAL EXPERIENCE

Confidential

Sr. Program Manager

Responsibilities:

  • Deployment of ITG MacGregor XIP application and infrastructure at a new data center.
  • Deployment of Bloomberg Compliance Center application including vendor interaction, infrastructure requirement and interface development at a new data center.
  • Solutioned a consolidation of business managed applications after a divestiture into a technology managed environment.
  • Provide Solution Architecture oversite in development of application for Global Asset Management.

Confidential

Senior Developer/Architect

Responsibilities:

  • Converting legacy Informix 4GL stored procedure logic to Informatica workflows to improve performance and readability.
  • Documented business logic and process maps.
  • Establish a standard way to call workflow in Unix environment.

Confidential

Senior Database/ETL DeveloperUS Cellular

Responsibilities:

  • Designed and implemented ETL process to provide campaign data to us cellular mobile app.
  • Created technical documentation and data governance profiles.
  • Team code reviews
  • Upgrade to informatica 10.1

Confidential

Solution/Data/BI Architect

Responsibilities:

  • Designed a process that automated SOC compliant processes that were in excel spreadsheets into a Bank proprietary "Quartz" environment using Python and SQL on Teradata, DB2 and MS-SQL Server.
  • Secured business logic under version control using CVS.
  • ETL data from Teradata, DB2 and MS-SQL Server operational systems into MS Sql Server 2008R2 data mart using SSIS.
  • Collaborate with front end development and provide ER models to support an abstracted approach development SOC 2 compliant processed.
  • Established baseline reports to verify extraction results.
  • Wrote complex, but readable queries using CTE for recursive extraction of data.
  • Organized SQL script under source control to manage deployment to production environment.
  • Interface with process owners to convert requirements into user stories in JIRA.
  • Worked with off-shore members to successfully transferring "run-the-bank" processes.
  • Converted complex SAS/base data steps into T-SQL stored procs for business logic.
  • Classes in Unity financial reporting tool.
  • Created logical and physical data models for mortgage data mart.
  • Created a star schema with over 12 facts table.
  • Created T-SQL procedures to populate dimensions and facts table from operational systems.

Confidential

Solution Architect

Responsibilities:

  • Delivered a Data Quality Engine (DQE).
  • Design and developed data model for DQE Data Mart.
  • Populated data mart with reference and statistical data from source systems as produced by DQE.
  • Created stored procedure in SQL Server to support data input and validation of DQE meta data.
  • Created ETL in Informatica 9.6.2 to load DQE and Data Mart.
  • Created a tableau front end to present DQE data.
  • Proposed using PowerBI; created process with ETL and reporting in PowerBI as a demo.
  • Evaluated Collibra (data governance tool).

Confidential

Senior Data Architect

Responsibilities:

  • Planning and delivering Data Integration as a Service model at Confidential .
  • Reduce license cost of Informatica by providing a central PasS.
  • Established standard for Informatica 9.6.1 environment for ETL development with reusable object and leveraged data quality (IDQ) and master data management (MDM) for improved analysis.
  • Implemented new strategies to deliver robust data warehouse solutions by using Kimball standards.
  • Drove rapid adoption of business strategies/solutions by leading Informatica implementation teams.
  • Responsible for establishing area of excellence within Confidential for Informatica IDQ, HUB, MDM and the PowerCenter products.
  • Established deployment standard; wrote bash shell scripts for deployment from Dev to UAT and Prod environment from subversion repository.
  • Created a standard data integration process to populate dimension and fact tables in a star schema.
  • Successfully used ETLFactory to automate data source to dimension loads.
  • Created conceptual, logical and physical schemes to house server data for an oracle database.
  • Developed a data warehouse to analyses CPU/Memory, and storage utilization for the Confidential computing environment.
  • Developed front-end dashboard in Tableau to provide analysis for decisions support
  • Hands-on leadership role in development of custom oracle packages in PL/SQL, Unix shell scripts with calls to C/C++ and perl to automate data warehouse housekeeping tasks.
  • Architected a datacenter migration tool using Visual Studio 2015 IDE with C#/.NET and SQL-Server 2008R2. Used AngularJS and Bootstrap to design the UI.

Confidential

Business Solutions Consultant

Responsibilities:

  • Created data validation reporting system which integrated live data feeds and stored these into a data warehouse.
  • These reports were generated using COGNOS and Oracle as the database.
  • Implemented reporting schemes using COGNOS Scheduler application.
  • Developed validation test cases for COGNOS reports that verified ETL from a CMS system and other data sources.
  • The test cases were executed and validated using Toad Oracle 9.2 and MS Excel.
  • Developed shell scripts in Korn Shell on Tru64 UNIX for processing data files using an in-house custom application written in PERL.
  • Created change requests for design correction and bugs in the ETL processing.
  • Developed and automated a scripting library for COGNOS catalogs.

Confidential

Business Intelligence Consultant

Responsibilities:

  • Engineered a process to convert reports written in FoxPro to Crystal Reports within the limits of the Oracle database backend strategy.
  • Extract Transform Load functions were completed by implementing stored procedures in PL/SQL Oracle environment into a data warehouse schema using Pro*C++ programs.
  • Developed a Visual C++ console program which managed a central scheduling program that not only scheduled but handled exception scenarios for ETL programs.
  • The C++ VB scheduling program used COM to update MS Excel with status and was able to start ETL processes in parallel for maximum throughput.
  • Daily running and supporting of Crystal Reports with various users throughout Confidential .
  • Managed incidents and corrective action/preventative action methods were used to fix defects within reports.
  • Created standard reports as determined by business process teams and completed validation scripts and testing plans.

We'd love your feedback!