POFESSIONAL SUMMARY:

• SQL Server BIDeveloper having around 8 Years of experience, well versed in all phases of Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment).
• Good experience in analysis, design and development of client/server, web based and n- tier application
• Hands on Experience with Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Proficiency in creating different types of reports such as Ad-hoc, Cross-Tab, Conditional, Drill-down, interactive, Cascading, Top N, Summary, Form, OLAP, Sub reports, Chart reports and Matrix reports with conditional formatting in SSRS.
• Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like DTS and SSIS (2005 / 2008) Packages with proper control & data flow elements.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.
• Worked with report builder tool 3.0/2.0/1.0
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database
• Hands on experience in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in SQL Server development with good T-SQL skills with use of database objects, stored procedures, triggers, functions.
• Worked in Data modeling, creating star and snowflake schemas in SSAS using tools such as Erwin.

Certificate of Excellence:

• 70-431 Microsoft SQL Server 2005 – Implementation and Maintenance
• 70-445 Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance

Education Qualification:

• Bachelor of Engineering inComputer Science and Engineering

Technical Skills:

Operating Systems:

Windows Vista Business / XP Pro. / 2003 / NT / 9.X

Programming:

C#. Net, VB.Net, ASP, C, C++, ADO.NET

Scripting Language:

Java Script, VB Script

Databases:

MS SQL SERVER 2008 / 2005 / 2000, MS Access 2003, Oracle, DB2

SQL Server Tools:

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Enterprise Manager, Import and Export Data wizard, SQL Server Business Development studio (BIDS).

ETL Tools:

SQL Server Integration services (SSIS) [2005 and 2008], Data Transformation Services (DTS)

Analytical Tools:

SQL server Analysis Service (SSAS), Performance Point Server 2007.

Reporting Tools:

SQL server Reporting Services (SSRS) , Crystal Reports

Data Modeling Tools:

Erwin, Visio, MS Access

Web server technology:

IIS

Hardware:

EMC DMX & IBM Fast T 700 Storage Area Network (SAN), Compaq Proliant 8000, 6500, 6000

Professional Experience:

Client: Confidential, April‘2012 – Till date

Location: Sacramento, CA

Job Title: SSRS Developer/ SQL DBA

Description:
Confidential,is a non-profit technology and policy solution provider connecting low-income families to programs and services.
Responsibilities:

• Involved in Managing and scheduling daily jobs related to data transfers,backup and Recovery.
• Monitored and scheduled existing/new jobs on production environment.
• Responsible for Query optimization and Performance tuning, SQL queries using Show Plans and Execution Plans.
• Implemented and introduced control process, security policies and procedures.
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.
• Deploying database objects from development/testing environment to production environment.
• Generated and debugged complex stored procedures and functions for better performance and flexibility.
• Modified current database by adding tables, altering referential integrity and relationships to support the control system
• Optimized SQL queries for efficiency and assisted the front-end developers with their queries and procedures.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected
• Created indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Performed performance tuning by analyzing indexes, queries, table sizes, etc and heavy utilization of SQL Profiler and query execution plan tools.
• Used Triggers to generate customized error messages
• Developed Stored Procedures and Views to be used to supply the data to the reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Assisted team with data validation, statistical analysis, data migration and complex reports.
• Created various complex reports and manage those using SQL Server Reporting Services.
• Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Environment: SQL Server 2005/2008 Enterprise Edition, MS SQL 2008 r2, SQL Server BI Suite(SSRS, SSIS and SSAS), SQL Server 2008 Query Analyzer, Profiler, MS .Net Framework, Microsoft Visual Stuidio.NET 2005, ASP.NET, ADO.NET, C#.NET XML, MS Project, MS EXCEL 2007, MS Access 2003 & Windows Server 2008

Client: Confidential, March’ 2011 – March’ 2012 Location: Minneapolis, MN Job Title: SSRS/ SQL Developer

Description:
Confidential,is most trustworthy source of benefit administration services. Being trusted involves both possessing character and possessing the right skills and capabilities to provide extraordinary outcomes for our clients. Our trustworthiness as a partner and provider is guided by the following fundamental beliefs that guide every aspect of our services, leadership team and operations.
Responsibilities:

