SUMMARY:

• Business Logic Data Mining Systems Design and Development Data Analysis
• Experienced, knowledgeable and results - focused Data Architect / Analyst with more than 20 years of demonstrated expertise in full Project lifecycle development, testing and deployment and strong project management experience.
• Expert in Extraction, Transformation, Loading and Visualization of Data.
• Eager to contribute advanced understanding of data analytics, database solutions development and architectural design and deployment expertise toward optimizing the goals of a world class employer in a Data Analyst role.
• Highly credentialed and integrity-driven, demonstrating poise and professionalism under deadline-driven environments, and a focused commitment to improving, enhancing and driving business results utilizing business logic, consistency and accountability.

CORE COMPETENCIES:

• Data Architecture, Migration, Implementation Confidential Data Processing
• Financial System Data Analysis and Data Audits incorporating the MISMO standards
• Predictive Analysis / String De-duplication
• Document Analysis Architecture and Design
• Systems Integration and Implementation
• MSBI Integration (SSAS, SSIS, SSRS)
• Multiple Platforms Technology
• Database Visualizations
• Healthcare/Manufacturing SME

TECHNICAL EXPERTISE:

Oracle PL/SQL: SQL Server 2016/2008/2005 Oracle 11 Microsoft Access 2016/2007/2003 Crystal Reports SQL Server Reporting | SQL Server Business Intelligence SQL Server Integration Services SQL Server Analytical Services TOAD Transformation Services Erwin System Architect Mf Cobol Oracle Designer/Developer 2000 Progress Q&E MS Excel dtSearch Visual Basic for Applications C# .Net 4.0/3.0 Visual Basic 6.0 XML

Progress Query Language: Pearl COBOL Ms-Dos batch scripting language OSQL ASP.Net ASP TSQL

ISQL Scripting languages: JavaScript VB Script HTML DHTML remote scripting IIS 5 & 6

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Data Architect

Responsibilities:

• Architected and designed a data model using Erwin for multiple systems between the Legal, Compliance, and a Data Warehouse for the Tax business area.
• Integrated disparate data models and XML Schemas into coherent enterprise data models, including reverse and forward engineering databases.
• Created the data architecture sections of the System Design Document for development efforts.
• Analyzed functional and nonfunctional business requirements and translated them into technical data requirements.
• Refined the existing Data Models of the relevant business areas and systems for data migration into Tax treatment.
• Architected a design for utilizing the data pipeline to provide actionable insights into key business performance metrics using a variety of tools (Microsoft SSRS, SQL, Excel for MS OLAP/Data Cubes, Power BI for data visualization).
• Worked with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Worked with Agile teams within a highly-collaborative environment.

Confidential, Reston, VA

Senior Consultant

Responsibilities:

• Provided Architectural design and senior level project oversight to design and develop a data migration strategy and source to target mapping to migrate the data out of the legacy systems into the relational DB for State Pensions.
• Provided Architectural design in defining the Data Warehouse to run Analytics on the migrated Data.
• Converted legacy data to a relational 3N Oracle/SQL Server table structures using Erwin to reverse and forward engineer the databases and the enterprise Data Model.
• Performed DB design and reviewed the DB design with the development team.
• Generated the Data Definition Language and the DML for the design as needed.
• Created data dictionaries and business glossaries to document data lineages, data definitions and metadata for the business-critical data domains.
• Created the extraction and translation from Cobol/DB2 to Oracle/SQL Server.
• Analyzed functional and nonfunctional business requirements and translated them into technical data requirements, created new logical and physical data models and updated the existing logical and physical data models
• Created logical data models and physical DB designs to ensure the integrity of the Pension business data was being maintained. Incorporated applicable standard data elements for the Pension subject matter. Ensured that the solutions were accessing the system of record for shared and enterprise data. Ensured the adherence to technical DB design standards in accordance with each State Agency’s standards.
• Developed a data migration strategy to move the data from a Legacy Data System into a Relational Database using the rules defined by the Pension subject matter.
• Facilitated the data modeling sessions, ranging from information gathering to Pension model validation.
• Facilitated the creation of scripts for data cleansing and data verification to validate the business logic.
• Enhanced the DB performance from physical DB design perspective, such as creating indexes, defining constraints, linking tables, and partitioning tables for an effective and fast data migration.
• Provided the guidance to prepare technical documentation on data migration handover.
• Implemented the Migration and provided post migration Technical support.
• Worked with data and analytics experts to strive for greater functionality in the data systems.
• Created data tools for analytics and data scientist team members to implement MSBI Data Visualization for EWA Data Warehouse to enhance their BI Analytics.
• Provided core support to create and enhance Jobs, Triggers, and Stored Procedures, consume XMLs and JSON and other Unstructured Data sources.
• Optimized searches to facilitate the BI Analysis.
• Utilized Jira to manage the user epics and stories. Worked within an Agile environment using Scrum, Kanban.

Confidential, Washington, DC

Senior Consultant

Responsibilities:

• Provide senior level project architecture, oversight and consultancy for Confidential development services for string de-duplication project utilizing strong mathematical algorithms in researching, synthesizing and analyzing electronic documents like emails and documents with embedded objects.
• Completed software development projects in Visual Studio 2008/2010 processing for native files, string de-duplication, predictive coding of electronically stored data in 32- and 64-bit Windows Server platforms.
• Effectively optimized stored procedures and table indexes for processing and developed backend SQL solutions to transfer and upload data into Confidential software Ringtail, and post and retrieve data in and out of SharePoint using SSIS packages.
• Researched and developed viable solutions for electronically tracking chain of process from gathering source to produced legal documents in court, successfully storing information into tables.
• Spearhead development of Business Intelligence solutions that include SSIS packages that map data and transfer to SSRS for report generation for Data Visualization.
• Develop SQL components using stored procedures for string de-duplication of emails that extracts documents for review.
• Develop SQL components using stored procedures ingesting XML model in defining the rules for transformation of data for Predictive Coding Automation.
• Used SSAS and Data Warehousing concepts creating Analytical visual representations of the data in Tableau.
• Used Data Modelling tools like Erwin to design dimensions and types, fact tables, SCD, and implemented OLAP processing.

Confidential, CA

Applications Systems Analyst

Responsibilities:

• Designed and implemented an application that communicated to the Web interface accurately displaying cash flow data using .Net 2.0 with C# and used VSTO to embed a Web Service into Excel documents and wrote the bridge between Excel spreadsheet and online application.
• Successfully supported Reuters and Bloomberg data uploads, developed stored procedures using TOAD for Oracle 10g, and developed embedded analytical tools for cost of funds using Reuters RTD.

Confidential, Flagstaff, AZ

Application Systems Analyst / Manager

Responsibilities:

• Recruited to provide leadership to distance learning team and managed special projects providing connectivity to 3 university systems for inner communications to distance learning center allowing students to register and attend all online distance learning programs.
• Managed custom code design and maintained current production code for distance learning programs integration project and Web application that interfaced to PeopleSoft Oracle Web Services.

Confidential, Los Angeles, CA

Business Systems Analyst

Responsibilities:

• Provided development and support for ForEx System OPICS, and the Mortgage Backed Securities Trading System InTrader.
• Also provided data analysis, development and maintenance support and service.
• Designed custom coding, maintained current source code, provided DR implementation testing of all systems and data transfer from production to DR sites, and tested and executed system and application version upgrades for OPICS and InTrader.

Confidential, Wayne, NJ

Systems Engineer

Responsibilities:

• Designed and implemented BlockNet applications for tax professionals that included database design using SQL 2000 and SQL Server 7.0 with VB6.0 client application configuration.
• Utilized SQL Server stored procedures to develop reporting tools and VB client to Crystal Reports.

Confidential, New York, NY

Systems Engineer/Project Manager

Responsibilities:

• Managed project from inception to completion for various business applications that included SQL database design for Mutual Fund third party clients.
• Utilized Visual Basic to develop COM Objects and developed stored procedures in SQL 2000 and Server 7.0.

Confidential, Hackensack, NJ

Technical Project Manager

Responsibilities:

• Provided hands-on project management and team leadership for QC Intranet site that encompassed 21CFR Part-11 guidelines for electronic records and signature rules per FDA and IEEE, using SQL 2000 and Oracle for design of COM objects and using VB and storage procedures in Oracle, SQL 2000 and SQL Server 7.0.
• Analyzed and performance tuned various components in complex client server application and developed PL/SQL packages and stored procedures to create clean relational data for upload to production tables.
• Successfully pulled data from developed COM components and various sources while significantly improving the reliability and performance from recommended application changes.

Confidential, New York, NY

Analyst / Senior Developer

Responsibilities:

• Provided technical requirements development focused on functional Meta Data requirements from Global Data Warehouse and createddata models for ISI data warehouse that assisted in mapping data iterations from source mart to all derivations across marts.
• Actuate reports development for Copelco Capital.
• Systems maintenance and tracking system management for Pfizer
• Design/development of marketing/analytical tool to monitor grants given by Pfizer.
• Managed team of developers for market analysis tool for MAT System for HMO’s, hospitals and healthcare organizations.
• Developed report module and testing scripts for implementation of decision support and transaction system for AT&T Capital’s Small Business Loan Operations.
• Project Leader for creating/integrating reports into a decision supporting system for Polo/Ralph Lauren.