We provide IT Staff Augmentation Services!

Data Management Analyst Resume

Houston, TexaS

TECHNICAL SKILLS:

  • Informatica PowerCenter 9.5.1 (Designer, Workflow & Monitor);
  • Hyperion (11.1) Planning, Essbase (BSO, ASO, MaxL, Subvars, Calc Scripts & Rules Files), SmartView, Interactive Reporting;
  • Oracle Databases PL/SQL, Triggers, Procedures, Views;
  • MySQL Databases, Views SQL;
  • Access Databases;
  • Windows, Linux & Unix Servers;
  • Korn Shell Scripting, Batch Scripting, VI
  • SQL Navigator, TOAD, Putty, SharePoint, Microsoft Office suite, Secure File Transfer Protocol (SFTP,) Team Foundation Server (TFS), Remedy
  • Business analysis, Risk analysis
  • Star Schema Modeling, Dimensional Modeling
  • Test script development, System testing, UAT testing, Use case development
  • Functional requirements

EXPERIENCE:

Confidential, Houston, Texas

Data Management Analyst

Responsibilities:

  • Developed mappings that perform Extraction, Transformation and load of source data (Tobin, Oracle ERP, Well View, SAP) into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up (connected/unconnected), Joiner, Expression, Stored Procedure, SQL and update strategy to meet business logic in the mappings.
  • Perform analysis of current process and develop technical design and Implement mappings for an Enterprise ETL environment. Transfer of flat files to outside source system (PDS Energy). Web Services for partial lookup Well Master for Adobe forms.
  • Worked with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.
  • Created Post UNIX scripts to perform operations like split, copy, rename, archive, remove and touch files.
  • Able to navigate around Unix/Linux system to check for specific files, files contents, permissions, parameters as needed.
  • Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day - to-day ETL progress monitoring.
  • Tuned Informatica mappings and sessions for optimum performance by using procedure for dropping indexes, truncating tables and rebuilding indexes.
  • Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
  • Worked on moving the code from DEV to QA to Production and performed complete Unit Testing, Integration Testing, user Acceptance Testing for the three environments while moving the code.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Confidential, Houston, Texas

Hyperion Analyst / Developer

Responsibilities:

  • Managed and analyzed business requirements and developed functional specifications.
  • Supported data analysis, collection and document procedures for implementation.
  • Created and executed test plans and test scripts for user acceptance testing.
  • Documented and Developed new support procedures for Hyperion Planning, which was being implemented for the first time. Analyzed, extracted, uploaded and documented all source systems (Enterprise Upstream (volumes), Tobin (GWI, NRI), DPR (Rig schedule), Master Data Management) needed for planning applications

Confidential, Fort Worth, Texas

Hyperion Analyst / Developer

Responsibilities:

  • Analyzed a BSO essbase cube, which had poor performance aggregating. Developed and implemented ASO cube, as per requirement needs and improved performance.
  • Interviewed business users/SMEs to gather business requirements and to create technical documentation.
  • Implemented ad hoc Calc scripts to run by business users on BSO essbase cubes.
  • Did modifications (UDA, Calculations, Alias, consolidation, etc.) to BSO/ASO cubes according to user requirements.
  • Interaction with finance and accounting customers who possessed various levels of technical knowledge.
  • Supported daily monitoring of Hyperion Essbase/ Planning cubes for errors and find out the cause of errors via error log files.

Hire Now