SUMMARY

• Sound working knowledge of data warehouses (snowflake & star schema design). Contributed in Enterprise Data Warehouse projects with design of data marts, implementation & support, working off database systems like Confidential, Confidential, MS SQL Server, PostgreSQL, DB2 - executing programs in UNIX & Windows environment
• Sound experience in developing and presenting data flow diagrams, conceptual diagrams, ER flow diagrams, creating the ETL Source to Target mapping specifications as well as implementing complex data driven solutions, working closely with Database Administrators, Developers and business team
• Solution design and implementation experience using data modelling tools: ER/Studio Data Architect and ERwin, with good understanding of the design goals of Entity Relationship modeling for OLTP and multidimensional modeling for OLAP; normalized and de-normalized models, slow-changing dimensions/attributes.
• Expertise on data integration projects utilizing industry standard ETL tools: SAS Data integration studio, MS SQL Server Integration Services (SSIS), and Informatica Powercenter; optimizing batch process as well tuning various ETL jobs.
• Extensive background in implementation of software applications, data analysis using SQL and following SDLC process.
• Presented insights based on data analysis; analyzed data with data mining tool to identify trends

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Contract Consultant

Responsibilities:

• Designed and implemented Extraction, Transformation and Loading (ETL) steps to load SQL Server data warehouse from Confidential database.
• This involved data standardization based on data quality analysis of Natural Gas Production Volumes.
• Designed implementation logic, built database objects like stored procedures and data view applying business rules.
• Technologies utilized to accomplish projects: MS-SQL server, MS-SQL Visual Studio, Management Studio, SSIS, TFS, Azure DevOps, GitHub, TOAD for Confidential .

Confidential, Houston, Texas

Senior Data Engineer

Responsibilities:

• Designed and implemented data marts to support data science projects.
• Implemented ETL steps, using SQL and TSQL procedures to load the data marts that were executed based off step, container, and pipeline definitions
• Updated ER models diagrams and database table schema on Confluence software, based on understanding the data usage in R programs.
• Technologies utilized to accomplish projects: MS-SQL server, Azure SQL database, R studio, Bitbucket

Confidential, Houston

Texas -Technical Consultant

Responsibilities:

• Designed and implemented data integration projects with ETL (extract, transform and loading) workflows based on data analysis of the PPDM (Professional Petroleum Data Management) model and WellView (oil well data model)
• Provided the source to target mapping specifications for the data integration projects, as well as the data models using E/R Studio Data architect.
• Sourced data from MDM data source on Confidential system to Confidential server and using Linux shell scripts
• Reviewed and made enhancements on existing data models for the oil and gas related projects, accessed data using SAP Netweaver 740 as well SAP Business Objects Universe for data discovery.
• Designed data objects/views, utilizing data virtualization tool CIS(Cisco Information Studio) and Spotfire information links.
• Technologies utilized to accomplish project tasks: Confidential, Confidential, SQL, Informatica Powercenter, Spotfire, E/R Studio

Confidential

Contract Consultant

Responsibilities:

• Built the ETL and ELT processes that populated data to a dimensional data model, used for revenue allocation
• Sourced data from the Enterprise Datawarehouse environment (stored on Confidential ) to Confidential tables, adding required metadata, implementing programming logic PL/SQL and invoking stored procedures within the ETL Jobs
• Used TOAD and Confidential SQL Assistant to unit test ETL jobs that were built using the ETL tool SAS Data Integration Studio. Deployed the jobs for batch execution in unix environment, using the jobs scheduler software

Confidential, North Carolina

Contract Consultant

Responsibilities:

• Integrated data from Confidential based enterprise data warehouse and MS SQL Server 2008 databases.
• This included building SQL queries, utilizing Confidential SQL assistant, MS SQL Server 2008 Management Studio, Aginity Netezza Workbench tool, SAS Management console, Data integration Studio and Enterprise Guide
• Designed and developed the ETL processes to populate the dimensional data model.
• This involved creating the tables, views, workflows, reusable stored procedures as well as using TSQL.
• Presented solutions, alternatives, for requirements considering scalability, flexibility, ease of maintenance and time to delivery for the phased project release schedules.
• Interpreted business requirements into technical solutions, proposed logic solutions and data fixes
• Provided conceptual & logical data model (using MS Visio 2007), for the approved customer loans considering conformed dimensions of the ‘Risk Evaluation’ Dimensional Model
• Delivered on Business Intelligence projects with data analysis, profiling, adding data quality checks in ETL jobs and reporting off Datawarehouse to the business users.
• Created and maintained metadata on metadata management tool, for the Enterprise Data warehouse structure; functioned as technical lead collaborating with offshore development team and onsite business users

Confidential, Houston, Texas

Contract Consultant

Responsibilities:

• Designed and developed the ETL (Extraction, Transformation and Loading) processes and implemented the data warehouse design (mapping Confidential 10g source system data into the data warehouse model).
• Migrated the ETL process to the multi-tier application ‘Data Integration Studio’ from the 'Data warehouse Administration' tool. Built programs and queries to conduct test cases for the implementation (using 'SAS Enterprise Guide' application).
• Maintained and provided primary support for the data warehouse as well as implemented design enhancements. Duties included troubleshooting, enhancing process performance and provided reporting requests for forecasting projects
• Conducted data analysis, resolved data discrepancies and proactively administered fixes for the DW
• Delivered BI solutions with design and implementation, including requirements definition, data acquisition processes, data modeling, process automation and deployment. Utilized SAS BI Tools for dashboards.
• Implemented OLAP Cubes, Information Maps and Stored processes on the web portal.
• Supported the daily batch processing of Energy Credit Risk application (maintained on MS SQL Server 2005); created SSIS packages reviewing TSQL programs and implemented stored procedures on Reporting Services (SSRS)
• Contributed in data processing improvements and decision support projects that evaluate 'Value at Risk' and 'price / profit value’ variations; gathered requirements and designed the data marts

Confidential

Data Consultant

Responsibilities:

• Contributed to Marketing Projects with development & analysis of information from an Confidential based Data warehouse using SQL and SAS within UNIX and Windows NT environment; supported by BI query tools.
• Design and development of solutions working off the CRM data warehouse, manipulation and transformation of the data to decision support information.
• Data analysis, providing data insights and trends supporting business growth objectives.
• Identified relationships and opportunities related to growing the customer and products base

Confidential

Contract Consultant

Responsibilities:

• Conducted unit and system testing for the CRM Data Warehouse implementation.
• This involved understanding the data warehouse schema and structure as well as the understanding the bank’s products, business rules and development of inputs from a DB2 Data warehouse using SAS (UNIX and PC) and SQL
• Tested the Data warehouse design, with SQL programs to verify the customer profitability measure