Operations Senior Analyst Resume Shrewsbury, MA - Hire IT People

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.