• Developed optimized stored procedures, T-SQL queries, User Defined Functions (UDF), Cursors, Views and Triggers , SQL Joins and other statements for benesmart reporting Application, maintained referential integrity and implemented complex logic .
• Enhancing the layouts available for the reports in the BeneSmart application
• Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#.NET, ADO.NET, ASP.NET.
• Perform including filters to the reports and make it parameter-driven
• Perform including SQL Agent jobs to update source of data by use of SSIS package.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Deploying the reports to staging server prior to business user acceptance testing.
• Perform including security to the reports and data in the application
• Implement updates of reports in BeneSmart application to recognize same-day data updates/changes.
• Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database
• Expert in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Sound Knowledge in ADO.NET to communicate with database for retrieving, accessing, and updating data.
• Proficient withDynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: SQL Server 2005/2008 Enterprise Edition, MS SQL 2008 r2, SQL Server BI Suite(SSRS, SSIS and SSAS), SQL Server 2008 Query Analyzer, Profiler, Microsoft Visual Stuidio.NET 2005/2010, ASP.NET, ADO.NET, C#.NET XML, JQuery, MS Project, MS EXCEL 2007, MS Access 2003 & Windows Server 2008, MS SharePoint 2007.

Client: Confidential, April’2010 – Feb’ 2011 Location: Freehold, NJ Job Title:SQL BI/ Dot net Developer

Description:
Confidential,formerly New Jeresey Bell Telephone Company, is the Bell Operating Company serving the U.S States. In 1984, the Bell System Divestiture split New Jersey Bell off into a Regional Bell Operating Company, along with the 21 other BOCs AT&T had a majority stake in. On January 1 1984, New Jersey Bell became part of Bell Atlantic
Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures, views using SQL Server 2008 and Windows Server 2008.
• Develop new processes to facilitate validation and create reports to show the business data to the users in form of reports.
• Dealt with database of terabyte size with complex stored procedures and views having multiple embedded procedures and views.
• Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
• Extensively used transformation of data between servers by creating linked servers and transforming data into table from a text file using BCP/Bulk insert method.
• Error handling application using SQL server profiler to trace information submitted to the server.
• Extensive use of Query Analyzer for performance tuning
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created package using various control flow and dataflow component for extracting data from the daily feed file and storing those information into table.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Worked intensely on the User Interface and developed Web Forms using Vb.net and ASP.NET
• Created custom control and user control to reuse the control more than once in an application.
• Developed Web Services exposing web method providing functionality that being used in application.
• Extensively used Repeater, Data Grid, Grid Views with sorting and paging
• Implemented Template Columns for Custom Nested Grid Views.
• Created SQL agent jobs to schedule the package, stored procedure and various processes to be executed at regular time intervals.
• Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
• Used HTML, JavaScript and AJAX for developing Controls and web forms
• Work with application developers and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server 2008 Query Analyzer, Profiler, Microsoft Visual Stuidio.NET 2005, ASP.NET, ADO.NET, VB.NET XML, JQuery, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008.

Client: Confidential, Aug’ 2009 – Mar’ 2010 Location: Raleigh, NC Job Title: SQL BI/ SQL Developer

Description:
Confidential,provides innovative solutions that empower all stakeholders across the healthcare continuum to deliver world-class outcomes. The company\'s clinical, financial, connectivity and information solutions for hospitals, physician practices and post-acute organizations are the essential technologies that enable a Connected Community of Health.
Responsibilities:

• Created package in SQL Server 2008 and Windows Server 2008 for extracting data located in multiple server having millions of data records(size of db used is terabyte) and loading it to data mart
• Designed the package logic to extract information and organizes it in an efficient manner to manage large volumes of data and run queries very efficiently.
• Created complex SSIS package using various control flow like Sequence container, Transfer SQL Server object task, Execute SQL task, Script task and various data flow transformation like Cache Transform, Lookup transform, Derived column, Multicast and For Each loop Transformation.
• Implemented table partitioning for flexibility and better performance where used objects such as multiple stored procedure, functions to implement logic in the SSIS package.
• Created pivot tables turns the values of a specified column into column names, effectively rotating a table
• Implemented Pivot Table to automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data
• Created several package with condition of running of successive package after complete successful run of previous package
• Created variable for connection string to supply the server name, user name, password, and database at run time.
• Created Linked server to moved data between different servers.
• Implemented error handling in package using script task getting error rows, error Description, message dynamically and moving them to a centralized table as well as sending message to support DBA via email.
• Successfully enhanced and deployed the SSIS packages from the developmental server to the production server.
• Loading data from various sources like Excel, flat files to SQL Server database Using SSIS Packages as well as loading data into flat file destination from multiple sources.
• Created scripts using C#.net and Vb.net to implement logic at various places in the package.
• Created configuration file to store package property in XML format to ease deployment of package.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, PPS, SharePoint, Crystal Reports, ASP.NET, ADO.NET, C#.NET

