We provide IT Staff Augmentation Services!

Enterprise Data Analyst Resume

0/5 (Submit Your Rating)

Hoffman Estates, IL

Hire Now

SUMMARY:

  • Excellent Communication Skills. Interaction with users, clients, management and developers.
  • Requirements gathering / JAD sessions.
  • Strong documentation skills. (Sourcing and design.)
  • Excellent technical skills.
  • Excellent analytical skills
  • Excellent problem solving abilities.
  • Expert knowledge of data warehousing concepts and relational design.
  • Expert knowledge of data marts (star, snowflake) design.
  • Mastery of Teradata SQL.
  • Strong BI / Business Objects knowledge.
  • Strong MS - Office skills.
  • Resource/capacity planning.
  • Innovative and technically inclined.
  • Team collaboration/leadership.

TECHNICAL SKILLS:

Databases: Teradata, MS Access, DB2, Informix

Languages: SQL, Teradata Utilities, IBM Mainframe JCL, COBOL, Utilities

Platforms: Teradata, Mainframe, UNIX, MS-Windows 7/Vista/XP

GUI/Tools: SQL Assistant, Business Objects, SAS SWA, SAS Enterprise Guide, Information Advantage, MS Excel, Word, Outlook, PowerPoint, Access, COGNOS

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise Data Analyst

Responsibilities:

  • Working on M.D.M Item project
  • Data profiling.
  • Verifying all facets of data attributes.
  • Analyzing data in SQL server environment using SQL.
  • Working closely with Data and Solutions Architects in the development of a new Teradata Enterprise Data Warehouse.
  • Teradata RELEASE 14.10.03.07 VERSION 14.10.03.06
  • Functional Design Specifications.
  • Data Sourcing.
  • Data Profiling
  • Data Cleansing.
  • Oracle SQL data analysis.
  • SQL Server data analysis.
  • DB2 data analysis.
  • Data cleansing using LINUX scripting, Teradata FASTLOAD, BTEQ, and SQL functions.
  • Data Migration to Teradata.

Confidential - Hoffman Estates, IL

Warranty Business Analyst

Responsibilities:

  • Mastered a complex Home Services data model in order to efficiently develop extract data, reports, and analyses for clients, management and stakeholders.
  • Worked continuously with peers, managers, and stakeholders on the business strategy.
  • Gathered requirements, developed and maintained product services reporting analysis for review by executives, managers, and stakeholders. (Legal, Six Sigma, Marketing, Finance, Parts Assorting).
  • Wrote ad hoc Teradata SQL queries for product engineers and third party stakeholders.
  • Created SDLC functional and technical specs for In Warranty and SAS SWA Business Intelligence applications.
  • Developed and wrote Teradata SQL code to implement the In Warranty and SAS SWA data marts in a star schema format
  • Responsible for the administration of the IW and SAS SWA business intelligence tools.

Confidential

Business Objects I.T. Group

Responsibilities:

  • Worked with BO Supervisor, Designer, and Report tools in the Home Services environment.
  • Used the BO Designer tool to create a Home Services Universe for business end user reporting.
  • Designed, developed, and maintained business objects (business intelligence) reports, objects, and metrics to measure business performance.
  • Demonstrated / Trained Business users how to create BO Reports.
  • Supported the end user environment.

Confidential

Technical Analyst

Responsibilities:

  • Gathered requirements in JAD sessions.
  • Created and maintained SDLC functional / technical design specifications to ensure accurate development and synchronicity of the home services data warehouse process.
  • Supported the batch process that updated a Home Services Data Warehouse.
  • Lead process improvement projects/tasks utilizing Teradata SQL, UNIX, Mainframe, and various utilities to streamline manual processes into Control-M job scheduler.
  • Maintained, updated, and provided technical support for business tools and reports to business community, and technical support for databases, systems, to peers and coworkers.
  • Teradata DBA for Sears Home Services.
  • Granted rights and maintained security to data.
  • Managed space, Created users, databases, tables, columns, and indexes.
  • Monitored SQL processes running on the machine.
  • Interacted and helped application developers to resolve inefficient SQL scripts/programs.
  • Tuned database/tables for increased query performance.

Confidential, Round Lake, IL

Business Analyst I.V. Division 2

Responsibilities:

  • Designed, developed, and maintained Metaphor, COGNOS Query/Power play, reporting system and metrics to measure marketing performance.
  • Developed and maintained Marketing reports for review by executives, managers.
  • Created and maintained documentation and established guidelines for backup support and to ensure accurate development and synchronicity of reporting solutions.

Confidential, Chicago, IL

Decision Support Analyst

Responsibilities:

  • Developed and maintained market share analysis using Nielsen scanner data, for executives, managers, and marketing stakeholders.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship