SUMMARY:

• Proven record of solution design, development, implementation and support of DW and BI applications over a career span of 14 years. Handled diverse responsibilities as an architect, lead and as a senior developer, working both in traditional IT and in pseudo IT teams.
• Consistently delivered high quality BI solutions in organizations of varying information maturity levels. Successful in technical roles as well as customer facing techno functional roles, with ability to drive results via collaboration with cross functional business and IT teams.
• Involved in developing BI blueprints and roadmaps, engineered multiple full life cycle implementations as well as phases of building efficient relational and multidimensional databases, reporting and analytical applications - Adhering to waterfall, iterative and incremental/agile software development methodologies.
• Knowledgeable in enterprise data/information management strategies, application integration, master data management and data governance, big data analytics, on premise, cloud and hybrid platforms, implementation challenges, benefits, techniques and guiding principles.
• Proficient in requirements gathering and translation into technical solutions, BI system architecture, data flow architecture, data profiling/analysis, data mapping, dimensional and multidimensional data modeling, ETL framework, OLAP cube, reporting and dashboard interface design and development.
• Expert experience developing and administering SSIS package workflows involving complex transformations for data transfer between various source and targets - Amazon Cloud, Microsoft Azure, SQL Server, Oracle, DB2, Teradata, Delimited, Excel, XML and JSON files.
• Extensive experience in developing wide range of reports and dashboards using SSRS, modeling, developing multidimensional and tabular SSAS cubes with different storage modes, aggregation designs and processing techniques.
• Expertise developing Power BI dashboards and reports with cloud and on premise data sources.
• Experienced in DW, BI, Big data and cloud solution and tool evaluation, server sizing, capacity planning, performance tuning and optimizing - SQL server, SSIS, SSRS and SSAS.
• Practiced in leading development teams, project and delivery management - Planning and prioritization, task assignment, resource leveling, code reviews, QA coordination, release and support management.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, MDX, DAX, HiveQL, Hive LLAP and Pig Latin

Databases: SQL Server - 2000, 2005, 2008 R2, 2012, 2014, 2016 and Oracle - 9i, 11g, 12c R2

ETL tools: SQL Server - DTS, Integration Services (SSIS) and SAP Data Services

Reporting/Analytics/Visualization: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI 2.0, PerformancePoint, PowerPivot, Power View, Tableau 9.1 and QlikView 11.2

Data Modeling: Visio - 2010, 2013 and ERwin Data Modeler - 7.3, 9.7

Cloud Platform and Big Data tools: Amazon Web Services (AWS) - Elastic Compute Cloud (EC2), Redshift, Microsoft Azure - HDInsight (Ambari, Hive, Pig, Oozie) and IBM Open Platform with Apache Hadoop (BigInsights)

Collaboration: SharePoint Server - 2003, 2007, 2010, 2013 and Office 365

Source Control: Visual SourceSafe 2005 and Team Foundation Server - 2008, 2013

Project Management: Microsoft Project Server - 2010, 2013 and CA Agile Central (Rally)

IDE/Utilities/Client tools: Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT and SSDT-BI), SQL Server Management Studio (SSMS), Teradata SQL Assistant, Oracle SQL Developer, IBM iSeries Access for Windows, ReportsNow Data Access Studio for JD Edwards, Visual Studio, Eclipse, Quest Spotlight, Beeline, Curl and PowerShell ISEERP and CRMSAP ECC 6.0 and SAP CRM 5.0

Programming: C# and Java

PROFESSIONAL EXPERIENCE:

Confidential - Fort Worth, TX

Business Intelligence Solution Architect (Contract)

Responsibilities:

