SUMMARY:

• Confidential is a BI Architect/Developer.
• He has a Bachelor of Science degree in Computer Engineering and a Master’s degree in Computer Science.
• He also has several industry s.
• With over 12 years of IT experience, Confidential specializes in Architecture, Design and Development of BI & Analytics, Systems/Data Integration & Conversion Processes, Data Warehousing, Enterprise Reporting Solutions, Big Data Technologies and Custom Application Development.
• Confidential has designed and developed BI and Data Integration solutions for clients that address critical business needs across numerous platforms and corporate environments.
• As a seasoned BI architect & developer, he has inspired and led both clients and fellow team developers to turn abstract concepts, problems, and other ideas into tangible solutions.
• Confidential leverages this passion and a wealth of past experiences and the knowledge of other thought leaders in this space to create solutions that consistently exceed the expectations of his clients.
• His client list includes multiple Fortune 1000 companies across Financial Services, Healthcare Services, Home Builder, Manufacturing, Retail, and al Services Industries.

TECHNOLOGIES:

Relational Databases: SQL Server 2000/2005/2008/2012 Database, Oracle 10g Database, T - SQL, DB Visualizer, Toad, PL/SQL, Microsoft Access, My SQL, 3NF Database Modeling, Azure SQL Database

ETL: Integration Services (SSIS), IBM Datastage, Informatica, SAP BOBJ Data Services, Power Query, PowerShell, Hive

Multidimensional Databases/Platform: Analysis Services OLAP Cubes (SSAS), MDX, Microsoft Master Data Management (MDM), Oracle OBIEE, Microsoft Parallel Data Warehouse Appliance, IBM Neteeza Big Data Appliance, Erwin, Visio, Dimensional Modeling, Power BI, Power Pivot, HDInsight, Apache Hadoop Clusters

Report Development: SQL Server 2005/2008/2010 Reporting Services (SSRS),Power BI, Power View, Azure Reporting Services, Microsoft Frx, Tableau, Targit

Development Platform: Business Intelligence Development Studio, C#.NET, VB .NET, XML, ADO.NET, .NET Framework, Microsoft Azure Development Framework, Visual Basic for Applications (VBA), Microsoft Access, LLBL Gen Pro Object Relational(O/R) Mapper, SharePoint.

ERP: Microsoft Dynamics CRM, Microsoft Dynamics GP (Great Plains), SAP, Lawson, JD Edwards, PowerCAMPUS, PowerFAIDS

Functional Technical Expertise: Business Intelligence Architecture and Development, Extract Transform and Load (ETL), ERP System Conversion, Custom Application Development.

Industry Expertise: Retail, Financial Services, Healthcare Services, Home Builder, and al Services Industries.

Other Skills: Strong Documentation Skills; Rightly Energetic; Customer Oriented and a Motivated Team Player.

CONSULTING EXPERIENCE:

Confidential, Forth Worth, TX

Lead Data/BI Consultant

Responsibilities:

• Client is a Global Retail Leader in large scale home furnishings and accessories with foreign designs. They have over 1,000 stores in the United States, Canada and Mexico.
• Responsible for the development, enhancement and management of Enterprise Data Warehouse processes and policies, following strategic direction on best practices for holistic Data Architecture and to support enhanced Customer Master Data Profiling and Segmentation process.
• Served as a lead architect and developer in Designing, Develop, and Implementing MS SQL Server based ETL frameworks and jobs to effectively process High-Volume data sources to meet nightly processing windows.
• Designed and Developed efficient data integration processes and business logics to support the marketing team in implementation of Custom Master Data and Segmentation solutions.
• Worked with IT and Business users to help implement solid, extensible warehouse models that supported new analytic requirements using the most relevant techniques.
• Solutions provided client with a much more efficient and faster data loading process. It also provided client with a more enriched and accurate customer data profiling and segmentation process.

Technologies: SQL Server 2014 & 2012 Relational Databases, SQL Server 2014, 2012 & 2008 Integration Services, Stored Procedures, Oracle, Big Data Analytics, Microsoft Azure Database, Azure HD Insight, Hadoop Clusters, Map Reduce, Hive, PowerShell

Confidential, Minneapolis, MN

BI Architect/Developer

Responsibilities:

• Client is a Global Leader in Energy, Food & Beverage, Industrial & Infrastructure, Residential & Commercial products and services for clients worldwide.
• Projects involves extracting data from JD Edwards ERP system integrating with other data using ETL processes, Transforming and Loading the data into a Data Warehouse for consumption by Cognos cubes & reports for Sales and Forecast reporting initiatives.
• Serves as the lead architect and developer for the overall analysis, architecture, design and development of the enterprise data warehouse and business Intelligence solutions for the project.
• Collaborate with business users to translate business requirements into functional specifications.
• Design and develop ETL processes using MS SQL Server 2012 Stored Procedures and SSIS for loading data into a Data warehouse and/or Data-marts.
• Design and develop logical and physical relational and multidimensional data models utilized for all aspects of the projects.
• Solution provided an alternative to an existing inefficient and hard to maintain Data Warehouse framework to an easily maintainable data model and framework that provides faster access and up to date enterprise view of the company’s overall Sales and Forecast data.

Technologies: SQL Server 2012 Relational Databases, SQL Server 2012 Integration Services (SSIS), SQL Server 2012, T-SQL, SQL Server Data Tools, JD Edwards.

Confidential, Dallas, TX

BI / CRM Consultant

Responsibilities:

• Extract data from Microsoft Dynamics CRM systems integrating with other data using ETL processes, Transforming and Loading the data into a Data Warehouse and OLAP cubes for several enterprise reporting initiatives.
• Implementation and data integration processes into Dynamics CRM.
• Design and develop strategic Dashboards & Reports with PowerBI & SSRS Reports integrating Microsoft Dynamics CRM data with other enterprise data.
• Collaborate with business users to translate business requirements into functional specifications.
• Configurations, Customization and features Extension implementation for Microsoft Dynamics CRM such as Workflow creation, Business Process design and development, Forms creation, creating relationships, client-side form and data updates / customization using Jscript, Plug-ins implementation etc.

Technologies: Microsoft Dynamics CRM 2013 & 2011, Jscript, C#.NET, SQL Server 2008R2 Relational Databases, SQL Server 2008R2 Integration Services (SSIS), SQL Server 2008R2 Analysis Services (SSAS), SQL Server 2008 Reporting Services (SSRS), PowerBI, T-SQL.

Confidential, Dallas, TX

BI Architect/Developer

Responsibilities:

• Client manufactures and maintains rail cars for several customers in US and Canada.
• Projects involves extracting data from legacy systems integrating with other structured data using ETL processes, Transforming and Loading the data into a Data Warehouse and OLAP cubes for several enterprise reporting initiatives.
• Serves as a lead architect and developer for the overall analysis, architecture, design and development of the enterprise data warehouse and business Intelligence solutions for each of the projects.
• Collaborate with business users to translate business requirements into functional specifications.
• Design, creation and enhancement of SSAS OLAP Cubes to facilitate enterprise reporting and decision making.
• Design and develop ETL processes using MS SQL Server 2008 SSIS for loading data into a Data warehouse and/or Data-marts.
• Design and develop logical and physical relational and multidimensional data models utilized for all aspects of the projects.
• Implementation and data integration processes to Dynamics CRM.
• Solution provided up to date enterprise view of the company’s overall business operations.

Technologies: SQL Server 2008R2 Relational Databases, SQL Server 2008R2 Integration Services (SSIS), SQL Server 2008R2 Analysis Services (SSAS), SQL Server 2008 Reporting Services (SSRS), T-SQL, Microsoft Dynamics CRM 2013, MDX, Visual Studio Business Intelligence Development Studio, Visio.

Confidential, Dallas, TX

Big Data Analytics & Cloud Services Consultant

Responsibilities:

• Provide consulting services around Big Data Analytics & Cloud solutions that provide actionable intelligence.
• Implemented cost effective and scalable Microsoft Azure Cloud distributed platform integration with an on premise Microsoft Dynamics CRM Data Warehouse system to analyze marketing and sales data and provide reports and dashboards that were used for improving marketing campaigns targeting and efficiency.
• Work closely with the sales / marketing team in helping to develop several lead nurturing and email campaign strategies that span across various lead generation medium, including paid search, organic search, direct mail, email and social media.

Technologies: Microsoft Azure Cloud infrastructure, HD Insight, Hadoop Clusters, Map Reduce, Hive, PowerShell, Azure SQL Server, SQL Server 2012, SSAS, SSIS, Azure Blob storage, Azure Tables, Azure Reporting Services, Power Query, Power Pivot, Power View, Big Data Analytics, Cloud Computing, Microsoft Dynamics CRM 2011 & 2013.

Confidential, Irvine, CA

Solution Architect

Responsibilities:

• Role involves overall gathering requirements from clients, architecting, analyzing and designing a reporting solution for delivering Incentive Compensation plans for the Wealth Market Specialists group at the Bank and a collateral management system for the risk management group of the bank.
• Designs implemented included translating complex business rules for the incentive compensation plans into a custom and easily maintainable rule engine.
• Designed ETL solutions for extracting, transforming and consolidating data from several data sources across the enterprise into a centralized repository for the reporting engine.
• Designed logical and physical data models utilized for the ETL and reports.

Technologies: SQL Server 2008 R2 Databases, SSAS, SSIS, SSRS, Informatica ETL Tool, Ms Visio, Business Objects, Oracle Databases.

Confidential, Irving, TX

Lead ETL Architect/Developer

Responsibilities:

• Role involves architecting, designing, developing and implementing ETL solutions for the Global Management Reporting project across multiple regions.
• Business areas involved in include Product & Customer Hierarchy implementations for Global Financial Reporting and Forecast & Budgeting.
• Extracted data from multiple sources including SAP, MDM solution, Essbase, Enterprise Product Hierarchy system, Text Files and several others from multiple regions.

Technologies: Neteeza Big Data appliance, Neteeza workbench, Neteeza Databases, SQL Server 2008 R2 Databases, ErWin, SAP BOBJ Data Services, Visio.

Confidential, Atlanta, GA

ETL Architect

Responsibilities:

• Project involved Implementation of Finance and Procure & Spend Oracle BI Analytical and Reporting solutions with a minimal-customization, out-of-the-box approach.
• The financial analytics aspect of the project focused on G/L and A/P profitability.
• Role involved serving as a lead ETL Architect for all aspects of the project.
• Data was extracted from Microsoft Dynamics Great Plains, Essbase and custom Procurement & Spend systems.
• Solution provided client with enhanced organizational capabilities and faster business decision making aptitudes by providing data acquisition, reporting and dashboards on a single platform (OBIEE). It also provided the ability to see pre-defined metrics, standards and reports that were not available.

Technologies: OBIEE, SQL Server 2008, SSIS, Microsoft Dynamics GP, Essbase, Custom Procurement and Spend App, Oracle 10g Databases, Informatica ETL tool, T-SQL, Excel, Visual Studio, Business Intelligence Development Studio.

Confidential, Forth worth, TX

Business Intelligence Data Analyst/ETL Developer

Responsibilities:

• Client provides specialty financial services to individuals primarily in the United States and Mexico.
• Role involved defining, designing, developing and implementing solutions to validate and support key approved metrics and top management /operational reports for the client.
• Role was with primary focus of analyzing the underlying data and processes utilized by the reports, draw conclusions, and make recommendations for process and strategy changes in support of the BI department mission to maximize sales and minimize losses.
• Developed, implemented and supported a standardized data analysis framework for the BI group, with a goal of supporting and enhancing analysis as an on-going function of the business.
• Designed and developed ETL processes using Datastage for loading data into an EDW and as part of the data analysis process.

Technologies: Oracle 10g Databases, Datastage ETL tool, DB Visualizer, Toad, PL/SQL, T-SQL, Excel, Visual Studio Business Intelligence Development Studio.

Confidential, Houston, TX

Solution Architect/ BI Developer

Responsibilities:

• Client provides energy services, water services and paper services for refineries and other industrial applications.
• Project involved loading and transforming transaction, customer and material hierarchy data from SAP into a data warehouse and building a reliable hierarchy structures in OLAP Cube for reporting purposes. It also involved loading other dependent data from other sources required for calculating various complex business metrics.
• Served as the lead architect for the overall analysis, architecture, design and development of the enterprise data warehouse, Data-marts, SSAS cubes and business intelligence solutions.
• Designed and developed ETL processes using MS SQL Server 2008 SSIS for loading data into a Data warehouse and/or Data-marts.
• Worked with other team members to design and develop analytics/reporting solutions using SSAS and PerformancePoint and developed complex business metrics and components required for the dashboard and reporting solutions.
• Provided time estimates for technical components of project implementations.
• Collaborated with business users to translate business requirements into functional specifications.
• Solution provided a great enhancement to the company’s overall business decision making process.

Technologies: SQL Server 2008 Relational Databases, SQL Server 2008 Integration Services (SSIS), SQL Server 2008 Integration Services (SSAS), SQL Server 2008 Reporting Services (SSRS), T-SQL, MDX, Visual Studio Business Intelligence Development Studio, Visio, ErWin.