SUMMARY

• Over 9+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Reporting, Development, UAT and Production Environment).
• 3+ years of Data Warehousing experience using Informatica Power center 8.x/7.x/6.x/5.x, Power Connect, Power Exchange, Warehouse Designer, Power Analyzer, ETL, Data Mart, OLAP, OLTP, Star Schema, Snowflake Schema.
• Expert in creating reports in SQL Server 2012,2008 R2 and 2005 using SSRS
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Strong experience in handling ETL jobs on UNIX platform
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008 R2).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• SQL Server 2000/2005/2008 R2 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Worked on Netezza for giving data warehouse solutions
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
• Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Involved in DBA activities such as backups, restores, replication etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Hardware: HP/Compaq ML 380 Servers, Dell Power edge series

Database: SQL Server 2000, 2005, 2008 R2, Oracle 10i, DB2

Operating Systems: Windows Server 2008 R2/2003, HP UNIX, UNIX.

Programming Languages: SQL, PL/SQL, C

BI Suite: SSAS, ProClarity, SSRS, MOSS,Netezza

ETL TOOLS: DTS, SSIS, SSRS, SSAS, Informatica 7.1.3/6.2,Netezza

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. SQL Server Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created various reports like tabular, matrix, parameterized etc. using SQL server 2012.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Applied business logic to create New Staging Databases on SQL Server 2008 R2 for new subject areas.
• Created Stored Procedure for Member Matching, Data versioning and Data Certification.
• Responsible for creating and designing SSIS package
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to one database to another databases and process SSAS cubes
• Designed ETL process using SSIS and extracted data from flat files, excel files and SQL server database
• Generated and Deployed ETL process in two step Load data from file to staging, from staging to Target Database
• Efficiently created 3 ETL process which includes one Inbound and three Outbound process
• Effectively created Profiling, Cleansing and Auditing plans with SSIS
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Implemented logic with lookup table to maintain parent-child relationship
• Used transformation like Row Count, pivot, lookup, fuzzy lookup and slowly changing dimension
• Use different flow control like for each loop container, Data flow Task, sequence container, execute SQL task
• Extensively used package configuration to migrate SSIS package from one environment to another
• Use event handing to send e-mail on event like on error
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Created Reports in Crystal and SSRS
• Involved in monitoring, Performance Tuning & managing the Queries and Procedures
• Extensively used all features of MS SQL Server 2008 R2/2008/2005 as a SQL Developer
• Worked in creating complex Stored Procedures, triggers, cursors, tables, Standard Extract views, joins, statements and complex T-SQL code to create extract data file

Environment: SQL Server 2008 R2/2008/2005 Enterprise Edition, Informatica, Netezza, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008/2003, UNIX,Oracle 9i,.NET,C#, Business Objects

Confidential, Louisville, KY

Sr. SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Extensively used all features of MS SQL Server 2008 R2/2008/2005 as a SQL Developer
• Worked extensively on MS SQL Server Reporting Services for Report configuration and creation
• Actively participated in interaction with users, team lead and technical manager to fully understand the requirements of the system for report creation.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Created Dashboard Reports and integrated with SharePoint and .NET based application
• Created Stored Procedures, used complex queries involving join and union of multiple tables.
• Used SSRS to Reporting for a Data warehouse system
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.
• Implemented Type 2 Slowly Changing Dimension to maintain Dimension History. created extensive database models in ERWIN and VISIO
• Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence.
• Implemented Complex Logging in SSIS Packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used containers for repetitive control flow tasks
• Scheduling package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load

Environment: SQL Server 2008 R2/2005 Enterprise Edition, Informatica,SSAS, SSIS, T-SQL, SSRS, Windows Server 2008/2003, Oracle 9i,Performance Point Server 2007, Excel, XML,.NET

Confidential, Agoura Hills, CA

Sr. SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Installation and configuration of SQL Server 2008 R2/2005.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Subreports using Sql Server Reporting Services 2008 R2.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008 R2.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Experience in writing MDX queries for cubes and Performance optimization of MDX queries.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Experience in Planning and Monitoring reports in Performance Point Server.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 R2 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i,Performance Point Server 2007.

Confidential, Jersey City, NJ

Sr. SQL Server BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Installation and configuration of SQL Server Reporting Services (SSRS) 2008.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports through Report Builder.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS)(2005/2008).
• Involved in creating report models and applying row level security filters for report model.
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Experience in writing complex MDX queries for calculated members and measure groups.
• Creating Advanced KPI’s for the cubes using ProClarity (SSAS).
• Experience in building Reports on Analysis Services cubes.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Experience in creating views, books and libraries in proClarity web professional.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Played a major role in the production support of SSAS cubes and SSIS jobs.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), ProClarity Server, XML, MS PowerPoint, MS Access 2003 & UNIX, Shell Scripting, Oracle.

Confidential, New York, NY

SQL Server BI (SSRS /SSIS/SSAS) Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Building UAT and Test environments using Production back ups.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2000 to SQL 2005
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i.

Confidential

SQL Developer/DBA

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PL/SQL to create Tables, Views, and triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters
• Responsible for SQL Server 2000 database development, database modeling, database program, database administrator
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard
• Responsible for remote database servers
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2000.
• Maintain and implement the database using SQL Server 2000 back-end tools and DTS.
• Design, develop and administer the E-Work platform website
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation,
• Upgrade enhancements, maintenance, support and bug fixing for the product.

Environment: T-SQL, SQL Server 2000, OLAP Services, Windows 2000 Server, Query Analyzer, DTS,MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler

Confidential

SQL Programmer

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Creation/Deletion of Linked Servers.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environnent: SQL Server 2000, T-SQL, PL/SQL, TOAD.