Sr. Data Warehouse Developer Resume Camp Hill, PA - Hire IT People

SUMMARY

Comprehensive experience in the IT industry, spanning across multiple areas including Data Architecture, Data Analyzing, Data Warehousing, Design, Development and Implementation of Business Analytics solutions using Data Warehouse Design, ETL and Web Applications on Windows in an agile environment.
More than 5 years of experience in the IT industry, spanning across areas like Mainframe installation, upgradation and configuration of systems with varying levels of complexity.
Data Warehousing experience using Informatica Power Center 9.0/8.6/8.1.1
Well versed in all aspects of the SDLC from requirement gathering through development and support.
Dimensional/Relational Data Modeling to design and develop Star/Snowflake schemas, Fact and Dimension tables, Physical and logical data modeling using Erwin and Visio
Expertise in Extraction, Transformation and Loading data into Enterprise Data Warehouse (EDW) and Operational Data Store (ODS) using ETL operations
Proficient in writing and using SQL queries, SQL * Loader, Stored Procedures, Triggers, Materialized Views, Indexes, Cursors, Partitioning, Exception handling and Optimization Tuning.

TECHNICAL SKILLS

DW/ETL Tools: Informatica 8.1/8.6/9.0/9.6.1/10.1.0

Data Modeling Tools: Microsoft Visio, Erwin 4.0

Reporting Tools: Cognos 8.4/10, SSRS, QlikView, Qlik Sense 3.0, Tableau

Databases: Oracle 9i/10g/11g, SQL Server 2000, IBM DB2

Operating Systems: UNIX, Virtual Operating Systems, Windows 2000/XP/Vista/7

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

Sr. Data Warehouse Developer

Responsibilities:

Gathered requirements over interviews with project stakeholders that included the client, technical analysts and application developers on the team to thoroughly analyze functional specifications and created technical specification documents for all ETL processes and designed the logical and physical data model for the new change requests. This led to an enhancement by 80% on the client’s EDW.
Led the development of strategic recommendations and successfully delivered proposals including LOE estimates, release plans and modification of existing data models in sync with changing requirements.
Partnered with and led different teams in meeting milestones on the project timeline while ensuring the deliverables closely aligned with the client’s vision, roadmap and success criteria. Developed resource allocation plans and cost estimations which allowed to effectively utilize resources and investments while taking into account the different risks and developed risk management strategies.
Utilizing Informatica, Cognos and SQL, developed mapping of sources to different stages of the Agile Software development process, scheduled, monitored and troubleshot batches and sessions across the process, analyzed and resolved issues, and created dashboard, ad hoc and cube reporting for different stakeholders. This ensured a 95% compliance with enterprise data architecture standards.
Acquired, organized and quantitatively identified performance metrics for improvement to the database, Informatica pre - session and post-session scripts and overall performance of the data warehouse. Worked with DBAs to then implement improvements in adherence to proposed suggestions and best practices by building partitioned tables, Index organized tables, bitmap indexes and by creating materialized views on tables. Created Integration, UAT testing scenarios. Performed regression and unit testing. Overall performance of the data warehouse process was improved by 75 %
Took initiative during the Informatica upgrade process from 9.6.1 to 10.1.0. Created playbook for the entire upgradation process. Throughly tested the new informatica server and made sure the existing process executed smoothly in in the sandbox version. After the upgradation process was complete, made sure all the Informatica jobs were up and running without any issues.
Created project management plans, led status meetings, and managed communication to project stakeholders.
Created process engineering and business flow assessments to ensure appropriate engineering of solutions.
Led enhancement projects of various levels of complexity in a project manager role; to include creation of project schedule and risk management tasks.

Confidential, Mumbai, IN

Associate System Analyst

Responsibilities:

Provided training to the new analysts about the systems, and monitoring process.
Applied bug fixes on the existing issues.
Provided migration support to backup the data from the production systems to servers located in different state.

We provide IT Staff Augmentation Services!

Sr. Data Warehouse Developer Resume

Camp Hill, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship