Systems Consultant Resume Springfield, MA - Hire IT People

SUMMARY:

A results - oriented information technology professional with 20+ years of expertise in delivering advanced data warehousing, BI, and analytical solutions; highly experienced in setting up Enterprise Centers of Excellences; exceptionally strong collaborator with the ability to work across organizational boundaries and interface with all levels of leadership, with the ability to work efficiently both as an individual, or part of a team.

AREAS OF EXPERTISE:

Databases: MS SQL Server, Oracle, Teradata, UDB, Sybase

Languages: C#, VB, VBA, JavaScript, SQL, VBScript

Tools and Processes: Informatica, Cognos, Erwin, SAS BI. Agile and SDLC project methodologies

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, MA

Systems Consultant

Responsibilites:

Designed logical and physical models to seamlessly integrate into Teradata FSLDM (Financial Systems Logical Data Model) of Enterprise Data Warehouse to accommodate various strategic initiatives. Created mapping documents to describe the complex data transformation for ETL process. Designed logical and physical models for Distribution and Compensation/Recognition side of the business. Designed, modeled and implemented metadata governance database to provide full data lineage from the sources to the core tables to simplify and streamline ETL development process. Designed a business specific semantic layer data mart to support customized reporting. Designed and modeled relational and dimensional ragged hierarchy for the agency and sales force organization. Designed logical and physical models for Reinsurance database using factless - fact table techniques to present relational data in a dimensional manner for fast data retrieval. Developed most of the frame work models in the company for Enterprise environment and various lines of businesses. Worked extensively with business groups and developed technical design specifications. Analyzed business requirements, identified bottlenecks and proposed solutions. Documented requirements and created design documents. Wrote complex SQL stored procedures and statements to overcome data deficiency for reporting purposes. Trained the business to use various Cognos tools. Developed multiple types of operational reports for different lines of business.

Confidential, Boston, MA

Sr. Specialist

Responsibilites:

Worked as a project lead to collect reporting and analytic requirements.
Conducted meetings with business representatives and technical report designers to inventory
existing reports, and develop future report requirements.
Conceptual Data Modeling
Logical Data Modeling
Physical Data Modeling
Data Warehouse Design
Data Warehouse Implementation
ODS & Marts Modeling

Confidential, Hartford, CT

Sr. Consultant

Responsibilites:

Worked as a data architect developing Data Architecture and Data Warehouse Solutions for various clients. Performed data integrity verification and data validation analysis. Designed logical and physical data warehouse models. Modeled several data marts to satisfy reporting requirements. Performed source systems to target data mapping process with transformation rules. Designed and developed Informatica mappings using various transformations. Designed and developed reports using Cognos. As an independent third party tester, verified BellSouth compliance with federal and state level regulations. Performed data integrity, verification and validation analysis of M&R (Maintenance and Repair) metrics for BellSouth. Developed scripts to generate reports indicating the status of BellSouth s performance on validation and verification tests. Authored Observation and Exception reports as warranted. Developed applications for screen scraping processes as part of a third - party verification and validation Performance Measurement Reports (PMRs). Developed an Access database to store and reconcile Ameritech reported results with BearingPoint s test results. Conducted interviews of Ameritech Management to determine processes and procedures used in the calculation of state-specific mandated performance metrics.

We provide IT Staff Augmentation Services!

Systems Consultant Resume

Springfield, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship