SUMMARY

• A Microsoft certified Professional with 6.5 years of experience in Design, Development, Implementation, Reporting and Analytics in OLTP/ETL environments using MS SQL Server 2008/2005/2000 across all SDLC environments
• Strong SQL development skills including writing Stored Procedures, Triggers, Views and User Defined functions
• Involved in Database Design, Data modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models
• Very Good Experience in Business Intelligence applications using DTS/SSIS/SSAS/SSRS
• Handled ETL process development, implementation and Support for Terabyte+ datawarehouse environments
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services ( SSIS ), DTS, Bulk Insert utilities
• Extensively worked on upgrading DTSàSSIS packages and Involved in Development, Deployment and support of SSIS packages
• Experience in using Audit functions and extensively used exception handling for catching and reporting errors
• Extensive Experience in creating enterprise reports using SSRS 2005/2008 using Report Manager, Report Builder, BIDS
• Created many Drill through,Drill Down,parametrized reports using SSRS 2005/2008
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Excellent Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi - dimensional models for developing SSAS Cubes using MDX.
• Experience in designing, building and deploying cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS 2005/2008)
• Expert in calculating measures and dimension members using MDX, mathematical formulas, and user-defined functions.
• Have hands on Experience in Performance Tuning and Query Optimization. Worked on Identifying and resolving blocking and deadlocks.
• Extensively worked in Migration for MS SQL 2000 to MS SQL 2005 à MS SQL 2008
• Worked with different types of Replication Models like Transaction, Snapshot and Merge
• Experience working with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor
• Hands on Experience working with Oracle databases
• Excellent communication skills, Analytical skills. Team Player

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, C, C++, HTML, DHTML, XML

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

Database Tools: SSRS, SSIS, SSAS, DTS, BCP, Business Intelligence Studio(BIDS), Query Analyzer, SQL Management Studio, SQL Server profiler, SQL Enterprise Manager

Operating Systems: Windows 98/2000/XP/NT/Vista, Windows 2000/2003 Advanced Servers, UNIX

Architecture: Relational DBMS, Client-Server Architecture

Version control Tools: Rational Clear Case, Visual Source Safe

Other Tools: Cognos, Crystal Reports, Microsoft Visual Studio 2003/2005

PROFESSIONAL EXPERIENCE

Confidential, Itasca, IL

Sr.SQL Server/BI Developer

Responsibilities:

• Gathered end user requirements and developed applications and different Audit functionalities depending on the Requirement acting both as a system analyst and an application developer
• Extensively studied the existing OLTP system(s) to create data mart and warehouse systems using the facts, dimensions and star schema
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2005.
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Created Data-driven Packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases and into Gallagher servers using SQL Server Integration Services (SSIS).
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and batch (.bat) files on a day to day basis.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Developed many MDX queries for creating calculated measures that fits business logic.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one web part page.
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data-sources.
• Involved in supporting more than 20 Users for various Reporting and Analytics requirements across multiple Business Units and departments.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SSIS, SSRS, SSAS, Oracle 9i and 10g, .NET Framework, C#, ASP.NET, ADO.NET, Share Point, Crystal Reports, Erwin, T-SQL, Java, J2EE, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access, Visual Studio 05

Confidential, Mason, OH

SQL Server/BI Developer

Responsibilities:

• Wrote user requirement documents and developed Functions, Stored Procedures, Views and Triggers for automation
• Created Databases, Schemas, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints
• Worked with Exception Handling with @@error and with Try/catch in procedures and packages
• Wrote efficient Stored Procedures for the optimal performance of the system
• Responsible for creating datasets using T-SQL and Stored Procedures
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• Hands on experience in using DDL Triggers to keep track of data manipulations using Audit functionalities
• Created packages in SSIS and upgraded several DTS Packages to SSIS.
• Have good hands on experience working with various components in SSIS and used Configuration Manager to retrieve the passwords.
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Lookup, Merge Join, Conditional Split, Slowly Changing Dimensions, and Data Conversion etc) in SSIS Package Development.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Used .Net and OLEDB with ODBC to create connections
• Involved in building the Cubes for various departments and monitored cube loads and refreshes.(Process full and Incremental loads)
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Dimensional modeling. Created relationships between Dimensions and Measure groups
• Responsible for identifying KPIs in SSAS and Built MDX queries for Analysis Services & Reporting Services.
• Experience in Designing, Building the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS) for analyzing purpose
• Designed and developed more than 100+ enterprise reports (SSRS/Crystal Reports) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Created complex reports like Cascaded reports, Sub reports, Drill Down and Drill through reports using SSRS 2005/2008
• Created Ad-hoc reports and data driven subscription reports by using Report Builder in SSRS
• Generated and formatted reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using SSRS
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous RDBMS sources like Oracle, ADSI and other OLEDB data sources.
• Created and published Analytical reports by using ProClarity tool and Performance Point Server 2007.
• Integration of dashboards using MOSS 2007 and various custom webparts

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SSIS, SSRS, SSAS, Oracle 9i and 10g, .NET Framework, C#, ASP.NET, ADO.NET, Share Point, Crystal Reports, Erwin, T-SQL, Java, J2EE, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access, Visual Studio 05