• Developed proof of concepts to implement Microsoft Azure products - SQL Database, HDInsight (Hadoop and Interactive Query). Currently evaluating Data Factory, Data Lake Store, Data Lake Analytics and MongoDB.
• Lead collaborative planning meetings with cross functional business and IT teams to define solution scope, functional and non functional requirements and gap analysis for data integration from GT Nexus (Cloud supply chain platform), PeopleSoft and home grown warehouse management system.
• Designed data flow architecture, modeled data warehouse subject areas and data marts - Purchase orders, invoices, shipments and distribution center receipts.
• Automated SSIS ETL processes - To export customer data to Neustar (Marketing vendor), to import customer loyalty reward points data from Epsilon (Data provider and marketing partner) Oracle data warehouse and to parse and load XML and JSON in SQL server tables.

Tools: and Technologies: SQL Server 2014, T-SQL, SSIS, Microsoft Azure, Oracle 12c R2, MongoDB 3.6, GT Nexus, PeopleSoft 9.2, RabbitMQ 3.7, Redgate SQL Data Generator, CA Agile Central (Rally), ERwin Data Modeler 9.7, Visio 2013 and Team Foundation Server 2013.

Confidential - Fort Worth, TX

Data Architect (Contract)

Responsibilities:

• Evaluated replication, change data capture, mini ETL batch, web services and data virtualization to select optimal methodology depending on reporting and data transfer SLA's between the systems.
• Evaluated enterprise wide data assets and interfaces for sizing and capacity planning of the ODS, data warehouse and data marts, developed hardware specifications (Server sizing and capacity planning) for new platform to be implemented.
• Evaluated PolyBase, SAP Data Services, MuleSoft, Collibra, Presto, Apache Kafka, Azure - Event Hubs, Service Bus, API Management, Data Catalog, Stretch Database and utilizing REST API’s with JSON for data transmission as part of tool selection for near real time data integration and data discovery.
• Partnering with ExxonMobil’s data market place team, developed roadmap to integrate XTO ODS, Data Warehouse and self-service layers to be developed with ExxonMobil’s upstream data analytics framework.
• Developed project plans to onboard operations and production services application databases in to the ODS and to implement intra and inter application integration interfaces for data exchange including Web Services.
• Designed and configured staging and ODS database components for SCADA (Supervisory Control and Data Acquisition), WellView and ProCount systems - Total current data volume of 4 TB uncompressed.
• Developed and implemented SSIS ETL framework to populate ODS with SCADA data in near real time (5 minute latency, Total current data volume of 2.5 TB uncompressed with growth rate of 2.5 - 3 GB per day).

Tools: and Technologies: SQL Server 2014 and 2016, PolyBase, T-SQL, SSIS, SAP Data Services, Apache Kafka, Presto, MuleSoft, Collibra, Microsoft Azure, Microsoft Project Server 2013, Visio 2013 and Quest Spotlight.

Confidential - Nashville, TN

Data Architect (Contract)

Responsibilities:

• Analyzed and documented EDI 837 pharmacy claims transaction set data flow from Pharmacy switch to enterprise cloud data warehouse and standalone applications.
• Profiled claims data sets being routed to commercial payers, Medicare and Medicaid to identify gaps between existing reporting databases and enterprise Rx claims subject area.
• Grouped and prioritized report delivery (108 reports grouped in to 10 parameterized reports based on legacy Perl scripts and C++ programs), sprint and project plan.
• Proposed and finalized interim and long term data flow architecture alternatives, Designed data mart and tabular SSAS cube for providing self-service feature for operations analysts.

Tools: and Technologies: SQL Server 2014, T-SQL, SSAS, Power BI 2.0, Microsoft Project Server 2013, Visio 2013, Talend, Jenkins, JIRA, Confluence, Perl, C++, Red Hat Enterprise Linux 6.8, Amazon Web Services - Redshift and EC2.

Confidential - Atlanta, GA

Business Intelligence Architect (Contract)

Responsibilities:

• Collaborating with the business and IT partners, established delivery road map by prioritizing BI deliverables, guided new infrastructure procurement to replace existing aging infrastructure with new hardware with planned capacity to function as an on premise environment in a hybrid cloud setup.
• Scoped out value adding initiatives by designing and implementing - BI foundation layer for data integration using reusable SSIS ETL framework, Firewall to manage quality of BI data and correcting source systems and Self-service BI portal via SharePoint.
• Introduced iterative development methodology, tools and processes around requirements gathering, development, change management to better streamline projects delivery and support. Developed and maintained project plans for phased rollout of data warehouse and analytics platform implementation and L1 projects for user base of more than 500. Specific projects include:
• WoodOps Operational Analytics: Replacing 8 Access databases, 140 SSRS reports and 11 PowerPivot models developed from ERP, application databases and file data extracts, Designed and implemented SQL server staging databases, data marts and OLAP cubes for gaining valuable insights into wood procurement, transfers and sales of more than 200 mills located throughout the United States and Canada.
• WoodOps Accounting Analytics: Replacing 2 disconnected Power Pivot models and Excel workbooks, Designed and implemented SQL server staging database, data mart and OLAP cube integrating operations and accounting data assets from Infinium Oracle database and home grown DB2 database.
• Benchmarking: Designed and developed an application to sun set manual processes involved in maintaining Access database and Excel workbooks to automate data capture, integration and reporting related to market pricing analysis using SSIS, SSAS writeback cube and SQL server master data services.
• Forecasting: Modeled and developed an application using SSAS writeback cube, sun setting the practice of managing 28 disparate excel workbooks with built in business logic using macros complemented by .NET applications.
• Rabit (Financial Analytics): Designed and developed staging layer in SQL server and ETL routines using SSIS for delta extracts from various relational and file sources for Talend to feed Amazon Web Services S3 buckets in Amazon cloud - Apache Spark running on Hadoop in Amazon EMR, supplying data to Amazon Redshift data warehouse.
• Using Power BI, Built multi page reports with drill down visualizations to present data stories and Dashboards with visualization tiles and Q&A off of on premise operations and accounting SSAS cubes.
• Developed Dynamics CRM Online Power BI dashboards blending OData feed and on premise ERP data sets.
• Created Power BI groups and workspaces by region and line of business and cross functional content packs.
• Developed an interactive Tableau dashboard to monitor BI operational metrics.

Tools: and Technologies: SQL Server 2014, T-SQL, MDX, C#.NET, SSIS, SSAS, SharePoint 2013, Tableau 9.1, Power BI 2.0, Microsoft Dynamics CRM Online, IBM DB2 V7R2M0, Oracle 11g, Visio 2013, Microsoft Project Server 2013, Talend, Amazon Web Services - S3, EMR, Hadoop, Redshift, Apache Spark and Visual SourceSafe 2005.

Confidential - Libertyville, IL

Business Intelligence Architect (Contract)

Responsibilities:

• Proposed and implemented strategy for delivering improved BI platform - Designed architecture including framework for data foundation, ETL, reporting and analytics platforms for Apple Trade In and Buy Back program. Standardized delivery on Microsoft BI platform and QlikView for visualizations in lieu of Cognos.
• Prioritized reporting requirements to accommodate rapidly changing business needs, established liaison between various business and IT teams for improved collaboration, ownership and governance, with emphasis on delivering self service capabilities for business.
• Lead BI system architecture design, functional and nonfunctional requirements sign off, development, testing, migrations and support activities.
• Modeled SQL server data marts for finance, operations and supply chain, designed and implemented ETL framework using SSIS, sourcing data from Apple Point of Sale, Brightstar’s - Reverse Logistics/Reverse Merchandize Authorization System, JD Edwards ERP system and Mobile Phone Exchange system - To analyze returns, inventory, warehouse operations, shipments, sales and marketing campaigns.
• Modeled, developed and optimized multidimensional and tabular SSAS cubes with different storage modes, aggregation designs and processing techniques - Cubes provided end to end visibility of supply chain including near real time tracking of warehouse operations for more than 100 users.
• Improved self-service by creating a SSIS tool which enables users to generate excel ad hoc reports on their own.
• As an alternative to BizTalk server, developed a tool using SSIS which acts as XML parser to consume EDI files.
• Enforced consistent report design patterns by creating SSRS report templates and Introduced Power View in SharePoint integrated mode to further improve self-service adoption.

