We provide IT Staff Augmentation Services!

Sr. Consultant Resume

3.00/5 (Submit Your Rating)

Maplewood, MO

TECHNICAL SKILLS:

Oracle, Teradata, SSIS, Dashboard Reporting, Crystal Reports, Business Intelligence, Data Integration, Microsoft Reporting Services, Toad, data analysis, Oracle OEM, Excel, Word, Access, IIS Server, PowerPoint, Active Directory, Visio, Informatica, Firework, Dream Weaver, Master Data Management, SAP, AS400, JDE, Visual Basic.Net, JavaScript, Microsoft IIS server, ETL, DEMIS, ESRI, SDLC, Software Implementation, Mobile Work Force Software, Field Force Software, Database Architecture and Design.

PROFESSIONAL EXPERIENCE:

Confidential, Maplewood, MO

Sr. Consultant

Responsibilities:

  • Design data quality processes and resolve all resource efficiency issues.
  • Act as liaison between business analyst, product developers and upper management to support software upgrades and issue resolution.
  • Design and developed PLSQL Packages/Procedures/Functions to populate data into BI tables.
  • Work with DBAs and prepare improvement plans for various database performances.
  • Provide assistance to end users and resolve all queries for data extraction and to generate appropriate reports.
  • Performed data integration using Teradata and Oracle RDBMS
  • Prepare designs and manage customer data load.

Confidential, Needham, MA

Application Architect

Responsibilities:

  • Use Oracle PLSQL to facilitate ETL process between Servigistics applications and client OLTP systems.
  • Lead the analysis and documentation of customer requirements and contributes to the design and build of the Solution(s).
  • Document and tracked product issues and insure resolution by internal development team.
  • Configured and implemented Confidential ’s Servigistics Service Lifecycle Management software and acted as the SME for external customers.
  • Lead the development of Intellicus Business Intelligence & Analytics Platform reports
  • Supported the development of written specifications (e.g. System Description Documents and Use Case Documents) to capture business process requirements for Confidential solutions.
  • Assigned tasks to project members and reviews the team’s work products to ensure that they are accurate and consistent.
  • Mapped customer processes to the technology through a solid understanding of both Confidential ’s software capabilities and the designed usage of the software.
  • Lead and build consensus across the Confidential and client account team members.

Confidential, Alpharetta, GA

Project Manager/Sr. Consultant

Responsibilities:

  • Lead implementation of Field Force Management, Outage Management, Work Force Management, Asset management and Asset Healthcare FocalPoint data warehouse analytical dashboards for Energy Distribution Organizations.
  • Participated and prepared for agile team meetings to design and develop additional functionality for core product.
  • Owned development of product strategy for the Vehicle Adherence application.
  • Designed and developed data integration ETL from client’s source system to ABB’s business intelligence model using a combination of packages, procedures and triggers.
  • Developed functional design documentation and then coordinated efforts with in - house employees to ensure success delivery according to client’s specifications.
  • Provided training to end users on Dashboard Reporting and Data Warehouse ETL processes.
  • Consulted end users on data mapping and extraction strategies
  • Lead meetings with clients and team members to resolve issues, develop requirements and coordinate efforts.
  • Used IIS to install and configure FocalPoint software.

Database Programmer/DBA

Confidential

Responsibilities:

  • Developed ETL procedures using T-SQL and PL/SQL coding to move information from clients data sources into the Obvient Data Warehouse
  • Installed, upgraded and configured Oracle Database for clients and in-house employees.
  • Migrated database Schema changes to stage, production and development.
  • Performed database tuning using Explain Plan, hints, Toad and Enterprise Manager.

Confidential, Atlanta, GA

Database Analyst

Responsibilities:

  • Gathered and monitored requirements from Beazer management team and coordinated efforts with development and data warehouse team members to ensure they were met.
  • Developed ETL procedures and monitored scheduled loads to support Data Warehouse.
  • Managed, developed and maintained SQL Server 2000 Jobs and DTS packages.
  • Develop Web applications using Visual Basic.NET and Java Script for data access and manipulation.
  • Modified and created T-SQL procedures to meet changing requirements of BI reporting solutions that included Brio, Crystal Reports and Microsoft reporting services.
  • Developed and supported BOSS report Administrator using Microsoft Reporting Services Soap protocol.
  • Lead project to convert Brio reports to Microsoft Reporting Services for Confidential .

We'd love your feedback!