Client: Confidential, Jan’ 2009 – July’ 2009 Location: Boston, MA Job Title: SQL BI Developer (SSIS/SSAS/SSRS) Description:

Confidential,is a leading financial services provider, serving some of the world’s most sophisticated institutions. They offer a flexible suite of services that spans the investment spectrum, including investment management, research, trading and investment servicing. My responsibilities includes writing store procedures, design, develop and deploying SSIS packages. Designing cubes, building and maintaining reports from these cubes.

Responsibilities:

• Highly responsible for development and management of SSIS, SSAS and SSRS projects.
• Created Multiple Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Cascading reports, Drill down reports.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, FuzzyLook Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Created Reports that involve Dynamic Grouping and Sorting to provide information about the particular Sales regions.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
• Created joins and sub-queries for complex queries & store procedures involving multiple tables.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Implemented the project using ASP.Net, Visual C# as the front end and SQL Server 2005 as the back end Database.
• Developing the User-Interface Front-end screens in .Net 3.5 environment using C#.Net, Asp.Net JavaScript, HTML and DHTML
• Created and consumed Web Services using Visual C#, ASP.Net.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007,share point

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, VB.NET, ASP.NET, ADO.NET, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, PPS, SharePoint, Crystal Reports.

Client: Confidential,Jun’ 08 – Dec’ 08 Location: Greenwich, CT Job Title: SQL Server BI Developer Description:

Confidential,provides securities lending and broking services. The company was incorporated in 1995 and is based in Greenwich, Connecticut.
Responsibilities:

• Provided guidance and decision-making on client reporting needs oversee and participate in the development of the report technical designs as well as participate in the implementation of reports and testing activities
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization in order to increase the MDX query performance in Analysis Services 2005(SSAS)
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes
• Created calculated measures in a cube by using MDX scripting and worked on slowly changing dimensions.
• Created drilldown reports, Parameterized reports, Ad-Hoc reports in SSRS from multiple data sources including SSAS cubes.
• Hands on experience in rendering reports for online viewing, document management and for data exchange as excel, CSV file and XML file.
• Assisted team with data validation, statistical analysis, data migration and complex reports.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Worked in coordination with Development Team in deploying and testing the application
• Closely worked with the DBA to fasten certain daily jobs and stored procedure.
• Responsible for Query optimization and Performance tuning, SQL queries using Show Plans and Execution Plans
• Generated and debugged complex stored procedures and functions for better performance and flexibility.
• Created technical designs and user documentation.
• Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
• Worked with management to develop annual goals and training plans.

Environment:SQL server 2005 EE, SSRS, SSAS, SSIS, Windows 2003, MS .Net Framework VB.Net, DB2, SAP R/3.

Client: Confidential,Jan’ 08 – May’ 08 Location: Omaha, NE Job Title: SQL Server BI/ DBA Description:

The primary objective of Financial Accounting System is to build a centralized data warehouse that can be used by the Financial group and analyze profit and loss information of the organization by general ledger account, by time period, by services. I was involved in extracting data from various sources and transforming and loading into the SQL Server 2005 using SQL Server Integration Services (SSIS). All data are migrated to the staging server and then those data are later populated to the OLAP Server
Responsibilities:

• Assist the Development staff with the testing and implementation of the application.
• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Provide consultation to application development teams regarding the capacity planning of the database.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Create and test DTS packages for importing and exporting data from data warehouse
• Schedules jobs for DTS packages
• Troubleshoot SQL Server performance issues for internal and external customers.
• Monitor and record database activities.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring
• Create Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc from event viewer, SQL Error log files.
• Used T-SQL to create queries and stored procedures to produce reports for end-users
• Perform security configuration and administration
• Resolve locking conflicts and resource utilization.
• Configured Transactional Replication between the Production server and Reporting server and to move the data to servers in various locations.
• Configure Log Shipping for disaster recovery solutions
• Create Linked Server to transfer data to legacy systems
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Used Data Modeling Tools like Erwin, MS access and Microsoft Visio.

Environment: Windows 2003 Advanced Server, MS SQL Server 2000/2005, SSRS SSIS, SSAS, VisualBasic 6.0, Microsoft Office Excel 2003.