SUMMARY

• Over 7 years of IT experience with SQL Server Development
• Also have equally good experience working as a BI Developer
• Well acquainted with all the phases of SDLC (Software Development Life Cycle)
• Over 5 years of experience with Business Intelligence Technologies like SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services) of MS SQL Server 2005/2008
• Efficient in migrating DTS packages, reports, analysis services project from SQL Server 2000 to SQL Server 2005/2008
• Worked on normalizations of a database
• Worked on Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services in SQL Server 2005/2008 and DTS in SQL Server 2000
• Very proficient in the using the Data Manipulation Language and Data Definition Language
• Extensive usage of stored procedures, tables, triggers, functions and views
• Worked on SQL Server Agent for scheduling jobs and DTS packages
• Designed and scheduled complex SSIS packages for manually transferring data from multiple data sources to SQL Server
• Expert in creating reports using SQL Server Reporting Services by creating OLAP cubes
• Written a number of MDX queries
• Experienced in performance tuning and query optimization
• Also worked with .NET, C# and HTML while creating web pages
• Excellent experience from working in different sectors namely, Financial, Health, Insurance and Banking
• Worked with other developers and DBA’s
• Also worked in close proximity with the Business Analysts
• Strong problem solving skills and an excellent team player
• Strong communication skills when communicating with other developers, DBA’s or project managers

TECHNICAL SKILLS

• SQL Server 2000/2005/2008
• SQL Server Management Studio
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Cubes
• MDX
• OLAP
• DTS
• Visual Studio 2000/2005/2008
• MS Access
• Microsoft office 2003/2007
• BCP
• SQL Server Agent
• Data Analysis
• C/C++
• C#
• .NET Framework
• Visual Basic
• HTML
• XML

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge, NJ

MS SQL Server Developer

Responsibilities:

• Written many complex stored procedures to assist the data import and export
• Involved in building tables, updating these tables
• Worked with functions, indexes
• Kept a check on the performance of the query
• Worked with SQL Server 2005 version
• Worked with Oracle Database when exporting data to a SQL Server Database
• Involved in building reports and populate the data into power point dynamically
• Involved in Scheduling jobs and Altering using SQL Server Agent
• Written a number of T - SQL queries and a number a nested queries
• Created reports using Excel
• Also worked with enterprise manager in SQL
• Worked on SSIS packages in SSIS, DTS Import/Export for transferring data from other databases
• Imported data from excel sheets into SQL Server
• Used Visual studio to analyze the reports using SSAS
• Performed a lot of analysis from the reports
• Worked extensively with OLAP cubes to access the size of the database
• Written some MDX queries
• Worked extensively with fact tables, measures, dimensions while creating cubes
• Used cubes for the analysis of the data for a particular requirement
• Created test cases from project documentation that can be understood to anyone with a vast knowledge of application
• Deployed a number of reports on the server and also deployed them on a SharePoint server
• Created web pages using .NET and deployed all the reports on these
• Ensured test cases are mapped to the requirements
• Met project schedule deadlines for several complex projects
• Report daily testing status using the Standard test status analysis

Environment: MS SQL Server Developer 2005 and 2008,Oracle, MS SQL Enterprise manager, SQL Server Analysis Services, SQL Server Reporting Services, MDX queries, Import/Export, OLAP Cubes, T-SQL, SharePoint, .NET

Confidential, Chicago, IL

BI Developer/SQL Server Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2005
• Actively supported business users based on their requirements
• Identified the database tables for designing the queries for reports
• Monitored performance and optimized the SQL query for maximum efficiency
• Identified and defined the datasets for report generation
• Implemented calculated members and actions such as URL actions, Report actions and Drill Through actions in SSAS 2005
• Written queries for drill down reports
• Extensive usage of Data Definition Language and Data Manipulation Language
• Identified and included report parameters and formatted reports using global variables and expressions. Deployed the reports onto the server
• Defined attribute properties in Parent Child Dimensions
• Responsible for hiding and disabling the attribute hierarchies
• Maintained data integrity by performing validation checks, tuned and monitored server performance
• Written T-SQL, MDX queries for data retrieval
• Fine-tuned the database objects and server to ensure efficient data retrieval
• Created views, several stored procedures and modified them according to the specifications
• Created several other database objects like tables and indexes
• Worked on Data warehousing, Data marts based on Star and Snow flake schemas
• Extensive usage of Drill mode and Slice and Dice techniques to modify the reports according to the user’s analysis requirements
• Active involvement in planning, documentation and administrative tasks
• Deployed 12 reports over a week’s deadline

Environment: MS SQL Server 2005, SSAS 2005, SSRS 2005, MDX queries, Optimization, Calculated members and actions, Data warehousing, Parent child dimensions, Attribute Hierarchies

Confidential, Kansas City, MO

MS SQL Server Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements collection, Design and Analysis of the customer specifications, Development and Customization of the application
• Worked with the 3-Tier Architecture which includes the presentation layer, business logic layer and the database
• The presentation layer was the front end which included creating web pages and the database acted as the back end
• Created all the tables for patient’s information, doctor’s information, medical information and all the relevant information
• Actively involved in Normalization (3NF) and De-normalization of the database
• Created several complex stored procedures and triggers using SQL Server 2005 to retrieve data
• Used MS Visual Source Safe 6.0 for the source control
• Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS
• Analyzed the requirements and finely tuned the stored procedures to improve the performance
• Documented the SQL Server Integration Service Standards to be followed
• Implemented the DTS packages in SSIS to transfer and load the data
• Handled Query Optimization by making extensive use of Index Implementation and Index Tuning Wizard SQL Server 2008
• Used SQL Server Reporting Services (SSRS) 2005 to query the databases to generate different types of complex ad-hoc reports
• Worked on DTS package in SSIS, DTS Import/Export for transferring data from heterogeneous databases

Environment: MS SQL Developer 2005, SSIS 2005, Cubes using SSAS, DTS packages, Query optimization, tuning, MDX queries, T-SQL Queries

Confidential, West Chester, PA

MS SQL Server Developer/BI Developer

Responsibilities:

• Involved in the designing, development, modification and enhancing the database structures and database objects
• Developed logical and physical data models, design access strategies and write SQL code to access and manipulate data stored in OLAP databases
• Created SQL Server Analysis projects, multi-dimensional databases, OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures
• Created numerous Data Transfer Services (DTS) packages in Microsoft SQL Server 2000
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2005
• Created web pages for the frontend using HTML
• Transferred data into various formatted files and updated my manager with the automated email systems
• Wrote several complex stored procedures for efficient handling of the application
• Debugged and optimized several complex stored procedures
• Tuned several slow running queries in production
• Implemented Indexes and used Re-Indexes to achieve time performance
• Constructed cubes based on data volumes mostly adhering to Star Schema
• Eliminated the old analyzed data to provide more data space on production
• Created different types of reports including Cross-tab, Conditional, Drill-down, OLAP and sub reports
• Based on the user input, modified the report content and exported reports in multiple formats
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports
• Identified and worked with parameters for parameterized reports in SSRS 2005
• Developed daily, weekly and monthly reports and published them on the company’s intranet

Environment: SQL Server Developer 2000 and 2005, Stored procedures, Cubes, MDX queries, SSRS deployment, OLAP databases, Indexes, SSRS 2005, SSAS 2005, Oracle, HTML

Confidential, Carson, CA

SQL Server Developer/Data Analyst

Responsibilities:

• Maintained data flow and error logs
• Checked/Tested the EDI exception bucket and fixed the problem
• Supported backend of the TLSDB (Transload System Database)
• Created complex stored procedures and functions to maintain efficient data storage and manipulation
• Optimized the performance of queries with modification/revision in index system for TLS
• Created data reports using SQL Server Query Analyzer, Crystal Reports and Excel 2003
• Created stored procedures for faster access of information and smoother flow of data
• Wrote stored procedures for ad hoc, daily and weekly reports
• Created custom stored procedures and functions to support various new operations
• Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning wizard
• Participated in different testing and debugging for the system
• Documented all processes involved in maintaining Database for future reference

Environment: SQL Server Developer 2000, T-SQL, DTS packages, stored procedures, Reporting Services