Sr. Program Manager Resume
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.