TECHNICAL SKILLS

• SSRS: Building SSRS Reports, Charts, Metrics.
• SSIS: ETL data from MS Access, EXCEL, Oracle, AS/400 DB2 databases, etc. for building Data Marts used in reporting.
• SSAS: Some experience maintaining and modifying existing cubes.
• MS Power Query, Power Pivot experience, and Power BI Dashboards development.
• Tableau 10 for KPIs, Reports and Dashboards.
• TIBCO Spotfire for dashboards and KIPs.
• MS Access Programming & Reporting - Tables, Modules, Queries, User Input Interfaces, ADO (queries in VBA code).
• IBM AS/400 Mid-Range Systems programming & DB2 databases reporting.
• Building Data Dictionaries.
• MS Visual Studio 2005/ 2008/2010/2012 (BIDS 2008/2010/2012 ).
• Visio process analysis flow charting, ER Diagrams, and report documentation.
• Oracle SQL Developer
• T-SQL, DB2 SQL, PL SQL, Teradata

PROFESSIONAL EXPERIENCE

Reporting Analyst/Programmer

Confidential, Saint Louis Park, MN

Responsibilities:

• 6 month contract working for Ditech RMS (Reverse Mortgage Systems)
• Created new and maintained existing SSRS reports,
• Power Query data extracts used to build and maintain KPI metrics in EXCEL spreadsheets.
• Created and maintained Power Pivot reports, Power BI Dashboards, and Tableau 10 Dashboards.

Reporting Analyst/Programmer

Confidential, Suwanee, GA

Responsibilities:

• BI Confidential for IHI E&C an oil & gas EPC (Engineering, Procurement, Construction) company.
• Responsible for project SSRS reporting & dashboard development.
• SQL Server 2008/2012, Reporting Services (SSRS),
• Power Query for KPIs,
• Used Spotfire to deliver small reports, dashboards, and KPIs.
• Created Power BI Dashboards and Tableau 9 Dashboards for IT use only.
• Maintained Oracle Packages previously created for older reports.
• Built SSIS packages for data extraction on newer reports.
• Visio flowchart documentation for existing and newer reports.
• Achievements include building a large scale procurement dashboard that drills though to the PO level and tracks the timely delivery of materials to the construction site and helps to mitigate work stoppage due to timing issues.

BI Metrics & Reporting Analyst/Programmer

Confidential, Plano, TX

Responsibilities:

• Full time employee at Dell as a Metrics & Reporting Senior Analyst.
• me was hired by Dell to work wif Credant Data Encryption Technologies company that was acquired by Dell in December 2012.
• MS BI Stack Reporting (SSRS, SSIS) and Analysis at all levels as requested by senior management.
• Integration of reports between Credant legacy systems and current Dell reporting systems.
• Bridged Credant systems wif Dell using SQL Server Data-marts to Dell Oracle and Teradata systems.
• Create homogeneous reporting landscape between Credant and Dell systems.
• After integration me provide business dashboards created wif SSRS.
• Data modeling, trending and analysis to help govern the new business model.

Technical Consultant

Confidential, Houston, TX

Responsibilities:

• BI Consultant for Confidential working for Confidential Energy Oil & Gas Software.
• Prepared for a software product install onto the Exxon\XTO systems in downtown Fort Worth.
• As part of the installation team gathering requirements (JAD sessions) prior to the software installation.
• Contract assignment for 6 months as a Data Developer & Reporting Analyst
• Provided reporting for their Fraud and Collections departments.
• me installed SQL Server 2008 and brought Reporting Services portal on-line for publishing SSRS reports.
• Configured report server wif SMTP so that automated scheduled reports could be sent out via email.
• Created new dashboard reports and converted existing reports.

Confidential, Dallas, TX

Senior Audience Data Architect.

Responsibilities:

• BI (Business Intelligence) developer building data models from OLTP data (Oracle).
• Create and send daily email reports, metrics.
• Perform calculations on circulation data that helps us react quickly to trending data wifin a 24 hour window.
• Automated and replaced 6 manual reporting positions and streamlined the process by installing a local SSRS report server.
• Contract position through Otterbase consulting as a Reporting Analyst and Database Programmer.
• Created SSRS reports that provided tracking of contracted freight transportation globally.
• Creating and modifying complex reports using SQL Server Reporting Services (SSRS) and Oracle SQL.
• Some reports are used by various departments for in-house and others are delivered to client sites.
• Also perform data extracts as requested.
• me also create some stored procedures for optimization and reduce report run time.

Reporting Analyst

Confidential, Irving TX

Responsibilities:

• Contract position through Comsys/Man Power as a Reporting Analyst and Database Programmer.
• Extracted data from MS Access, MS SQL Server and Oracle databases.
• Created home lending SSRS reports for management.
• Created and modified MS Access queries and programs using VBA.
• Created some simple ad hoc reports and some complex data extractions wif SQL Server Reporting Services (SSRS) or Access queries to Excel spreadsheets and created pivot tables, metrics, and KPIs.

Technical Support

Confidential, Waxahachie, TX

Responsibilities:

• Fulltime position as a Technical support and database developer for Walgreens Distribution Center.
• Duties include creating and maintaining MS Access database applications and reporting.
• Create productivity reports for logistics managers using SSRS and Stored Procedures.
• Performed data extractions from the IBM AS/400 DB2 tables via ODBC connections.
• Other programming duties include writing and maintaining queries on the IBM AS/400.
• Created SSRS reports to help them maintain picking rates and product movement wifin the warehouse.