We provide IT Staff Augmentation Services!

Senior Data / Business Analyst Resume

Dallas, TX

SUMMARY

  • Talented Data Analyst with over 10 years - experience in design, architecture, data modeling, and business analytics
  • Extensive experience in Oracle and Microsoft database platforms, with expertise in SQL standards, and PL/SQL, as well as cursors and modules.
  • Strong knowledge of data warehousing, including Extract, Transform, and Load Processes.
  • Talented analytical thinker, proficient at identifying and resolving technical problems.
  • Proven track record managing all phases of Software Development Life Cycle (SDLC) from requirements gathering to production implementation.

TECHNICAL SKILLS

Languages: Java, C++, C#, SQL, PL/SQL, T-SQL, Perl, Python, R, Ruby, VB, VB.Net, XML, HTML, Shell Scripting

Databases: Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, Allbase/Image, MS Access

Tools: Tableau, TOAD, SQL Developer, Rational Clear Case, Informatica, SAS Dataflux, Microsoft SSMS, SSRS, SSIS, Power BI, HP Quality Manager

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior Data / Business Analyst

Responsibilities:

  • Work directly with client as focal point to establish design parameters for cell phone billing system.
  • Knowledgeable in all phases of database development, including mapping, designing, configuring, implementing, testing, and post-launch support.
  • Oversees 3-member team that created and integrated credit card pricing engine.
  • Maintain database, including creating and modifying tables, monitoring traffic, and importing and synchronizing data.
  • Create and maintains automation Java tools for database importing.
  • Research and find data anomalies in production databases.
  • Create Reports in Tableau
  • Manage production change control system.
  • Manage software releases, requirements gathering, test data creation, and production implementation

Confidential, Chicago, IL

Lead Database Analyst

Responsibilities:

  • Migrated legacy system data into IBM DB2 that customer service and sales representatives could access for wide range of services.
  • Managed team of analysts creating database migration in Informatica.
  • Tuned ETL mappings and SQL queries to improve system performance.
  • Created multiple programs to ensure correct data transfer and communications between Allbase database and IBM DB2.
  • Managed reports within Business Objects.
  • Develop data models and other data documents such as data flow diagrams, ERDs, and Process flow diagrams.

Test Data Analyst

Confidential

Responsibilities:

  • Worked with testing teams to create data sets for testing application roll out.
  • Wrote and implemented T-SQL module to create test data set from production databases within the company.
  • Support and develop ETL code using SSIS
  • Managed and loaded databases in test environments.

Hire Now