Tools: and Technologies: SQL Server 2012 and 2008 R2, T-SQL, MDX, SSIS, SSRS, SSAS, SharePoint 2010, ERwin Data Modeler 7.3, Visio 2010, QlikView 11.2, Oracle 11g, Cognos 8, JD Edwards EnterpriseOne 9.1 and Team Foundation Server 2008.

Confidential - Dallas, TX

SSAS Architect (Contract)

Responsibilities:

• Developed SSIS packages using parent-child design pattern to stage data in SQL server, sourcing data from Oracle data mart and SQL server databases. Embedded extensive logging, error handling, notifications and recoverability capabilities in ETL to enable application supportability and to hand over to maintenance and support team.
• Delivered exceptional improvement in data load and cube processing times by designing and implementing delta loads and incremental cube refresh cycles - 40 minutes with the new design vs 4 hours.
• Remodeled SSAS OLAP cube with additional dimensions and attributes. Optimized dimensions, added new cube level calculations and KPI’s using MDX.
• Improved query response times by implementing measure group partitions and aggregation redesign.
• Redesigned ETL workflow embedded in SQL agent jobs to enable Tivoli scheduler to run SSIS packages.
• Developed SSRS reports to monitor application usage, SSIS and SSAS logs and Tableau dashboards to analyze flight threats, errors and incidents.

Tools: and Technologies: SQL Server 2008 R2, T-SQL, MDX, SSIS, SSRS, SSAS, Oracle 11g and Tableau 8.0.

Confidential - Fort Worth, TX

Senior SQL Developer/Architect (Contract)

Responsibilities:

• Architected SSIS ETL framework to control daily data loads via an on premise SQL server instance to import data from Google’s DoubleClick FTP server in to SQL server staging area in Amazon’s EC2 cloud instance and to import processed data into on premise SQL server data warehouse via FTP server.
• Automated ETL workflow using SQL server agent jobs utilizing Amazon’s Java API, batch files and T-SQL scripts.
• Enhanced the application with health monitoring capabilities during SQL server instance uptime in the cloud.
• Eliminating the need for client specific SSIS data loader packages, developed a SSIS package that acts as a generic data loader to extract data from data warehouse, loading staging area for MicroStrategy reporting interface.

Tools: and Technologies: SQL Server 2008 R2, T-SQL, SSIS and MicroStrategy 9.2.

Confidential - Roanoke, VA

Developer Advisor

Responsibilities:

• Customer segmentation - Modeled and designed data mart and SSAS cube, developed - PowerPivot reports, scorecards using PerformancePoint server dashboard designer, SSIS packages extracting data from Teradata EDW.
• Corporate marketing data mart - Developed SSIS packages to load staging, fact and dimension tables, developed utility for hash key validations for all dimension and fact table loads for verifying change data capture. Enhanced subject areas with new attributes and metrics, tested and supported data mart in production.
• Enterprise email integration database - Developed and maintained SSIS processes to load email database serving as an enterprise wide repository of Confidential ’s customer email addresses. Developed and maintained reports and dashboards off of the database using SSRS, Excel and publishing them on SharePoint.
• Other projects - Developed SSIS processes to procure market intelligence data from external partners and also to supply campaign data to external partners for execution.

Tools: and Technologies: SQL Server 2005/2008 R2, T-SQL, MDX, SSIS, SSRS, SSAS, PowerPivot, SharePoint 2007, Visio 2010, Teradata 13.1 and MicroStrategy 9.2.

Confidential - Brookings, SD

Business Intelligence Consultant (Contract)

Responsibilities:

