SUMMARY

• Over 8 years’ experience as Business Intelligence Developer using Microsoft BI framework (SQL server, SSIS, SSAS, SSRS) in various business domains including Finance, Insurance, and Information Technology.
• Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Stored Procedures, Keys, Constraints, Indexes, Triggers, Cursors.
• Expert in building Data Integration, Workflow solutions, and ETL solutions for data warehousing using SQL Server Integration Services (SSIS).
• Hands on experience in creating SharePoint Solutions, Lists, Document Libraries, Site Templates, Features, Master Page layouts, Web Parts, User Controls, Event Handlers, Workflows, InfoPath forms, CAML Queries and Business Data Catalog in SharePoint applications.
• Extensive experience in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.
• Experience in Performance Tuning in SSIS package by using Row Transformations, Block and Unblock Transformations.
• Experience building and developing Dashboards, Reports, Analytical Charts, and working with SQL 2008 Analysis Services Data cubes in a SharePoint 2010 environment.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience inDataTransformation,DataLoading,Modelingand Performance Tuning.
• Involved in Setting up Microsoft projects in TFS using Visual Studio 2010.
• Expert in creating different types of reports such as drill down reports, drill through reports, parameterized reports, linked reports, sub reports using SQL Server Reporting Services.
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Experience in performance tuning for all the data retrieval SQL fromTeradataData warehouse using Explain, collect stats, Memory management, Partitions, Compression.
• Expert knowledge in developing multidimensional databases using SSAS.
• Developed OLAP cubes using SSAS for data mining. Experience in Dimensional Modeling, Star/Snowflake Schemas, and performance optimization of SSAS cubes.
• Excellent T - SQL programming skills. Expert in writing complex Queries, stored procedures, Triggers, Functions using T-SQL.
• Experience in creating Cell Level Security in cubes using SSAS. Experience in Performance Optimization of SSAS cubes.
• Strong communication and team-oriented skills with a strong attitude toward learning new technology quickly supporting the project requirement.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, Informatica 7.1.3/6.2

Databases: SQL Server 2000/2005/2008/2008 R2,2012 MS Access, Oracle

Programming Languages: SQL,T-SQL,PL/SQL,VB,C#,ASP.NET

Operating System: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0 Windows XP/98/95, MS DOS, Linux.

Scripting: HTML, XML, VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET, ADOMD.NET

Tools: Erwin, Visual Studio 2008/2005 and SharePoint, Report Builder 1.0/2.0/ 3.0

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

MS SQL SSIS/SSRS Developer

Responsibilities:

• Studied in-house requirements and conducted Joint Requirement Development (JRD) session to analyze the database requirement in detail.
• Created SSIS package to extract, transform and loaddatainto theDatawarehouseand Report-Datamart.
• Designed and implemented complexdatamodelingto support various tasks in each step of project life cycle.
• Used SSIS and T-SQL stored procedures to transferdatafrom OLTP databases to staging area and finally transfer intodatawarehouse.
• CreatedSSISDBcatalogwith SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Developed conceptual, logical and physical data models for creating schemas using MS Visio. Created Star/Snowflake Schema for Data Marts.
• Designed, Created and managed primary objects such as tables, triggers, db links, indexes, and privileges, based on logic design model. Developed all the required stored procedures and user defined functions, and worked with stored procedures for data set results in reporting services to reduce report complexity and to optimize runtime.
• Designed extract, transform and load (ETL) packages to load business retail data received from different stores and other locations into data marts using Data Flow Task, Execute SQL Task, Lookups, Fuzzy Lookups, Conditional Split, Derived Column and Execute Package Task.
• The Process flow diagrams have been reversed from reviewing the ETL code in order to perform data quality measures.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS.
• Designed and implemented data structures for new functionality and restructured existing data structures to increase performance by writing queries and stored procedures.
• Created SSIS packages to automate maintenance, database backup and restoration, update statistics, re-build indexes as well as create error log for event during data load.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: MS SQL Server 2008/2012, MS SQL Server Reporting Services (SSRS) 2008R2/ 2012, TFS, MS SQL Server Integration Services (SSIS) 2008R2/2012, MS SQL Server Analysis Services (SSAS) 2008R2/2012, C#, Microsoft Visual Studio, SharePoint, MS Excel., MS Visio 2013.

Confidential, Madison, WI

MS SQL SSIS/SSRS Developer

Responsibilities:

• Gathering requirements, Analysis, Design, functional & technical specification, Coding, testing and Document preparation.
• Supported application written in Oracle PL/SQL and converted into T-SQL packages.
• Created data extraction ETL jobs using SSIS, extracting data from MS ACCESS, Oracle and MS Excel and loading into SQL Server Databases.
• Initiated Design of ETL architecture solution from already existing ETL processes which are required to be analyzed as a part of the quality assessments.
• Created Data Flow Diagrams for ETL processes scheduled to run daily basis.
• DesignedDataModeling, Design Specifications and to analyze Dependencies.
• Head up specialized database and desktop application projects across various industries including hands ondatamodeling, design, test and implementation.
• Created T-SQL Stored procedures, Functions and Triggers.
• Running DBCC checks and fixing data corruption in Application databases.
• Created reports using SSRS (SQL Server reporting services).
• Created matrix, reports, drill down reports and developed reports with graphs using SSRS.
• Worked on enterprise reporting Lifecycle. Created Ad-hoc reports, monthly, weekly reports.
• Developed Various Operational, drill-through and drill-down reports using SSRS.
• Developed custom reports using SSRS/SQL Server BI studio.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005, T-SQL, SSAS, MDX, SSRS, Oracle 10g, PL/SQL, MS ACCESS,, Windows 2003/2000(Advanced Server), Data modeling, Crystal reports, Data Analysis Expressions (DAX) T-SQL Windows 2003 advanced Server.

Confidential, Woodbridge, NJ

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Designedand developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Modified the existing SSIS packages to meet changes as specified by the users.
• Transformed data from One Production server to another server using OLE DB connection by creating various SSIS packages.
• Designed, deployed and maintained various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, and charts and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution delivery and track reporting history using SSRS 2008.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Provided documentation for all the reports and SSIS packages.

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), SQL Profiler, MS Office, Erwin, Windows Server 2003.

Confidential

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in complete SDLC life cycle.
• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Developed SSIS packages to migrate the data from excel spread sheets to SQL Server Database.
• Created SSIS packages to retrieve data from different source systems on monthly basis.
• Developed child packages and called that in parent packages and also implemented pivoting transformations in SSIS.
• Created SSIS packages both design and code to process data to target databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.

Confidential

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Developed complex SSIS packages to migrate the data from flat files to SSIS.
• Created batch files to load the data from text file to database tables.
• Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.
• Experience in creating Drill down reports, parameterized reports, cascading parameterized reports and drill through reports.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables.
• Fixing some of the production issues.
• Created adhoc reports based on the user requirements and worked on different on-demand reports using SAS, PROC SQL and MS Excel.

Environment: SQL Server 2000/2005, SSIS, SSRS, SAS MS PowerPoint, MS Project and MS Excel.