Experience

• 

  The Sharper Image

  • Farmington Hills, MI

  • Sr.Data Warehouse/BI Developer

    • Feb 2014 - Present
    • Farmington Hills, MI

    • Architected the entire EDW Architecture right from the source systems through Landing and Staging the data within Postgres Amazon RDS. • Responsible for all the daily, weekly and monthly operational reporting at Sharperimage. • Currently using Pentaho’s open source Business Intelligence Suite to drive business analytics.• Comprehensive operational and management reporting migration from Python to Pentaho.• Architecture design, installation and setup of the Pentaho Data Integration server and patching.• Working directly with the business team to develop both the logical and physical database administration functions and also assisted in the development of data logistics environment.• Implemented a disaster recovery and execution plan.• Designed, Implemented and maintained high availability solutions with particular focus on database replication within Amazon RDS environment.• Carrying out Data Modelling for both OLTP and Data Warehousing applications.• Working with custom script languages such as python, Javascript for custom applications.• Carrying out PostgreSQL performance Tuning, High Availability, Backup and restore and other general DBA tasks.• Developed complex stored procedures to incorporate all the business rules that are executed by the Pentaho.

• 

  CSC

  • Rochester Hills, Michigan

  • EDW Professional Applications Engineer

    • Feb 2012 - Jan 2014
    • Rochester Hills, Michigan

    •Worked on the Data Acquisition and Version Engine (DAVE) backend development; DAVE loaded data from a very large number of source tables to a very large number of target tables. This engine was being built on the SQL Server platform and the .NET Frame work environment; it contained the metadata and processes that controlled all of the data movement in the proposed entire Henry Ford Health System EDW environment. •I designed and implemented dynamic SSIS packages that read schema, columns, constraints, tables, database information using the Information Schema Views in SQL Server. All these information was imported into the ETL meta data database to allow automated Landing and Staging of Source system data, automated schema change audits and automated data audits, load process logging etc. •Using the primary keys and an MD5 hash value for the first 500 Million records in the Source tables and comparing those records with the current record set in the PSA, I designed and implemented a dynamic SSIS package that did the comparison between the different Source tables and PSA tables and any missing records or missing updates to the existing records were logged for review. •Developed Stored Procedures, Functions (UFD), Views and Triggers to enforce the business rules.•Setup Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.•Experience in Utilizing ETL Tools including SSIS, DTS, Informatica and IBI-Iway..•Used iWay Service Manager (iSM) to automate and schedule the extraction of payroll and GL data from the Epsi Cost Manager database into pipe delimited files that were sent to Allscripts either bi-weekly or monthly. •In order to standardize patient’s claims across the Henry Ford Health System enterprise, I ran multiple data profiles to determine the masking of claims data that was extracted from the different source systems into the Enterprise Data Warehouse.

• 

  Siemens PLM Software

  • Troy, Michigan

  • Business Intelligence Consultant

    • May 2011 - Jan 2012
    • Troy, Michigan

    • Performed complex adhoc SQL and MDX queries when immediate data access was required.• Developed and implemented Cube reports using SSRS 2008 that were integrated with context data from the different source systems using the lookup function; these reports acted as a monthly score cards that defined the quality of the vehicle at a plant in a body shop over a period of time.• Provided end user training to educate business users on how to use Power Pivot functionality for Self Service Business Intelligence. • Worked on the migration of the Report Server from SQL Server 2008 to SQL Server 2008 R2 in the DPV testing lab before the production team could do the migration in the production environment; this was done to ensure minimal business interruption.• Implemented and documented the required procedures for extracting statistical measurement data out of the GMNA cubes for the monthly DPV cross cube reports.• Developed, tested, secured, scheduled and maintained SSIS packages that imported data from the different GM source systems (SQL Server, Oracle, Excel Source files, flat files, XML) into the Plant Cubes for daily, quarterly and monthly dimensional quality reporting.• Providing 24*7 on-call support for the Critical issues.• Using various SSIS tasks such as Lookup, Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then load the data into Plant Cubes.

• 

  Blue Cross Blue Shield of Michigan

  • Detroit, Michigan

  • Systems Data Analyst

    • Apr 2010 - Apr 2011
    • Detroit, Michigan

    • Worked on the Early Retiree Reinsurance Program Data Feeds which was part of the National Health Care Reform, a long term project providing medical and Pharmacy claims data feeds to eligible groups that wished to participate in this program upon request where they submitted claims to the U.S Department of Health and Human Services for reimbursement in addition to subsequent payouts from HHS. This program allowed plan sponsors of an employment-based health plan to get reimbursed for some of the health care costs incurred by pre-Medicare retirees age 55 to 64 and their dependents.• Extracted claims data from the Enterprise Data Warehouse (EDW) into delimited text files that were imported into SQL Server tables using SQL Server Integration Services for quality review to make sure that field names were well aligned with the expected data values.• Extracted data from a variety of SQL environments (e.g. MS SQL Server, Oracle, DB2) for internal business use or transfer to external vendors.• Wrote complex SQL, SAS and/or Access queries.• I performed analysis on medical and pharmacy claims data. Developed in-depth understanding of a variety of Medicare Advantage files, both their technical design and the meaning of fields and values within these fields.• Worked closely with business stakeholders to understand business requirements, developed technical solution to meet business needs both for short-term, ad-hoc and longer-term strategic projects.

• 

  MTN Uganda

  • kampala, Uganda

  • Senior Business Intelligence Analyst

    • Sep 2007 - Jan 2009
    • kampala, Uganda

    • Implemented custom and adhoc reports to support four major telecom business areas: Marketing, Sales, Customer Care and Finance.• Conducted requirements and documented business needs through meetings with business clients.• Obtained feedback and signed off on user requirements document.• Implemented and tested technical solutions against user requirements.• Passed solutions to User Acceptance Team.• Implemented Audit reports to compare operational transaction data to overrides from call center to detect fraud.• Implemented and managed reports to perform daily audit, balance and control testing between source systems and the Ericsson Data Warehouse; when solution failed to balance, proactively identified the missing files from the billing team and initiated recovery by making sure that Call Data Records (CDR) files were reloaded in the data warehouse by the rerunning the ETL applications so that to meet the expected monthly revenue.• Tracked and ensured service levels were met for Data Warehouse and centralized reporting system availability.• Performed ETL work to load Call Data Records (CDR files), Mobile Switching Center (MSC files) files, SDP (Service Data Point files) files, AIR files into the Ericsson Data Warehouse using SQL*Loader for daily, weekly and monthly subscriber activity reporting.• Interacted with all levels of management to define and clarify requested reports. • Developed SQL, PL/SQL packages, procedures and functions using PL/SQL Developer, Toad, SQL Server Management Studio that were used in reports requested by Sales, Marketing, Customer Care, and Finance departments.• Spear headed the upgrade of the Ericsson Data Warehouse from Charging System 3.0 (CS) to CS 4.0, also worked with Ericsson on all user acceptances testing for the data warehouse.