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 experience 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.
• 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, NJ

Data Architect

Responsibilities:

• As a Data Architect on Mortgage Development project, to gather requirements while working closely with Business Team and converting them into database model on DWH platform.
• While working as Tech Lead for database development with Offshore and On site Development teams on changes for Application Database and DWH database.
• Designing and creating Logical and Physical data modell, 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.

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.
• Responsible for Data Warehouse Architecture, Designing Logical and Physical model
• Creating data models using Erwin data modeling tool.
• Performance Tuning, based on data load and data retrieval.
• Data profiling for design considerations and presenting to client.
• Responsible for designing ETL Architecture and performance monitoring.
• Responsible for signing off the design of Database & ETL before pushing it for development.
• Responsible for designing Database Architecture and responsible for team using from source control in on site and offshore model.
• Designing a BI Solution for Vendor Management Reporting Solution
• Coordinating with the Production Support team to roll the ETL and Database Changes to production.
• Data get populated from Siebel CRM, for customer Relation Ship data into dimensional data marts.
• Analyzing requirements and profiling data before design requirements and signing of the requirements.

Confidential

DWH Architect

Responsibilities:

• My primary role is dealing with client for all the requirements gathering and data analysis while proposing a solution and discussing with the client for the design approvals on proposed Solution, and analyzing the data and creating Mock reports while analyzing data and getting approval for the same Interacting with client for the deliverable and working closely with Team for on time completing the project commitments.
• Designed and Implemented error free data with process logic for ETL on failures and roll back to previous run with error handling logic in the Architecture Designing phase and discussing with the client and getting the approvals on Design documentation phase.

Confidential

Sr Data Warehousing Expert

Responsibilities:

• Involved on Data Warehousing Projects as Data Warehouse Architect and ETL Architect. Where my personal role is to analyze the Source Data as per Business Logic Proposing the Data Warehouse Design and discussing with client to get approval for the same.
• Actively involved in Client discussions for the design approvals, also involved on designing ETL Architecture and executing the same. End Design requirement is to create a Clinical Data warehouse based on the reporting needs and discussing with the users for their current requirements.
• Proposed the Clinical Warehouse as per the current requirements and in consideration of the future requirements based on those proposed a baseline schema and finalized the ETL process for the same.

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

Confidential

IS Manager

Responsibilities:

• As Data Architect & Leading the Team, where my personal role is Data Warehouse 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.

Confidential

DWH Developer

Responsibilities:

• Actively participated in using Informatica on loading the data in ODS from different sources and populating the data in the cubes and also participated in trouble shooting of the sessions where the loading has been failed and analyzing the same.