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.