SUMMARY:

Confidential

Business Intelligence Architect

• I got to BlueLinx through the Intersect group on a six - month contract to hire premise, they offered me the job permeant right after the final interview, just over 2 years ago ( ) - I accepted.
• Responsible for managing and directing database application development, ETL solutions with SSIS, Tabular, SSAS Cubes, Power BI and SSRS.
• I am working complex Logic for stored procedures and performed performance tuning to queries and stored procedures.
• I architect and created data Marts from an OLTP schema system and converted it to a star and snowflake schemas.
• I have performed complex queries including recursive CTEs, Pivot, correlated queries and Triggers.
• I am creating, designing and architecting SSIS packages for the purposes of ETL populating dimension and Fact tables using complex business logic. Implemented SSIS - checkpoints and handling transactions.
• I am working on OLAP Cubes with SSAS on top of data.
• I am creating Reports using SSRS sourcing from OLAP Cubes, data marts and relational database, relying on stored procedures, SQL Scripts and MDX base codes. Implemented SSRS report snapshots and subscriptions.
• I have designed and implemented tabular Cubes solutions for sales and inventory data, using DAX language for data retrieval.
• I have designed and implemented Power BI reporting on top of Tabular, SSAS Cubes and other sources for distribution and logistics data.
• Architect and model solutions on any Microsoft suite, write stories in Jira assign tasks, manage the standup meetings.
• Meet with the business leaders, business analysts and project managers to acquire feedback and flat-out requirement needs.
• I have designed and implemented Power BI reporting on top of Tabular, SSAS Cubes and other sources for distribution and logistics data.
• Have Inman methodology as an EDW and Kimball as the star and snowflake schemas in place.

Confidential

Data Warehouse Architect

• A Manufacturing Company where I lead a team of SSIS, SQL server, SSAS, SSRS and IBM pure data (Netezza) developers.
• I stand as a mentor, a data warehouse Architect and modeler. I help out hands on with the tasks at hand.
• I am responsible for sourcing data from Lawson M3 ERP systems with DB2 - iSereis databases, Oracle, SQL server, teraData, and flat files into an IBM pure data ( Netezza) system in a Warehouse configuration.
• I model and set the methodologies, schema, structure and concepts of ETL, using Microsoft SSIS, Microsoft and Netezza stored procedures and views.
• I am responsible for reading understanding and communicating the Requirements.
• I am responsible for the Analytic Cube - SSAS.Making the data warehouse available for SSAS cubes, Reporting services LBI (Crystal reports) and tableau.
• I have defined and created from scratch the business processes and sub Processes:
• Procurement: Supplier Quotes, Purchase orders, Delivery, Shipment, Receipts, invoicing, Sub Ledger and General ledger post.
• Sales: Customer Quotes, Customer orders, Customer Delivery, Customer Shipment, Customer Invoicing, Sub Ledger and General ledger post.
• Logistics: Purchase orders delivery and Shipment, Customer orders delivery and Shipment and Distribution orders throughout the whole cycle and organization.
• Inventory: Inventory management, hands on
• Manufacturing: Plants, Locations, Warehouses, Facilities, Divisions, Items or Products.
• CRM.

Confidential

Senior SQL Database developer

• I have created project definitions, user requirement definition, systems requirement definition, analysis, design system build including mockups pilots implementations and Containment.
• I had a database of 2 terra bytes supporting the company s websites, monitoring the databases with ADERA. Worked in a clustered environment - performed backup, restore and recovery of databases, log shipping.
• I have created tables, views, stored procedures, indexes, functions, synonyms and constraints.
• I have created complex stored procedures and performed performance tuning to queries and stored procedures.
• I have architected and created data Marts from an OLTP schema system and converted it to a star and snowflake schemas.
• I have performed complex queries including recursive CTEs, Pivot, correlated queries.
• I have created, designed and architected SSIS packages for the purposes of ETL populating dimension and Fact tables using complex business logic. Implemented SSIS - checkpoints and handling transactions.
• I have created OLAP Cubes with SSAS on top of data marts and implemented SSAS - proactive caching.
• I have created Reports using SSRS sourcing from OLAP Cubes, data marts and relational database, relying on stored procedures, SQL Scripts and MDX base codes. Implemented SSRS - report snapshots and subscriptions
• I have migrated relational and warehouse data from SQL 2005 to SQL 2008 and upgraded SSIS SSAS and SSRS solution.
• I am working in both OLAP and OLTP environments containing various remote servers. My queries involve linked servers. I have validated data - SQL statements that use over 30 joins, self joins, calculations, unions, sums, common table expressions, views and recursions.
• Responsible for replication (merge, transaction) environment on a 2 TERA- byte database with Fail over (Mirroring): remote Distributor, publisher, subscriber for an OLTP system.

Confidential

Senior BI Consultant

• I have designed and architected Data marts (dimension tables and hierarchies, fact tables). Created data bases with partitioning.
• I have created tables, views, stored procedures, indexes, synonyms, constraints, and performed performance tuning to queries.
• Sourced data from Flat files, Tera - data, DB2 and Oracle OLTP schema systems and converted it to a star and snowflake Microsoft SQL schemas.
• I have created, designed and architected SSIS packages (ETL) populating dimension and Fact tables using complex business logic.
• SSIS - I have been using SSIS Packages for ETL purposes - used variables, stored procedures and components like union task, multicast task, lookup task, data conversion task, looping containers, FTP task and many more. Used Fast Export utility to call series of windows Batch files - dynamic batches that use variables, which in turn create batches which contain parameterized queries that are sent to Fast Export as an input to query Teradata. XML Configuration File, package calling derived packages.
• SSAS - I have created cubes that rely on a gigantic Data Marts of 10 terabytes of data that includes load, staging and dimension and fact tables. I have created the dimensions - including role playing dimensions, semi additive dimensions, fact dimensions, measure groups, added calculated measures, DSV views and scope statements. proactive caching.
• SSRS - I have created Reports using SSRS sourcing from OLAP Cubes, data marts and relational database, relying on stored procedures, T-SQL Scripts and MDX base codes. Using Matrix tables, charts and graphs drilldown and drill Through reports - 2005, 2008 and 2008-R2.

