Summary

• Highly motivated Business Intelligence Professional with over 5 years experience in manipulating various data sources using Microsoft SQL Server 2005/2008 Technologies and ETL processes.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Experienced in various processes including Incident, Change, Problem and Configuration Management.
• Good knowledge of SQL Server BI tools like SSRS, SSAS, SSIS, data warehousing, ETL concepts and in the design of Business Intelligence Solutions.
• Experience in administration,management, analysis and providing quality process methods for business solutions.
• Proven ability to adapt quickly to new projects, and capable of working with cross-functional teams.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the mappings between sources (external files and databases) to operational staging targets.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Experience in data modeling, data warehouse, ETL design development, Star/Snowflake Schema Designs with requirements analysis-definition, database design, testing, and implementation and Quality process.
• Created Documentation (Technical Design Document and Low Level Design Document) for supporting the Applications using Microsoft Word, Visio.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Extensively used Informatica Designer, Informatica Server Manager/Workflow Manager, Work flow Monitor, and Repository Manager.
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
• Played significant role in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.

Computer/Technical Expertise

LANGUAGES C, C++,Unix shell scripting,PL/SQL, SQL,SQL*PLUS,TSQL,TOAD DATABASES RDBMS Concepts, SQL Server 2000 & 2005(YUKON), Oracle 10g, MySQL OS/UTILITIES

ETL/BI TOOLS

Windows XP/2000/2003, MS Office Project 2007, MS Visio

Informatica 8.6.1/7.1, SSRS, SSAS, SSIS, Pentaho BI Suite, OBIEE

Work Experience

SQL Developer/Report Analyst Mar 06-Dec 07

Confidential
Project: ASM Reporting
The scope of the project was a CRM based inventory-management service application provided by Microsoft which enables customers to track their orders and manage the inventory by reports provided based on business. The project requires Extract and loading data to Data Warehouse, creating reports and cubes.

Responsibilities:

• Monitored Extraction, Transfer and Loading data processes from different data sources and validated reports.
• Develop and maintain reports and SQL scripts to retrieve data for analysis and reporting.
• Manage daily operation, user security and report distribution/subscription
• Configuration and Automation of SSIS packages to load the data into Warehouses as per business requirements
• Assist the customers in developing BI Solutions and components for all BI reporting and dashboard technologies.
• Design, build, test and revise SSRS Reports (possibly dashboards) to meet business needs.
• Design, develop and support OLAP solutions using SSAS.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extract Transform Load (ETL) development using SQL Server 2005 Integration Services (SSIS).
• Analyzed reports extensively and worked on parameterized and customized reporting techniques.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

ETL /Informatica Developer

Confidential Jul 05-Mar06
Project : Technology Infrastructure Support

Ted web has built an Enterprise Data Warehouse (EDW) that is loaded on a daily basis from internal and external data sources. This Enterprise Data Warehouse further feeds data at various intervals into various Marts viz. Employee Mart, Finance Mart, emetics Mart. The EDW/Data Marts provide critical information for business analytic and decision-making purpose.

• Used various transformations like Aggregator, Look up, Router, Update strategy, Expression etc.
• Performed source to target data mapping and analysis on oracle and SQL systems, as per project needs.
• Designing, reviewing, implementing and optimizing ETL processes.
• Responsible for the analysis, design, coding, testing, troubleshooting and implementation of ETL processes for Enterprise Information Services initiatives.
• Design and develop mappings in Informatica Power Center 7 to accommodate business requirements for data extraction, transformation and loading.
• Loading the data from OLTP to Warehouses and Data marts using Informatica Power Centre 7.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Worked extensively on Normalizer, Source Analyzer, Mapping Designer, and Warehouse Designer.
• Developed several Maps and Mapplets using corresponding Source, Targets and Reusable Transformations.
• Set up Batches and Sessions to schedule the loads at the required frequency using Server Manager
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.

ETL /Informatica Developer Mar 04-Apr 05
Confidential
This project main objective is to create slowly changing dimensions and confirmed dimensions and direct loading based on different subject areas. Data is loaded from the source to a staging area in ODS (Oracle Data Source) where all the dimensions exist. We do all the logical comparison based on the tables in ODS. This project consists of design and builds modules which are of different type parallel jobs.

Responsibilities:

• Created Connected and Unconnected lookup transformations to look up the data from the source and target tables.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Created scripts, which were part of the mapping’s session properties. Used sessions to move files from directory to other and used to compare files.
• Worked with business analysts, data architects and database administrators to gather requirements and build the infrastructure of the data flow
• Designed and developed Informatica mappings for data loads and data cleansing.
• Worked with different kind of source like flat files, xml files, Access, Oracle
• For better performance tuned Informatica mappings and Optimized Query Performance, Session Performance and Readability.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Extracted data from different sources like DB2, Sql server, flat files and loaded into DWH
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Created reusable transformations to clean the data, which were used in several mappings.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.

Informatica Developer Aug 03- Mar 04
Confidential
Airtel is a brand of telecommunication services in India. This Project is basically developed for Airtel for building a data mart and OLAP reports for order management, strategic testing and tactical call center/customer relationship Management. This data mart stores historical information about Local, Long Distance, Voice Mail, and Pager Services. This system extracts data from order management system database (OLTP).

Responsibilities:

• Extracted Data from Different Sources by using Informatica Power Center.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 6.1.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Involved in Performance Tuning of Complex Maps having multiple Lookups and Target Tables.
• Used the command line program Pmcmd to communicate with the Informatica Server.
• Uploading the Data files into the tables of the Oracle database in the server running on UNIX with the help of a scheduled Cron job.
• Performed activities including design of exception handling strategy and performance tuning of custom stored procedures in PL/SQL.

Academic Work Experience

Data Analyst: Confidential,Texas at Arlington Jan 09-May 10
This position is a report writer and an analyst who will serve all areas of the university which include maintaining online book store for library, student information database, university website and utilizes the Office of Information Reporting & Analysis Services as a resource for reporting and data analysis. It functions as part of a team of report writers and analysts who
work collaboratively to provide complex statistical analysis that is utilized to support and maintain any reports related to university.

• Troubleshooted data issues, validated results, recommended and implemented process improvements.
• Analyzed business requirements, specifications and developed design documents.
• Developed data models, ETL solutions using Informatica, and implemented reporting solutions using SSRS.
• Worked on ad-hoc/parameterized report data using SSRS, performed data analysis to identify better solutions.
• Managed resource allocation, work scheduling and mentored a team of ten members.
• Developed and maintained performance dashboards and training metrics of the team.
• Worked on huge volumes of data and focused on problem solving methods and techniques.
• Targeted on maintaining adhoc and customized reports on various business measures and aspects.
• Analyzed huge volumes of student data, maintained databases for information storage and retrieval.
• Applied problem solving skills and techniques in gathering and organizing vast operational data on a daily basis.

Certifications

• Microsoft Certified Database Administrator(MCDBA) Since 2006
• Microsoft Certified Professional(MCP)

Education
Master of Science in Engineering Management
Bachelor of Science in Electronics & Instrumentation