PROFESSIONAL SUMMARY

• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• SQL Server 2000/2005/2008 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Modified the MDX query in the reports wherever necessary as per the requirement.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

AREAS OF EXPERTISE

Platforms

Windows Server 2000/2003/2008, Windows Vista/XP/2003/2000 UNIX, Linux, DOS

SQL Server Tools
&Packages/BI tools

SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL, SSIS, SSAS, SSRS, Erwin Data modeler

Applications

C/C++, HTML, XML, Visual Studio

Desktop

MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

Databases

SQL Server 2000/2005/2008, MS Access 97/2003/2005/2008

EDUCATION

Bachelor’s in Pharmacy, Confidential,University, Hyderabad, India.

PROFESSIONAL EXPERIENCE

Confidential,MD Feb 2012 to till
MS SQL Server / Programmer Analyst (SSRS Developer)

CareFirst BCBS is an Insurance company that provides various kinds of services to people in Maryland and Washington. CareFirst’s PCMH program is designed to provide primary care providers with a more complete view of their patients\' needs and of the services they receive from other providers so that they can better manage their individual risks, keep them in better health and produce better outcomes. The program requires greater provider-patient engagement and it meaningfully compensates providers for that engagement. Worked on the PCMH program in designing the report specs according to the specification requirements

Responsibilities:

• Experience in usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server 2008
• Analyzing and designing reports and reporting solutions according to the specifications given.
• Knowledge and implementation of Reporting Services and other MS tools and in combination to design report solutions to deliver on several CI projects.
• Meet deadlines while meeting the reporting needs of the business users and project owners.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Designed the SSIS packages with error handling.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Ad Hoc and Parameterized Reports using SQL server 2008 Reporting services.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports using Sql Server Reporting Services 2008.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Wrote the Visible Basic expressions in SSRS according to the requirement of the report developed.
• Reports were created according to the report specifications and make sure to submit the work assignment before the due time.
• Scheduling the jobs for monthly reports and yearly reports
• Worked on writing the T-sql code for the historical data to pull according to the specification requirement.
• Played a major role in production support of SSRS jobs.
• Perform T-SQL tuning and optimizing queries for Reports and SSIS packages.
• Assisted in Creating SSIS process design architecting the flow of data from various sources to target.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Use of version control system product of SERENA for all the sql related work.

Environment: MS SQL Server 2008, Micro Soft Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2007 (MOSS 2007Performance Point Server, MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential,Windsor, CT May 2011 to Jan 2012
MS SQL Server / BI Developer

PCG Education™ helps schools, school districts, and state departments of education to maximize resources, achieve their performance goals, and improve student outcomes. With more than two decades of K-12 consulting experience across the U.S. and in Canada, PCG’s expertise, capacity, and scale help educators to improve their decision making processes and achieve measurable results.

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server 2008
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on ProClarity for creating, analyzing and deploying Reports.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS 2008.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Experience in usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SharePoint Server 2007 (MOSS 2007), Erwin, OLAP, OLDP, MDX, Performance Point Server, MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential,Redmond, WA Oct 2010 – April 2011
SQL Server SSAS/SSRS/SSIS Developer

Microsoft Corporation is an American Public Multinational Corporation headquartered in Redmond, Washington, USA. Working as Tier 2 operational engineer supporting various property groups. Providing services to Enterprise service delivery team to improve the efficiency and automation of services.

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.
• Created SQL Server Analysis Project using MS SSAS 2008.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created complex SSAS cubes with multiple fact measures groups.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterizedand cascading reports using SSRS 2008.
• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Created Analytical reports by PROCLARITY tool.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle

Confidential,Charlotte, NC Nov 2009 – Sep 2010
SQL Server/SSRS/SSIS Developer

Wachovia Corporation is the fifth largest bank holding company in the United States. The project aimed at providing maintenance and support for the various operations of the bank after merging with the Wells Fargo. The project mainly dealt with migrating data and integrating data using SSIS. The project deals with mortgage where it aims at achieving financial goal with the usage of SQL Server Integration Services that provides for improved quality control and increased productivity.

Responsibilities:

• Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate thedatafrom various source systems feeds usingSSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Responsible for codingSSISprocesses to import data into the Data Warehouse fromExcelspreadsheets, Flat Filesand OLEDB Sources.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Worked on various tasks and transformations likeExecute Sql Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookupwhile loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2005 Reporting Services
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, Business Intelligence Studio, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential,Newport Beach, CA May 2009 - Oct 2009
SQL Server Developer/DBA

Pacific Life provides life insurance products, annuities, and mutual funds, and offers a variety of investment products and services to individuals, businesses, and pension plans. Pacific Life counts more than half of the 100 largest U.S. companies as clients and is a member of the Insurance Marketplace Standards Association (IMSA), whose membership promotes high ethical standards for the sale of individual life insurance and annuities.

Responsibilities:

• Involved in gathering the functional requirements from the client.
• Involved in Creating Complex Store Procedure using T-SQL to evaluate result for the repots to implement using Management studio.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Developed different Scripts for the Data analysts for Verification of reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Performed data conversions from flat files into a normalized database structure.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Creation and Maintenance of Indexes for various fast and efficient reporting processes.
• Perform T-SQL tuning and optimizing queries for Reports.

Environment: Microsoft SQL Server 2000, SQL Server Reporting Services (SSRS), Windows XP, MS Excel 2003, VBScripts.

Confidential, Irvine, California Oct 2008 – April 2009
SQL Server Developer

Ameriquestwas one of theUnited State’s leading wholesale lenders which are no longer into existence. It was among the first mortgage companies to usecomputersto search for prospective borrowers and to speed up the loan process.

Responsibilities:

• Designed a data share system using SQL Server Integration Services. Architected a database for a project that would host secure keys and assign keys to users based on business rules.
• Automated several legacy tasks using a combination of SQL Server and .NET (VB).
• Used tools such as Coefficient, SQL Server Profiler, Query Estimation Plan to obtain and analyze traces on worst performing stored procedures and queries.