SUMMARY:

• 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, BIsuite, Reporting and Analytics.
• 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).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• SQLServer 2000/2005/2008 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).
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• 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. Also used tools like Erwin.
• 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 in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Exposure to CMMI, ISO and QAprocesses, change control management, source safe, version controlling etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Knowledge about coldfusion.
• Hands on experience on internet information services (IIS)

• Microsoft Certified Technology Specialist in SQL Server 2008.
• Brain Bench Certified in SQL Server 2005

Hardware: HP/Compaq ML 380 Servers, Dell Power edge series
Database: SQL Server 2000, 2005,2008, Oracle 10i
Operating Systems: HPUNIX, Windows XP/2000/2003.
Programming Languages: SQL, PL/SQL, C,java
BI Suite: SSAS, ProClarity, SSRS, MOSS, PPS,Hyperion
ETL TOOLS: DTS, SSIS, Informatica 7.1.3/6.2
Database Tools: DBArtisan, SQL Litespeed.
SCM Tools: Visual Source Safe, Star Team.

Professional Experience

Confidential, Milwaukee, WI Nov'11 - Till Date
SQL Server & SSIS / SSAS Developer

Responsibilities:

• Installation and configuration of SQL server 2008.
• Analyzing the business requirements and building logical and physical data models.
• Designing several ETL process to load data from different sources.
• Extensively used Teradata SQL Assist in constructing User Functions, Views, Indexes.
• Extensively used stored procedures and SQL joins in construction of dimension Tables using Teradata SQL Assist.
• Created SSIS Packages to make use of Slowly changing Dimensions to load the dimension views,
• Interacted with the Project Managers and the Field Managers who would be using the application the most.
• 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.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
• Involved in Analyzing, building and testing of OLAP Cube. Extensively involved in the SSAS storage and partitions, and Aggregations.
• Created Calculated Measures using MDX Querying. Assigned different security roles to the cube.
• Created several SSIS Packages to Process the cube with scheduling.
• Worked with different methods of logging in SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Involved in Extensive scripting using C#.net.
• Building UAT and Test environments using Production back ups.
• Created a Cognos package to build repots using the developed Cube.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise.

Environment: SQL Server 2008 Enterprise Edition, SSIS, MDX, OLAP, OLTP, DB2, C#.Net, SSAS, Teradata SQL Assist, Cognos, Windows Server 2003.

Confidential, Stamford, CT April'11 - Oct'11
SQL Server / SSIS Developer

Responsibilities:

• Installation and configuration of SQL Server BI Tools.
• Analyzing the FTA's and the business requirements and building logical and physical data models.
• Creating three step ETL process to get the files from the server and load the data into database.
• Designing several ETL processes to Load data from Text or Excel Files
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Designing of SSIS Packages to get data files fromFTPandSFTPServer and decrypting thePGPfiles,batch processingof incoming data and purging of old files
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS 2008.
• Worked with different methods of Logging in SSIS.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created complex Stored Procedures to validate and process the incoming data.
• Used C# to merge multiple XML reports, convertXMLto HTML format usingXSLTfiles and sending Validation Report emails.
• WrittenPower shell scriptsto purge files
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
• Scheduling execution of ETL Packages using SQL Server Agent.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, MDX, ProClarity, OLAP, OLTP, DB2, ASP.Net 3.0, Ado.Net 3.0, C#.Net, SSAS, T-SQL, SSRS, Windows Server 2003

Confidential, Columbus, OH
SQL Server & SSRS/SSIS Developer July '09 - March'11

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Interact with the Business Admin and gather the requirements and analyzed.
• Interacted with the Project Managers and the Field Managers who would be using the application the most
• 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.
• Experience in Programming AMO OLAP advanced objects like KPI's and Perspectives.
• Experience in using XMLA protocol for SQL Server Analysis Services2005 for interaction between client application and instance of Analysis Services.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• 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 2008 database using SSIS package.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

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

Confidential, Minneapolis, MN Jan 08- July'09
SQL Server & SSIS/SSRS Developer

Responsibilities:

• Involved in Migration of SQL Server 2000 to SQL Server 2005.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Analyzed the project environment and sub systems of the project, and prepared a high level documentation for application designing.
• Interact with the clients and gather the requirements and analyzed.
• Responsible for gathering business requirements, developing and reviewing of design documents
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintained the database consistency with DBCC at regular intervals.
• Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.

Confidential, Hyderabad, India Apr'07 - Dec '07
SQL Server Developer

Description: The Mortgage Securities provides users up-to-the-minute information about payments related to securities. Users can set up a portfolio, create a basket of deals of his interest, and assign reports for those deals. The selected reports are then automatically e-mailed to the user, as they become available. Users can see comprehensive deal summary information.

Responsibilities:

• Actively participated in interactions between users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and flat file data) to SQL Server.
• Created logical and physical database design using Erwin.
• Wrote DTS packages to move data between production, staging and QA environment.
• Worked on different kinds of transformations in SSIS as per the client's Requirement
• Created report modules to provide interactive reports to the users (MS SQL Server 2005/2008).
• Generated Monthly and quarterly Reports in the form of bar chart reports for the management using different techniques like Drill down, Tabular reports, Matrix reports, List reports, Parameterized, Pie charts, Graphs ,Linked Reports, Drill Through using Expressions, Global variables and Functions.
• Successfully deployed reports to report server using SSRS 2005/2008.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• 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.
• 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
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Extensive knowledge in SQL Server optimization using SQL tools such as SQL Profiler, Index Tuning Wizard, DBCC commands, Statistics.

Environment: MS SQL Server 2005/2000, SSIS, SSRS, SSAS, T-SQL, Windows 2003 Server, Erwin, DTS (Data Transformation Services)

Confidential, Chennai, India June'06 - Mar'07
SQL Programmer

Description: Confidential, is India\'s second-largest bank with total assets of Rs. 3,634.00 billion (US$ 81 billion) at March 31, 2010 and profit after tax Rs. 40.25 billion (US$ 896 million) for the year ended March 31, 2010. The Bank has a network of 2,528 branches and has a presence in 19 countries, including India.

Responsibilities:

• Created new views, wrote 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 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.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.
• Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2005.
• Created database objects for improving the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Involved in creating SQL reports.

Environment: SQL Server 2000, T-SQL, Erwin, TOAD.