We provide IT Staff Augmentation Services!

Operations Senior Analyst Resume

Shrewsbury, MA

SUMMARY

  • Over twenty years of software experience in software design, development, testing, implementation, and support with specialized skills in Data Warehousing, modeling, and Enterprise reporting solutions.
  • Expertise in Data Warehouse & Data Mart design, database application, performance issues and maintenance plan on SQL Server 2000 and Oracle8i / 9i.
  • Over Six years’ experience as Field Service Engineer and System Manager working with customers resolving hardware and software issues.
  • Expertise in ETL tools such as Informatica, DataStage and SQL Server DTS.
  • Extensive knowledge of Software Development Life Cycle (SDLC), including documentation of support application guides and installation procedures, the business requirement/process, and data management; ability to develop and integrate solutions to meet the requirements.
  • Strong leadership, communication, and interpersonal skills. Team player.

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP, HP - Unix, VMS.

Databases: SQL Server 2000, Oracle8i/9iETL/Reporting Tools Informatica PowerMart 5.1/6.2, DataStage 5.2, SQL Server 2000 DTS

Languages & Technologies: MS SQL, MS Access, DCL, Unix shell script (HP-UX)Schedulers Tidal, Maestro, Poly Center, MySQL

PROFESSIONAL EXPERIENCE

Confidential, Shrewsbury, MA

Operations Senior Analyst

Responsibilities:

  • ERP Infor M3implementation team, Support.
  • Extracted M3 data for reporting.
  • Created SISS jobs to automate loading of Intuit database.
  • Implemented Infor Factory Track and supported Globally.
  • ERP Infor M3 implementation team.
  • Worked with the Global team to implement Infor M3 ERP solution. The company converted Cincom (ERP) to M3 Globally.
  • Member of the PDM team and extracted and transformed Cincom data to work with M3. Converted the system under budget and on time.
  • Worked with the users to extract M3 data from IBM database to a reporting database.
  • Worked with users to extract data reports that were used to drive business decisions.

Confidential, Marlboro, MA

ETL Designer & Developer

Responsibilities:

  • Developed and supported standardized Information Management (IM) environment, solution, and roadmap for the Americas Service Delivery Organization.
  • Designed and configured SDDM database schema within the IM DataMart for multiple call handling applications. This integrated data repository provides business decision support after the largest merger in IT history.
  • Led data mapping and analysis efforts.
  • Designed and configured SDDM database schema, identification of requirement gaps, and milestone definitions.
  • Modified and tested existing Brio reports with the data elements from SDDM database.
  • Recognized and received monetary award for developing concurrent load/extract schedules which reduced the time it took for users to get their data from 2 days to 4 hours.

Hire Now