SUMMARY

• 8+ years of Experience in use and development, design, support and migrate of Microsoft SQL Server
• Versatile in working with SQL Server2010 Enterprise Manager, Query Analyzer, Profiler, SQL Server2010 Management Studio, SQL Server Analysis Services(SSAS), & SQL Server Reporting Services
• Wrote Server - side Stored Procedures and Triggers, formulated Backup/Recovery strategies, Optimizing Query Plan, Performance Tuning.
• Good Knowledge in DTS Import/Export Wizard, Index Tuning Wizard, Replication Sync Manager (Replication Wizard), SQL Server Management Studio, SQL Profiler and SQL Query Analyzer.
• Experience in designing Logical and Physical Modeling using ERWIN and ER Studio.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions.
• Experience in Creating SSIS package development and implementation for different tasks.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expert in creating SQL Server Reports using SSRS 2010 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.
• Extensively used Report Wizard and Report Manager for developing reports and deploying reports in SSRS.
• Experience in writing Type-1 and Type-2 Stored Procedures in DW environment and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data.
• Used DB2 as source system to pull the data and loaded into SQL Server.
• Very strong experience in ad-hoc reports, Tabular and Charts reports in SSRS. Proficient in writing PL/SQL procedures with experience with Cursors, Collections, Nested Tables, Bulk Processing.Background with optimizing existing jobs using SQL & PL/SQL tuning techniques and toolkits

TECHNICAL SKILLS

Databases: MS SQL Server2005,2008,2010 … MS Access

Programming Languages: SQL, T-SQL, basic MDX, C,C#, XML Business Tools Word, Excel, PowerPoint, Access, Visio, Outlook

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, Import/Export Wizard, SQL Mail, SSMS

Reporting Tools: Reporting Services (SSRS) … MS Access, Excel, Data Analyzer.

ETL Tools: SSIS … SQL Query Analyzer, SQL Enterprise Manager

Operating System: Windows 2000 Enterprise/Advanced Server, Windows Server 2003, XP Professional, Windows 7

PROFESSIONAL EXPERIENCE

Sr.SQL Developer

Confidential, Chicago, IL

Responsibilities:

• Created PL/SQL packages, procedures and functions to implement the business logic.
• Written T - SQL codes for the project.
• Created Stored Procedures for Batch Processing.
• Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading (ETL).
• Develop and modify the SSIS packages for ongoing data support.
• Added/Changed Tables, columns, triggers using TSQL.
• Worked with Business Objects and SSRS.
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Developed, maintain, and support the enterprise data warehouse using SSIS and SSRS system throughout the SDLC.
• Deliver SQL server reports to SharePoint to enhance team collaboration
• Generated reports according to business requirements using crystal reports and reporting services 2005.
• Created monthly reports using reporting wizard with Visual Studio
• Assign Reports to Report Folders in SQL Reporting Services
• Involved in Scheduling backups and maintenance.
• Upgrade DTS packages to SSIS.
• Created indexes to improve the performance of the queries
• Create backups and restore of the databases.
• Used data conversions to convert different data types
• Created Views for Extracting Data using TSQL.
• Performed Migration of databases from SQL 2005 to SQL2010 extensively used Joins and sub-Queries to simplify complex queries involving multiple tables. Configured various Publishers and Subscribers for Snapshot and Merge replications using TSQL.
• Created Distributed Partitioned Views, Troubleshooting Stored Procedures, and upgrading existing ones. Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.

Environment: MS SQL … SharePoint Windows NT/2000/XP,PLSQL, SSAS, SSIS, SSRS, Crystal reports Visual studio 2010, ASP 3.0, Business Objects, ORACLE 10g, MS Excel(Creating reports), SQL Query Analyzer, Enterprise Manager, MS Access.

SQL Server Developer

Confidential, Atlanta, GA

Responsibilities:

• Created Stored Procedures, User Defined Functions for databases.
• Developed complex T - SQL code for the application conversions.
• Actively involved in migration of DTS packages to SSIS packages.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Worked with SSIS to import, export and transform the data between the servers.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Used the Report Manager to create folder structures, modify data sources, controlling access to Report Services resources.
• Develop and deliver dynamic reporting solutions using SQL Server 2010 Reporting Services (SSRS)
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Developed Various Reports like Charts, Matrix, Tabular, and Cross Tab using SSRS.
• Writing Stored Procedures, Performance tuning the reports using SQL Profiler for SSRS Reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Developed Financial Reports using SSRS Report Designer.
• Developed Various reports involved in Tabular, Matrix, Ad-hoc, Drill down reports using SSRS.
• Developed reports involved in Passing parameters and cascading parameters using SSRS
• Built and Deployed reports on the server using SSRS Report Manager.
• Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services.
• Implemented Data Mining using decision trees, association rules, k-means clustering. Familiarity with Data warehousing and analysis skills such as ETL tools.
• Involved in developing staging database that is used for loading fact tables and handling calculations and validations.
• Designed OLAP cubes, MDX coding, Data Modeling, Star Schema, and KPI efficiently for Analysis Services for Decision Makers.

Environment: MS SQL Server 2010 … Enterprise manager, Management Studio, DTS, Integration Services, Reporting Services, SSRS, OLAP, Data Modeling, Analysis Services, T-SQL, DB2, Windows 2003, Tuning Advisor, ETL, SQL Profiler, SQL Server Agent, Data ware Housing.

MS SQL Server Developer\BI Developer

Confidential

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation.
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst.
• Analyzed the business requirement and functional specifications provided by the data specialist.
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Created ad Hoc and parameterized various reports using SQL server 2008 reporting Services with data from SQL Server and MS Access as data sources.
• Generated dynamic Reports from the cube using SSRS 2008, and stored procedures.
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server 2008 environment and accomplished data modeling.
• Designed and architected of cubes for building reports using SQL Server Business Intelligence Development Studio to support business reporting and forecasting processes.
• Developed and designed cubes with around 45 dimensions, about 25 Measures and 20 calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi - Dimensional Expression (MDX) to access them.
• Designed and built the dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages, and the relationship between the source tables and the OLAP tables used in the SSAS Cube.
• Created ad hoc SSRS reports in the test environment for data validation.
• Troubleshoot the deployment of reports in the test and production environment using SSRS.

Environment: MS SQL Server 2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Visio.

MS SQL Developer/ SSRS Developer

Confidential

Responsibilities:

• Actively supported business users for change in requests.
• Created SQL server Reports using SSRS 2008.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Knowledge of write MDX queries to execute the data from analysis services OLAP cube.
• Involved in Designing Aggregations and pre - calculating the same in SSAS identified the data source and the data source views.
• Responsible for working with performance tune reporting services.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Working with .NET framework and C# with the using Visual Studio.
• Created complex Stored Procedures, views, Triggers, Tables and other SQL joins.
• Responsible for deploying the generated reports directly on client's work stations.
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance using SQL Profiler.
• Fine-tuned database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server … MS SQL Server Reporting Services … .NET framework, C#, Windows XP