SUMMARY:

• An IT professional with 15+ years’ relevant experience seeking a mentally stimulating and challenging position which will enable me to utilize my expertise and work experience.
• Adept change agent with well - honed analytical and quantitative abilities, coupled with years of business experience in conceptualizing, developing, and implementing comprehensive solutions and having experience in On site and offshore model .
• An IT Specialist expertise in high dependable systems, with a proven track record of implementing highly successful and dependable data management solutions involving business understanding, requirement gathering, Data Analysis, Design data warehouse, Design Logical and Physical Data model, ETL Application Development, Testing and Production support e xperience as architect end to end Data Warehouse Architect, ETL Architect, data warehouse and business intelligence applications for large enterprises.
• A Quick Lerner and an ability to rapidly achieve organizational integration assimilate job requirements and employ new concepts, methodologies and technologies.
• While interacting with Business Users and having many years of experience on On-site and Offshore model.
• Designing Logical Data Model and Physical Data model.
• Handling the design, development, unit testing and deployment of data warehouse systems.
• Defining data requirements and designing databases to satisfy client business objectives.
• Participating in design reviews, and assisting with allocation of functionality to specific system components.
• Developing data models, implementing databases, and tuning Databases for performances.
• Designing ETL Architecture and Designing with auditing, and exception handling.
• Designed ODS as Data Store and as per OLTP Archive policy, where data is reverse shared between ODS and OLTP.
• Experience in Erwin Model Mart as centralized data model repository, also working knowledge in Meta data management.
• Designing Analytical reports using SSIS, SSAS.
• Designing Reports, analyzing data and profiling data to present issues and working closely with Business Team on requirements and resolving issues.
• Working closely with the team on Releases and managing and maintaining Release on multiple environments.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin 7.x, ER/Studio, Microsoft Visio

ETL Tools: Informatica Power Center 8x, 7x, 6x, SSIS.

LANGUAGES: C, SQL, TSQL, PL/SQL.

PROTOCOLS: TCP/IP, PPP, HTTP, FTP.

Databases: Teradata, dB2, Oracle8i/9i/10g/11g, SQL Server 7.0/2k/ 2005/2008/2012 , MySQL and MS Access.

Methodologies: Star Schema, Snow Flake Schema.

Business Intelligence Tools: MSTR, Cognos, SSAS, SSRS, OBIEE.

OPERATING SYSTEMS: UNIX, Linux, Fedora, Solaris, Windows NT 4.0, Win2k8, Win2K, WinXP, Win95, Win98, MS-DOS.

Version Control Tool: TFS 2010, SVN, MS Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential, Chatham, NJ

Data Architect

Responsibilities:

• Designing and creating Logical and Physical data model with meta data.
• Working on release management with DBA's and on multiple environments.

Confidential, Louisville,CO

Data Architect

Responsibilities:

• Designing and creating Logical and Physical data model, implemented Team Foundation data base project for collaboration between teams span across different time zones.
• Profiling Source data on data quality issues, which will be used for analysis on the design and presenting to the client.
• Analyzing data requirement and capacity planning.
• Analyzing queries on database performance analysis based on execution plans and improved them.
• MSSQL Server 2012 with TFS database project with meta data.
• Created column store indexes based on performance analysis on SQL Server 2012
• Created mapping documents for source to target mapping.
• As per business requirement created LOB as hierarchy.
• Created security model for user defined roles for security implementation on SQL Server 2012.

Confidential

Data Warehouse Architect

Responsibilities:

• Designing Data Warehouse Architecture using bottom up approach and created Logical and Physical data model.
• Designed Dimensional model, to support Type 1, Type 2 and Type 3.
• Created the auditing as primary driver for the project and which will be used for analysis the previous load for any issues if required using the audit rolls back a particular load.
• Created the ETL Design Document where including the process logic how the data has to move forward and getting the approvals for the ETL Documentation phase
• Driving the ETL Team for understanding ETL Design Document for ETL coding phase.
• Closely involved with ETL team on coding phase for the project schedules and resolving the issues and taking forward.

Environment: Informatica Power Center 8.1.1, Erwin 4.1, Teradata, Oracle 9i, MSSQL Server 2005, Flat files, PL/SQL, SSIS and SSRS.

Confidential

Data Architect

Responsibilities:

• Designing and also effectively using available resources by assigning proper roles to the team members on Designing, Developing and Monitoring work flows on loading data into Data warehouse on Oracle platform from multiple sources using ETL Tool Informatica.
• Creating analysis & reporting platform on an OLAP Server by Extracting test data into cubes for analysis and reporting.

Environment: Informatica Power Center 7.1.2, Erwin 3.5, Visio, Oracle 9i, SQL Server 7, Flat files, PL/SQL.