SUMMARY

• Over 8 years of extensive IT experience as a Microsoft SQL Server 2000/2005/2008/2008 R2/2012(Denali). Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Telecomm, Finance and HealthCare in development, testing & production environment.
• Very good experience in Installation, Configuration and Maintenance of MS SQL Server database.
• Have Extensive experience in handling various challenging enterprise projects from Client Server application Design and Implementation in Microsoft technologies like SQL Server2005/2000 and SQL Server 7.0.
• Writing Complex T - SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries
• Programming in SQL Server Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive knowledge in Tuning SQL queries/SQL queries & improving the performance of the Database.
• Has a very good experience in creating SQL Server Integration Services (SSIS) packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experience in Transforming data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and also SSIS.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases using SSIS.
• Experience on Extraction, Transformation and Loading (ETL) process using DTS and MS SSIS application tools.
• Experienced in Microsoft SQL 2005/2008 Server migration from SQL Server 2000, and Reporting Service (SSRS).
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table 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.
• Extensive experience in report writing using SSRS and also creating various types of reports like table, matrix and chart report, web reporting by customizing URL Access.
• Experience and Expert in Generating on-demand and Scheduled Reports for business analysis or management decision using SSRS.
• Experience in Microsoft SQL Server Analysis Services (SSAS). Extracted the data from SQL Server databases using DTS and developed cubes in SSAS.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs. Regular overview on the performance of Database queries using Profiler and Event Viewer graphs.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Expertize in Excel Power Pivot and Power View Solutions.
• Hands on writing MDX queries and experienced in writing “DAX functions” to create Explicit Measures in Power Pivot.
• Hands on experience in troubleshooting database issues.
• Experienced in Database Backup and Recovery procedures.
• Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities.
• Quick learner and excellent team player, strong inclination for finishing job before project deadline and work under pressure.

TECHNICAL SKILLS

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

Database Application Software: MS SQL server 2012/2008/2005/2000, Oracle 8i9i/10g, MS Access 97/2000

ETL Tools: SQL Server Integration Services (SSIS)

GUI: DTS Import/Export, SQL Server Integration ServicesSQL Server Reporting Services, SQL Server Analysis Services

Application Software: Microsoft Office, Visual Studio.

Modelling Tool: Database Designer, UML, Visio

Operating Systems: Windows Vista/XP/NT/2000.

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Reporting Developer

Responsibilities:

• Worked as a Sr. SQL BI Developer co-ordinating between onsite and offshore teams
• Worked on gathering requirements from the business users who were the top few people including Vice President of the company.
• Used to obtain data and reports in general excel format including complex statistical calculations. Imported excel tabular data into SQL Server using Import Export wizard or SSIS depending up on the requirement.
• While using SSIS for moving the data, used multiple transformations as per design specifications.
• Simulated complex calculations from excel in SQL using Cursors and complex store procedures and created multiple Views from the data handles for users.
• Assisted in setting up new databases and schemas and also set up Linked Servers, to be able to cross query multiple databases.
• Worked on writing complex SQL to extract data from multiple databases. Worked on performance tuning of the old queries and store procs.
• Involved in setting up SQL Server Agent Jobs for timely updation of the tables on the linked servers to through SSIS and SQL store procedures.
• Worked on creating star schema, developed a dimensional model in power pivot, merged over 100 excel report views to come up with a single view using Excel Power Pivot with full functionality including automatic refresh and updation of the data.
• Extensively worked on reporting using Excel Power Pivot, developed multiple pivot charts and tables while improvising the old reports.
• Created multiple Explicit Measures using DAX functions for Power Pivot and also worked on writing MDX queries for customized additional functionality in reports.
• Developed mapping documents while extracting data from different sources and also working on documentation of the project.

Environment: SQL server 2008/2008R2/2012, Windows 2003 Standard Edition, Microsoft Visual Studio Team foundation server, SQL Server Integration Services 2008, MS-Excel 2003, Excel Power Pivot (1.0 and 2.0 versions).

Confidential, Baltimore, MD

SSRS Developer

Responsibilities:

• Worked as a Report Designer in this short term project.
• Responsible for gathering requirements from respective users.
• Analyzing the requirements & providing timelines on code changes by estimating the effort involved in accommodating the changes.
• Extracted data from the database to gather data required for further processing.
• Used this extracted data to build a Dashboard report which helps the client to monitor their business status.
• Designed matrix and tablix reports which also carry parameters to meet with end user requirements.
• Suggested additional properties that could be included in the dashboard to the client
• Demonstrated the final product to the users.
• Effectively coordinated and managed the off shore team.

Environment: SQL Server 2008, SSRS, Microsoft Share point portal

Confidential, Vernon Hills, IL

Sr. SQL BI Developer

Responsibilities:

• Installation of SQL Server 2008 R2 with the latest service packs.
• Migrated Database from SQL Server .
• Wrote stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Modified data model by adding tables and relationships to existing database.
• Involved in writing stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Did Data Conversion to obtain data in required data type and format from the Clients data.
• Used SQL Server Integration Services (SSIS) to create ETL Packages to validate, extract, transform and load data from Online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer
• Maintained records in Excel Spread Sheet and imported data into SQL Server Database using SSIS.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Identified and resolved problems encountered during development and execution of SSIS package.
• Used Tablix control extensively while building SSRS reports and also worked on different Tablix properties.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
• Created OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Used SQL Profiler for performance monitoring.

Environment: SQL server 2005/2008/2012, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, OLAP

Confidential - NY

SQL BI Developer

Responsibilities:

• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Utilized T-SQL developer tool in developing all back end database interfaces.
• Responsible for performing code reviews.
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Involved in Creating Migration of DTS Package to SSIS 2005 Package
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Migrated data from Heterogeneous Data Sources and legacy system (Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used Data Conversion task in multiple ways while creating packages using SSIS.
• Worked on performance tuning in SSIS to meet performance requirement using different concepts like Buffer-Oriented architecture, Buffer Sizing, Parallelism and lookup Transformations.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Extensively worked on Tablix Control in SQL Server Reporting Services 2008.
• 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).
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Identified the database tables for defining the queries for the reports in SSRS. Defined report layouts for formatting the report design as per the need. Identified and included report parameters for parameterized report in SSRS.

Environment: Visual Studio .NET 2005,.Net Framework 2.0,MS-Excel 2003, Microsoft SQL Server 2008, Analysis Services 2005,Reporting Services 2005,SQL Server Integration Services2005

Confidential

SQL BI Developer

Responsibilities:

• Installed and configured SQL Server 2005 successfully on Windows Server 2003.
• Worked on Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions(UDF’s) and other T-SQL (DDL, DML) statements for various applications.
• Create joins and sub-queries for complex queries involving multiple tables.
• Dealt with Fine-tuning Stored Procedures to improve performance that was achieved through SQL tuning advisor.
• Modified existing reports to Tabular SQL reports when the report performance was found to be below par.
• Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views.
• Worked on different kinds of transformations as per the client’s Requirement
• Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server 2005 environment.
• Created SSIS packages to load data from sources such as flat files, excel sheets, Access databases into SQL Server.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Designed the reports layout for creating tabular and matrix reports.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server 2005 Reporting Services (SSRS).

Environment: MS SQL Server 2005/2000, MS Access 2000, MS SQL Analysis Services 2005, MS Excel, Visual Studio 2005, Windows Server 2003

Confidential, Bloomington

MS BI Developer

Responsibilities:

• Performed SQL Server 2005 installation and configuration.
• Developed and optimized Stored Procedures, Views, and User-Defined Functions for the Application. Used DTS and stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created dynamic packages in SSIS to meet the requirements and created Database Maintenance Plans for the various data Sources and centralizing the data using SSIS.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Worked with control flow and work flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Worked with control flow and work flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Managed up-gradation of DTS packages to SSIS packages for ETL
• Created automated stored procedures for day end operations using SQL Server agent.
• Generated various reports with drilldowns, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Created ad-hoc reports for business users using SSRS using report builder
• Implemented security, scheduling and sorting, filtering, aggregation of report data.
• Involved in various stages of testing - UT, System Test, Integration Test, UAT.
• Used BCP for bulk loading the data.
• Supported OLAP team to providing data from SQL Servers in SSAS.
• Created OLAP Cubes using Star Schema and Snowflake Schema in SSAS.

Environment: SQL Server 2005, Oracle, MS Access, Excel, Tera Data, Windows Server 2005, Visual Source Safe

Confidential, Reno, Nevada

SQL Developer

Responsibilities:

• Developed DDL scripts for generating Tables, Views, and Functions in SQL Server 2005/2000.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views for applications.
• Created ERD (Entity Relationship Diagram) using Erwin tool.
• Involved in performance tuning.
• Successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Transformed the data using different transformations like Aggregate, split, join, merge, fuzzy lookup, derived column, and data conversion of SSIS.
• Used expressions and variables in SSIS to make load dynamic.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Worked on generating Report Models, Refining and Enhancing the Report Models, Deploying Report Model, Creating Reports on Report Models using SSRS.

Environment: MS SQL Server 2005/2000,Visual Studio 2005, MS SQL Server Management Studio,DTS-2000,SSIS-2005,SSRS-2005,Report Builder, Office, Excel, ERWIN

Confidential, Philadelphia, PA

SQL Developer

Responsibilities:

• Involved as an SQL developer with responsibilities such as requirement analysis, design, document, development and support of the Supply and Distribution module.
• Used Try catch and @@error for exceptional handling. Optimized SQL queries for better performance.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Created, tested and deployed SSIS Packages for data migration into Facts and dimension tables in the data mart from the source data warehouse tables.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services (SSRS) 2005
• Wrote stored procedures for report generation.
• Managed reports using Report Manager after deploying the reports to the report server
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Migrated some Crystal reports to SSRS reports.
• Identified and analyzed expensive stored procedure by using the SQL Profiler.

Environment: SQL Server 2005, SSIS, SSRS, Crystal Reports, ETL, Win 2000 Professional, Win Server 2003

Confidential

SQL Developer

Responsibilities:

• Performed Installation and Configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs.
• Developed back end interfaces using packages, stored procedures, functions, collections, object types and triggers.
• Used HINTS and analyzed QUERY EXECUTION PLAN to tune queries for better performance and created Indexes wherever necessary.
• Configured the data flow, the individual data flow elements and monitored the performance of the package.
• Responsible for transferring the data using SSIS packages.
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
• Transformed the data using different transformations like aggregate, split, join, merge, fuzzy lookup of SSIS.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Created different types of reports in SSRS such as parameterized, cascaded parameterized, Cross-Tab, Drill-down and Sub-Report.
• Involved in design, deployment, and maintenance of SSRS Reports.
• Created database maintenance plans for Full/Differential/Transactional backup strategies and involved in database partitioning.

Environment: MS SQL Server 2005 on Windows 2003 server, Visual Studio, SSIS, SSRS