SUMMARY

• Specialist in data warehouses, ETL jobs, analytics and operational reports.
• SQL Server SSAS cube design with many to many fact and dimension mappings.
• Cube optimization using partitions, hierarchies, MDX calculations and aggregations.
• Oracle Financials, SAP Hana, Informatica, MS Azure feeding Tableau and QlikView.
• ETL automation jobs that refresh data warehouses, cubes and corporate websites
• Cloud, SQL Server, Oracle, and SAP driven project analysis and collaborative apps
• Data Mart cube creation, MDX debugging and tuning for most frequent queries
• What - If scenarios, Big Data analysis using Azure virtual machines and AWS Redshift
• DBA Dynamic management views on SQL and Cloud app tuning on NoSQL and AWS
• Java and .NET abstract classes and interfaces that define application architecture
• SaaS Salesforce applications using web services on Python, Apex, SOQL and XML
• Lead by example, motivating members and helping individual performance.
• Led agile projects with daily scrums and weekly meetings with stakeholders.
• Process structure definition and documentation based on industry standards.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Architect

Responsibilities:

• Modifying the core product to enhance its patient history processing algorithms. Working on routines used to identify patients’ insurance plans, groups and member ID's through employers, providers and life events.
• Improving performance by converting many cursor row operations to set based logic.
• Evaluating elastic scaling options when running on AWS Redshift clusters.
• Parsing HIPAA 837 EDI FILES to identify exact coverage profiles in accounts with multiple providers with differing levels of coverage and time spans.

Confidential

Business Intelligence Architect

Responsibilities:

• In charge of designing ETL jobs and the warehouse objects they target.
• Responsible for reports to C-Level executives.
• Accountable for maintaining accurate billable hours on all matters for the firm’s legal services across three continents and several currencies.
• As senior designer, mentored other team members.
• Extensive SSAS cube design and maintenance.
• Responsible for all SSIS packages and stored procedures that keep the data warehouse current.
• Queried ERP systems several times a day to pick up inventory updates.
• Evaluated design options for the cloud PaaS platform.
• AWS and Azure were considered for the new hybrid design.
• Tested some ETL processes on Redshift clusters, spawning them for use, timing the loads and deleting the clusters after use to calculate cost.
• Used AWS DMS to move data to and from our SQL Server. Ported some data to DynamoDB and some to S3 data file buckets depending on its structure or lack of it.

Confidential

Business Intelligence Developer

Responsibilities:

• Development Team-Lead designing and constructing a SQL Server database containing one of Confidential 's inforce models. Designed most of the tables and stored procedures. The work entailed translating numerous SAS programs and datasets, and updating their business logic.This logic groups millions of policies into a smaller number of modeling points based on various attributes, dimensions and actuarial guidelines.
• Additionally, took part in designing Oracle ERP and E-Business processing databases. Automated Confidential 's external file exchanges. Designed dynamic, table driven SQL stored procedures and SSIS allowing easy integration of updates to business rules such as SOX audits and new healthcare requirements.
• Created SSAS cubes based on the Inforce Model where monthly changes could be forecasted. Instructed business users to the use of my cubes via Excel. Modeled the datamarts based on their requirements.
• I increased the performance of the cubes by creating partitions based on dateso only relevant partitions could be queried independently.Also by limiting attribute indexes to just my defined hierarchies.
• Member of Business Intelligence Applications team in charge of maintaining ETL jobs that kept thedata warehouse current. Integrity was essential as data is audited by the Federal Energy Regulatory Commission.
• My responsibility included data used to operate part of the Northeast Electrical Grid and feeds SAS and SAP.
• The team's primary objective was to optimize procedures to leverage newfeatures of SQL Server 2014, which was selected over SAP Hana BW following our extensive assessment of both "in memory" environments.
• DesignedSSAS cubes to consolidate diverse models describing generators into a single data structure that senior management could use to guide future strategies. Used Azure cloud to feed QlikView dashboards showing electricity market bidding, generation and outage management as its main dimensions.
• Designed hierarchies, display foldersthat allowed Tableau and Excel to navigate dimension attributes easily and intuitively. Also indexes and aggregations that produced animation like dashboard refresh rates.

Confidential

Business Intelligence Developer

Responsibilities:

• Manager of BI team in charge of helping functional area analysts organize their workload by automating tasks in preparation for the influx of new accounts due to the merger with Reliant.
• My team converted Operations’ applications and our Business Intelligence infrastructure into a Brand aware model for integration with SAP based Reliant’s Business Objects and SAP BW architecture.
• Responsible for improving metric calculation and storage for major operational processes (Enrollment, Pricing, Invoicing, Rewarding, Customer Service, etc.) making them SOX compliant for SAP Financial audits.
• Identified KPI's by meeting with high level business side SME’s.Managed the northeast Tableau server.
• Created SSIS packages for processing ETL from daily EDI files. Wrote programs that interfaced with Salesforce and SharePoint workflows for tracking tickets between customer service and operations divisions.
• Designed SSAS cubes containing operational data and promotion results that were extrapolated and displayed in Tableau dashboards used in forecasting.
• The cubes were processed nightly using Process Add to load new records into the dimensions. Data updates were performed over the weekend with Process Full.

Confidential

Business Intelligence Developer

Responsibilities:

• Developed SSIS ETL packagesto loadoperational data from OLTP databasesinto OLAP SSAS datamarts and cubes with reports in SSRS and OBIEEand being browsedmostly from Excel, BOBJ and Crystal Reports.
• Dimensions and Facts were pulled from Oracle and Teradata using SSIS. Our packages cleansed and transformed data before loading into our local SQL Server databases for further processing on Informatica.
• Worked with the department's Microsoft SSAS data cubes, dimensions, measures, attributes and hierarchies required by the queries requested. Designed and optimized MDX queries to improve performance.
• Optimized cube processing by careful analysis of the columns used by business queries, removing unused columns. Aggregations were designed only on the KPI related attributes. Used MDX Calculations to generate YTD values, and factless fact tables to simplify cube design and reduce the number of dimensions.
• Created automated dashboards detailing account history, demographics, campaign results, service levels, inventories, ticket statistics etc. using SSRS, Telerik animations and OBIEE dashboards.