SUMMARY

• 7 + years of experience in IT, Financial and Insurance environments with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting
• In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• SQL Server 2000/2005 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).
• Good ETL skills, Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Expert in creating the MDX cubes and dimensions.(SSAS)
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard
• 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.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects
• 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.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert, ActiveX).

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS

RDBMS: MS SQL Server 2000/2005/2008/2008 R2, Oracle 9i/10g, MS Access

ETL: DTS, SSIS, Data Stage

Programming Languages: SQL,T-SQL,PL-SQL

Internet Technologies: XML, HTML

Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage

Operating System: Windows95/98, Unix, Windows 2000/NT/XP,MS DOS

Reporting Tools: Crystal Reports 11,10,9, SSRS

PROFESSIONAL EXPERIENCE

Confidential, McKinney, TX

SQL Server/SSIS Developer

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Created several database objects like UDFs and views as well as triggers in support of the project.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Developed SSIS packages not only for Initial Data Loads but also for incremental loads.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Set up package Configurations.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Created SSIS Packages to load Data from Existing Data Model to new Data Model and Data Ware House.
• Provided documentation for all kinds of SSIS packages.
• Schedule job using SQL Agent.
• Involved in requirement gathering, analysis, design and development.
• Participated in the stand up meeting as part of the Sprint.

Environment: SQL Server 2008 R2, SSIS 2008, TFS 2008, Windows Server 2008

Confidential, Washington DC

SQL BI Developer (SSAS/SSRS/SSIS)

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert
• 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.
• 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.
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Created the storage type (ROLAP),Created cubes for Business Intelligence
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in building and maintaining Data marts. Created roles for using the cubes
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created Data warehouse environment for OLAP & Data mining in SSAS
• Worked on multidimensional databases with use of OLAP tool in Data warehouse & SSAS
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Transferring data between XML document and SQL server
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports, Drilldown reports.
• Developed Dashboard reports with charts and graphs.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, XML, M/S PowerPoint, MS Excel, MS Project, Windows Server 2008.

Confidential, Cincinnati, Ohio

SQL BI Developer (SSRS/SSIS)

Responsibilities:

• Involved in Data modeling to develop the database design using Erwin 4.0
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Create and test DTS packages for importing and exporting data from data warehouse.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Involved in developing report using SQL Server Report 2008.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved on ProClarity’s powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
• Performance tuning and optimization of procedures and queries. Involved in the tuning of the existing Database Objects.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio and Database Engine Tuning Advisor.
• Created Business Objects reports (Master/Detail, Cross tab, Chart templates)
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Helped in Designing Business Models as per requirement for SQL 2008 Analysis Services cubes.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience with designing and enhancing OLAP cubes Using SSAS.
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
• Involved in creating Dimensions, KPI, Measures and calculations.
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2008.
• Created SQL Server Analysis Project using MS SSAS 2008.
• Created cubes in SSAS to be used as data source in the reports
• 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.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developing and extending the cubes with around 35 dimensions, about 10 measures, and 25 calculated members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema
• Exceptional hands on working knowledge and recent experience working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Identified and defined Fact relationships in SSAS, Created cubes and dimensions

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, Performance Point Server, ASP.Net, C#, IIS 4.0, Visio 2000, SQL Server Query Analyzer, SQL Profiler, ERWIN.

Confidential, Dunmore, PA

SQL Server Developer

Responsibilities:

• Installed and configured SQL SERVER 2008 enterprise edition per client request.
• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data about the cable layout, so as to meet the company specifications.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Exposed to data conversion from different data sources to SQL Server 2008 using SSIS.
• Experienced in data warehouse systems, ETL processes using DTS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2005/2008.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) Packages.
• Designed new SSIS packages and deployed them.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications

  Converting SQL Server 2005 DTS packages to SQL Server 2005 SSIS packages.

• Worked with DTS Packages on SQL Server 2005 and SSIS packages on SQL Server 2008 for the automation of day to day Maintenance Jobs
• Resolved the SQL Server 2008 upgrade hurdles and successfully Migrated SQL 2005 DTS packages to SSIS using Upgrade advisor and Package Migration wizard
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Expert in migrating DTS packages to SSIS packages using Upgrade advisor/Package migration wizard.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server .
• Integrated SQL Server 2005/2008 reporting services (SSRS) with Microsoft Office Share point Server
• Implemented the project using ASP.Net, Visual C# as the front end and SQL Server 2005 as the back end Database.
• Created and consumed Web Services using Visual C#, ASP.Net.
• Created and schedule SSIS packages to load the data from Financial Management system to data staging environment and then to Data Warehouse.

Environment: MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),: T-SQL, PL/SQL, Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, Oracle 9i, VBScript.

Confidential, Chicago

BI Developer

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Created the storage type (ROLAP),Created cubes for Business Intelligence
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in building and maintaining Data marts. Created roles for using the cubes
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Transferring data between XML document and SQL server
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
• 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 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, ERwin, XML, VB.NET, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• 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.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Regularly monitored the system for bottlenecks for CPU, RAM, Disk IO and Networking
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights

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 Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Thorough understanding of physical database design for constraints and data types for figuring out the sequence for modification (insert, update, delete) of data in various tables.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Implemented batch processing using Jobs and DTS.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Rules, Indexes, and Views.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
• Scheduled Jobs using SQL Server Agent.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, Tables, indexes and constraints on existing databases.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: SQL Server 2000, Microsoft Visio, Replication, Windows 2000/XP, IIS 5.0, ASP