Confidential

Senior SQL BI Dev

• I have created maintenance plans, migrated data, and upgraded solution from SQL 2005 to SQL 2008.
• I have created a number of data warehouses using star schema methodology including over 30 dimensions with their hierarchies and 10 fact tables for each warehouse. Implemented slowly changing dimensionscalculated measure groups. Maintained Primary Key, Foreign key integrity within the schema.
• I used SQL, T - SQL, stored Procedures and Functions to cleanse and parse data. I worked with open raw sets and dynamic SQL.
• I have created Microsoft SSIS (Integration services) Packages for the purpose of ETL and used stored
• Procedures within the packages in order to populate the warehouses. Maintained and created a variety of complex packages. Deployed it into package stores and built jobs for scheduling. Used staging databases.
• I have created cubes with SSAS (Analysis services) on top of data marts with roll playing dimensionsSlowly changing dimensions, Fact tables directly from data marts and complex Fact tables views, calculated
• Measures, composite key creation, dimensions based on fact tables and de - normalized dimensions programmatically to get individual member counts. Deployment and maintenance. Hands on MDX scripting knowledge.
• I have created Reports using SSRS (Reporting Services), a Varity of complex reports using data sources both cubes and Relational database, creating data sets both with MDX and SQL or (stored procedures) driven by parameters. Matrix Reports with drill downs and drill thorough by dimensional or cross dimensional hierarchy, incorporated with a large spectrum of charts, gages and graphs. De - normalized dimensions and calculation of ratios. Built complex graphs with Primary and secondary axis's, number of dimensions, number of measures and ratios.
• Responsible for database and server performance monitoring and tuning.

Confidential

SQL BI Dev

• Warehouse and Database Management and maintenance - Dimensional Data Modeling.
• Responsible for managing and directing database application development.
• Responsible for database and server performance monitoring and tuning.
• Responsible for capacity planning and server acquisition requirements.
• Extracted data for the data warehouse from VFP, Excel and flat files OLTP systems.
• Responsible for replication (merge, transaction) environment on a 2 TERA- byte database with Fail over (Mirroring): remote Distributor, publisher, subscriber for an OLTP system.
• Responsible for T-SQL Coding - Data Cleansing, Parsing, database and table architecture. Complex- scripts, Cursors, stored procedures, Functions, Triggers, jobs. Made complex-PK, FK relationship.
• Responsible for Data-Marts implementing both snow flake and star layouts.
• Microsoft SSIS Responsible for Integration services packages, to ETL various OLTP systems to data marts.
• Responsible SSAS for cube creation on top of data marts utilizing Business Intelligence Analysis Services, deployment and maintenance.
• Responsible for SQL server data Mining capability including various prediction algorithms and chart creation.
• Business Objects Report Development - Responsible for Delivering BI with Reporting services environment SSRS, including ad- hoc reporting capability.
• Programmed C-sharp based applications with the .Net 3.5 frame work for the purpose of ETL and Address Correction- (DLL, COM, and ActiveX). Integrated CLR functionality such as UDT objects, constructed as C# classes, within the database. Implemented CLR functions and CLR stored procedures.
• Responsible for best practices and code documentation.

Founder and Manager

Confidential

• Sole DBA on a Data Warehouse project for foreclosure hunters, private groups, real estate agencies, Corporate Financials using Microsoft SQL Server 2000 tools. Providing data on pre-foreclosure and foreclosure properties for mailing purposes. Initial phase of Data Warehouse implemented within six months.
• Managed employees for data entry and property metadata research.
• Performed Data Cleansing, Parsing, and table architecture. Wrote complex- scripts, stored procedures, Functions. Established complex-PK, FK relationship.
• Wrote stored procedures to build aggregation tables and generate various counts. Used excel Pivot tables.
• Created analysis of properties: value plus equity, geographical location (distance from zip center), ethnicity, comparables. For speculation reasons, I added equity aggregations over time.
• Responsible for database and server performance monitoring and tuning within the Data Warehouse. Active participant in all Data Warehouse application architecture decisions.

Confidential

SQL / Java Programmer

• Increased query performance by 30% by engaging table normalization and choosing indexes for clustering.
• Engaged in data cleansing and Parsing, Wrote complex- scripts, stored procedures, functions.
• Designed and maintained an Oracle data warehouse for, manufacturing, collection, inventory, sales systems. De-normalized certain columns for aggregation purposes.
• Loaded warehouse using SQL scripts, functions and stored procedures.
• Designed and wrote a JAVA coded Program that provides ETL capability on flat files; Fetches relevant data Transforms it and loads it to an oracle data warehouse.
• Designed and wrote a JAVA coded Program that fetches data from different Oracle OLTP systems consolidates it and loads it into an OLAP system.
• Created a reporting environment and reports, using a third party, ad hoc tool, like Actuate.
• Responsible for the Systems Development Life Cycle for an Oracle based Order Entry and invoicing system.
• Developed user interface program for report viewing, using JAVA.
• Directed, trained, scheduled tasks, and reviewed the performance of the staff that was responsible for QA development regarding the project at hand.