• Profiled source systems for data availability and data quality, documenting data mapping rules and modeled data marts. Designed template audit database, used built in SSIS control flow, data flow and event handler components which act as wrappers inside SSIS packages to populate audit database tables.
• Designed SSRS report templates, implemented interactive sorting and cascading parameters.
• Developed and deployed SSRS reports - matrix drill down reports, modified reports with static and dynamic columns, calculated columns and functions using MDX.
• Used parameterized MDX queries for generating reports from cubes developed using SSAS, developed visual tools for displaying KPI’s in the form of digital dashboards with gauges.
• Created report models for ad hoc reporting to assist nontechnical users, used report builder to build reports off of report model, trained users on SSRS report wizard to create ad hoc tabular and matrix reports with parameters, subtotals and drilldown.

Tools: and Technologies: SQL Server 2005, T-SQL, MDX, SSIS, SSRS and SSAS.

Confidential - Omaha, NE

Business Intelligence Developer (Contract)

Responsibilities:

• Developed complex stored procedures and queries to source SSRS report datasets.
• Developed variety of tabular, matrix, list reports. Used expressions, advanced features like nested sub reports with drill down, document maps and bookmarks for navigation and linked reports.
• Developed chart reports with multiple series, secondary value axis and series group, pie chart reports with 3D effect with stacked columns, created freeform SSRS reports using list template and expressions, chart reports with report parameters and sub reports.
• Developed SSRS dashboard report with gauges using parameterized MDX query incorporating KPI's and nested data regions. Administered SSRS security, report history, managed subscriptions, enabled report caching and execution snapshots for enhancing reports performance.
• Supported ad hoc reporting needs using SSRS by developing report model, developed reports with parameters using report wizard and report builder, Deployed SSRS reports to SharePoint document library.

Tools: and Technologies: SQL Server 2005, T-SQL, MDX, SSRS and SharePoint 2007.

Confidential - San Francisco, CA

ETL Developer (Contract)

Responsibilities:

• Involved in building data warehouse and data marts to support reporting and analytics by developing data flow architecture consisting of normalized and dimensional data stores.
• Modeled normalized database, documented data hierarchies, source system mapping, transformations and data quality rules. Developed prototype ETL packages using SSIS to extract data from relational systems and file sources for finalizing data transformation technique and approach.
• Created database structures by subject area, views, summary tables and metadata tables.
• Developed SSIS packages for incremental and full extracts to stage from text files, excel files and other relational databases - to load normalized data store, dimension tables with support updates and history tracking-Slowly changing dimensions of type 1 and type 2 and fact tables.
• Tested daily workflow processes, data leakages during ETL run, recoverability for protecting data loss, initial data load and subsequent delta data loads. Documented deployment and user manuals and participated in production migration activities.

Tools: and Technologies: SQL Server 2005 and T-SQL.

Confidential - Draper, UT

Data Warehouse Developer (Contract)

Responsibilities:

• Profiled data in various operational systems for data quality and to identify gaps.
• Developed views, stored procedures and functions that facilitate ETL process to load stage and data into dimension and fact tables. Documented source to target mappings and transformations and developed ETL packages using SSIS to load data warehouse.
• Extended SSAS data source view with named queries and calculations to customize OLAP cubes dimensions and measure groups. Developed and maintained SSRS reports and charts to compare revenue numbers and to track progress towards set revenue goals.
• Developed and deployed scorecard in SharePoint portal to provide key performance metrics related to customer service. Developed prototype SSAS cube using enhanced logical model for segmenting customers.

Tools: and Technologies: SQL Server 2000, T-SQL, SSRS, SSAS and SharePoint 2003.

Confidential

Programmer Analyst

Responsibilities:

• Developed T-SQL scripts, views, stored procedures, triggers and DTS packages to import data from files and OLEDB sources in to SQL Server.
• Maintained indexes, Enhanced and optimized query performance using performance monitor and SQL profiler.
• Documented validation rules and data mapping and tested the data loads to populate tables.
• Automated archiving and purging tasks, Scheduled and monitored SQL agent jobs for data loads.

Tools: and Technologies: SQL Server 2000, T-SQL, PL/SQL, DTS and Oracle 9i.