Summary

• Over 4 years of experience in MS SQL Server 2008/2005/2000, Database Migration.
• T-SQL and Microsoft Business Intelligence tools SSIS, SSRS.
• Experience in Database Normalization, Designing, Creating Indexes, Developed Queries and T-SQL Scripts in MS SQL 2008/2005.
• Experience in Creating Tables, Views, Complex Stored Procedures, Triggers to facilitate efficient data manipulation, data integrity and other T-SQL DDL, DML statements for various applications.
• Experience in optimizing the query by creating various Clustered, Non-clustered indexes.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services SSIS , and Reporting Services SSRS .
• Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel ,spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store ODS , Enterprise Data Warehouse EDW , Data Marts/ Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into target.
• Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Expertise in creating complex SSRS reports against OLTP, OLAP databases.
• Experience in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports.
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio BIDS
• Experience in using Expressions to customize SSRS reports dynamically.
• Knowledge in working with all Collections in reports like Fields, Globals, User, Parameters, Variables and Report Items.
• Expertise in Report Caching and Subscriptions including Standard and Data-Driven Subscriptions.
• Experience in extracting and transforming data using SSIS.
• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

Technical Skill:

• Operating Systems : Windows 7/Vista/XP, MacOS X 10.4/10.5/10.6
• Programming tools : C , MSSQL 2005/2008, Microsoft Visual Studio
• Bids : SSIS, SSRS
• Scripting Languages : VB Script, Bash Shell, AppleScript Mac
• Database Tools : Oracle 9i,10g, MySQL, Microsoft Access
• Web Technologies : HTML, HTML5, CSS, SQL, JavaScript, Networking Concepts
• Servers : Windows server 2008 R2, Internet Information Server
• ETL Tools : Informatica Power Center 7.1.1,Datastage-7.5 Conceptual level
• OLAP Tools : Business Objects-5.1

Confidential

Sr. Business Intelligence/SQL Developer

Description: Confidential is Information Technology Company in Education Sector. The project requirements were to integrate data from various sources using SSIS and other ETL tools and develop custom reports for local, State and Federal Government on student performance meeting various criteria established by government and private entities for monitoring purposes.

Responsibilities:

• Analyzing the Business Requirement Document BRD to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Used Analysis Services SSAS processing task to update with the current data.
• Involved in dimensional modeling by Identifying the fact and dimension tables based on the user reporting requirements.
• Created Monthly portfolio reports using SQL Server Reporting Services SSRS .
• Created Tabular, Matrix, and Drill down reports for different levels of risk officers and sectors.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports , Charts, Drill through , and Report Models Drill Down Reports
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
• Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2005/2008.
• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format

Environment: MS SQL Server 2008/2005, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Business Intelligence Development Studio BIDS , MS Excel, Windows XP, SQL Server Management Studio SSMS .

Confidential

Informatica developer

Description:

• The objective of this project is to develop a sales data mart and reporting system to analyze the purchases and delivery details of the different products manufactured within the organization. The existing source transaction system is unable to generate sophisticated reports, so it should be replaced by a Confidential. The process involves extracting of data from the source Access database and Loading the data into a temporary database and Transforming the data according to the Business rules specified and then loading it into the Confidential. Business Objects Tool is used for the purpose of reporting.

Responsibilities:

• Loaded data from different source tables to operational data sources ODS .
• Loaded data from ODS to data warehouse
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc.,transformations to implement complex logicswhilecodinga mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and RepositoryManager.
• Developed and maintained ETL Extract, Transformation and Loading mappings to extract the data from source system Oracle, and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica6.2.1.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment:Informatica6.2.1, Oracle 9i, , PL/SQL,TSQL, Windows 7

Confidential

Health Management System, Informatica developer

Description:

• Confidential diseases represents a major health problem across the globe. In developing countries like India more than 55 million deaths occur every year because of the diseases caused by pathogenic organisms. The integration of molecular databases is considered as one of the major challenges to bioinformatics integrated data sets. Data in biological data bases describes many different things like Confidential sequences, protein sequences, protein structures, biological pathways.
• The goal of combining these different things into the unified interface is the driving force behind this data integration project. At present we are concentrating on sequence data, specially related to nucleotides and proteins. Once unified resource is established, the ultimate goal is to develop and implement bio informatics analysis tools over the Confidential and establish unified information and analysis system.

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup connected and unconnected ,sorter, Normalizer, sequence generator, etc.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules business rules to generate consolidated fact/summary data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels.
• Creating Sessions and running The Sessions

Environment: Informatica6.2.1, Oracle 9i, PL/SQL, TSQL, Windows 7