Confidential, Salem, VA

SQL Server/BI Developer

Responsibilities:

• Helped in the Installation and configuration of MS SQL Server
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions for all the database change requests
• Generated weekly, monthly and quarterly reports using SSRS Reports and scheduled delivery of reports through Emails
• Fine tuning of stored procedures to improve the performance using best coding practices, proper indexes and ANSI standards
• Wrote database triggers in T-SQL for auditing and integrity checks on the database.
• Used Exception handling to catch and report the errors
• Responsible for writing some PL/SQL queries, triggers and stored procedures to be used on Oracle databases
• Monitored and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Used DTS packages to implement Extraction, Transformation and Load (ETL) and scheduled the packages using SQL Server Agent
• Used various transformation tasks to create ETL packages for Data Conversion
• Involved in development of ETL Scripts extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding data marts
• Modified existing SSIS packages to meet current business needs
• Wrote stored procedures to be used in the SSIS packages
• Involved in the Code Review sessions and reviewed cubes, changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
• Extensively involved in theSSAS storagemethods (MOLAP, HOLAP and ROLAP), partitions, andaggregations, calculation of queries, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed Reports Scorecards, KPIs and Dashboards using Performance Point/ SharePoint
• Created custom and Adhoc reports using SSRS and identified and worked with Parameters for parameterized reports in SSRS
• Designed and developed matrix and tabular reports with Drill Down, Drill through and drop down menu option using SSRS.
• Designed and Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports and MS Reporting Services based on the complexity of the report

Environment: MS SQL Server 2000/2005, SSRS, SSIS, Oracle 9i and 10g, Business Intelligence Development studio, T-SQL, Crystal Reports, Visual source safe, Visual studio 2005, Erwin, Java, J2EE, C#, ASP.NET, VB.NET, MS Excel, MS Access

Confidential, Tulsa, Oklahoma

SQL Server /SSRS/SSIS Developer

Responsibilities:

• Wrote T-SQL queries, triggers, functions, cursors and stored procedures
• Involved in database design, normalization, de-normalization in building the Data warehouse and Reporting systems
• Responsible for creating Constraints and Indexes
• Created views to restrict access for the security of data in a table
• Catching and Reporting errors using exception handling
• Monitoring the performance of the scheduled jobs and alerts
• Performance tuning and testing on stored procedures, indexes and triggers
• Performed the Data Modeling using the ER diagrams using ERWIN.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Developed, monitored and deployed SSIS packages.
• Used SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts and ensured that the packages doesn’t encounter performance issues.
• Develop DTS packages to extract and transform data
• Used various transformation tasks to create ETL packages for Data Conversion
• Imported flat files into database by performing Bulk data migration using DTS
• Extract and transform data by developing packages using DTS
• Generated reports using SSRS
• Used SSRS Reports and Crystal Reports to create reports based on SQL Server database for various forecast reports
• Used SSRS to create Drill-Down and Drill-through reports
• Connected OLE DB data sources and providers by creating Linked servers

Environment: MS SQL Server 2005/2000, SSRS, SSIS, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005, Crystal Reports, Java, J2EE, C#, ASP.NET, ADO.NET, XML

Confidential, Corpus Christi, TX

SQL Server Developer

Responsibilities:

• Participated in designing, coding, testing and implementing user interfaces, procedures and functions for new and existing software application requirements
• Responsible in writing the stored procedures, triggers and functions based on the business requirement.
• Integrated Crystal Reports with SQL Server 2000 and Access databases
• Responsible for creating datasets using T-SQL and Stored Procedures
• Fine tuning the stored procedures and SQL queries for optimal performance
• Involved in database normalization and de-normalization
• Used SQL server agent for scheduling jobs and alerts
• Developed DTS packages to extract and transform data
• Created DTS package to get data from different data sources, consolidate and merge in to one single source
• Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers
• Responsible for creating and implementing logins and user permission to databases
• Created technical design document for the project
• Imported and exported flat files using Bulk Copy Program (BCP) extensively to/from SQL Server
• Had a chance to implement different types of Replication Models like Transaction, Snapshot and Merge

Environment: MS SQL Server 2000, T-SQL, DTS, ASP.NET, Access 2000 & Windows 2K platform, MS Excel, Crystal Reports

Confidential

SQL Server Developer

Responsibilities:

• Installation of SQL Server on Windows 2000 Advance Server
• Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers
• Responsible for creating the tables, views, stored procedures, Cursors, triggers
• Participated in creating indexes to improve the performance of database
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries
• Created Constraints, Defaults and Views
• Generated reports using Crystal Reports
• Used Data transformation Services(DTS) to export and import data
• Assisted in taking database backup and restored them and also resolved issues related to it.
• Used SQL server profilers to trouble shoot the issues and checked the activity of the SQL server.
• Involved in creating users and assigning permissions to access the database
• Experience in documenting the codes for easy understanding in future.

Environment: MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, Crystal Reports