Summary:

7 years of IT experience as a MS SQL Server Developer 2008/2005/2000 in various Industry verticals like Finance, Health Care and Insurance.

• Extensive experience in MS SQL Server 2008/2005/2000 with Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.
• Extensive experience in Data-Warehousing projects as a Business Intelligence developer worked in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) SQL Server 2008/2005.
• Extensive experience in MS SQL Server 2008/2005, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access.
• Experience in creating packages and report writing according to the business requirement in SSRS.
• Familiar with OLAP cubes and fact table, star and snowflake schemas
• Expert in creating, configuring and fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Expert in creating and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Extensively worked with Parameterized Reports, Report Snapshots, and Linked Reports and used Report Manager for deploying reports in SSRS (2000/2005/2008).
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Strong knowledge working with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

Technical Skill Set:

SQL Server Tools : BIDS 2005/2008, Management Studio, Enterprise Manager, Profiler, Query
Analyser, Export & Import (DTS), SSIS, SSRS, SSAS.
RDBMS : MS SQL Server 2005/2008, MS Access,Oracle Hyperion Essbase
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, Windows 2000/NT/XP, MS DOS
Reporting Tools : Crystal Reports 11,10,9, SSRS

Professional Experience:

Client: Confidential,Atlanta, GA March’11- Present
MS SQL Server Developer/SSIS/SSAS/SSRS Developer

Confidential,provides on a worldwide basis through operating subsidiaries and branch networks based in Bermuda, The United States, Canada, the United Kingdom, Ireland, Switzerland, Australia and Singapore.

Responsibilities:

• Involved with Data Architects and Business Analysts to take business decisions in designing New Data Model, EDW (Data Warehouse) and OLAP Data Model.
• Created SSIS Packages to load Data from Existing Data Model to new Data Model and Data Ware House
• Involved in designing complex packages moving data from various servers and environments using SSIS which also involved data from XML, Flat Files, CSV Files and SQL Server Databases.
• Performance tuning the SSIS Packages by understanding the Data Flow Buffers and by designing for parallelism.
• Involved in loading Dimensions and Facts in newly built data ware house which also involved Type 1 and Type 2 Slowly changing dimensions using SSIS.
• Deploying SSIS Packages on respective server and effectively using configuration files for using same packages on other environments.
• Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS which involves nightly maintenance.
• Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and lot more using SSIS.
• Designed dynamic reports on the newly developed ERM Model for financial data users using SSRS.
• Involved in Performance tuning the SQL Server Queries used in SSRS Report and also used Report Snapshots for better performance.
• Created user groups in Report Manager for limited access to the end users in SSRS.
• Developed Ad Hoc Report Model for specific users is SSRS.
• In SSAS, created cubes on top of the data warehouse for reporting purpose and wrote MDX.
• In SSAS, the cubes involved complex aggregations and MDX calculations for financial reporting purposes.
• In SSAS, the cubes were also optimized for performance due to the large time consumption in the processing.
• In SSAS, Roles were created on the cubes in such a way that only restricted users had access to the cubes.
• Closely worked with Data Quality team and Data Architects to identify bugs in the new Data Models and automated the Data Quality process which involved lot of T-SQL programming like Functions, User Defined Functions, Stored Procedures and Views.

Environment: MS SQL Server 2005/2008, BIDS, Management Studio(SSMS), ETL, DTS, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), XML DS, OLAP, Cubes, Data-warehousing, SQL Profiler, Windows 2003, SDLC, Proclarity.

Client: Confidential,Chicago Jan’10– Feb‘11
BI Developer/SSAS 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.

Client: Confidential,Chesapeake, VA Nov’08-Dec’09
MS SQL Server SSIS/SSRS/SSAS Developer

Confidential,is the leading US provider of speaker meeting logistics, commercial compliance management and sales force productivity tools for the health care industry. Fully integrated suite of hosted products and sales support services are custom designed for the needs of the clients, leveraging the vast industry experience to meet current and future needs.

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Involved in installation and configuration of MS SQL Server 2008.
• Created and modified complex TSQL batches/stored procedures.
• Defined Check Constraints, functions, indexes, synonyms and views.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Developed unit test plans for SSIS packages.
• Involved in migrating data from MS SQL server 2005 database to MS SQL server 2008 database.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Created MDX queries to extract data from the data mart.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using stored procedures that accept parameters.
• Responsible for monitoring and tuning SSRS Report Performance.
• Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server.
• Configured the report viewing security for various users at various levels using report manager.
• Fine tuned SQL queries for maximum efficiency and performance.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Provided documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.

Environment: MS SQL Server 2008/2005/2000,SSRS,SSAS,SSIS,T-SQL, MS Visio 2007/2003, Windows 2003/2000 , Advanced Server, Visual Source Safe (VSS), BIDS, Performance Point Server.

Client: Confidential,Bloomington, FL Sep’07- Oct’08
MS SQL Server Developer

Confidential,is an insurance company to help people manage the risks of everyday life, to recover from the unexpected, and realize their dreams. The project is to maintain the Production, Test and Development and Cluster Server Environments and support for developers in developing SQL queries. Worked as a team member with other DBA’s to ensure 24x7 support to the database.

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created the database for the reporting team.
• Migrated the data from various sources using DTS and created backup and restore operations.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created ad hoc T-SQL queries and solved various T-SQL issues using Query analyzer.
• Created database triggers to implement business requirements.
• Created complex stored procedures and functions to support the front-end application.
• Optimized SQL queries for improved performance and availability.
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases.
• Ensured data recovery, maintenance, and data integrity and space requirements for physical database.
• Reorganize database structures as needed, automate procedures at regular intervals.
• Optimized long running stored procedures and queries for effective data retrieval.

Client: Confidential,Chennai, India July’06– Aug’07
SQL Server DBA

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

Client: Confidential,Bangalore, India May’05-June’06
SQL Server Developer

Responsibilities:

• Experienced in rebuilding and transferring new database
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Managed database security and implemented encryption/compression for sensitive data in the database
• Troubleshoot Third party Data migration, DTS, Backups and restore, tune up systems, upgrade
• Performed Database Search and Query Strategy design, implementation, testing, and optimization.
• Performed Stored Procedures development and testing, as well as Database Report design and implementation
• Export data in Excel to SQL Server 2000 via DTS
• Run daily, weekly and monthly reports for management consumption.
• Wrote optimized T-SQL stored procedure to improve performance.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Environment: Windows 2000, SQL Server 7.0/2000, Enterprise Manager, SQL Profiler, DTS, T-SQL, BCP,
Replication.

Education:

Bachelor of Engineering