SUMMARY:

• Over 4+ years of MS SQL Server Development experience in Telecommunications , Asset Management , Media and pharmaceutical domains with expertise in MS SQL Server 2005/2008/2008 R2 and Microsoft’s suite of products like SSIS, SSAS and SSRS.
• Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2005/2008/2008 R2 respectively.
• Implemented complicated transformations to be used in SSIS packages.
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005/2008.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Deploying and Processing SSAS objects.
• Adept in defining referenced relationships and calculated members in SSAS and used MDX queries.
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Developed a thorough knowledge and maturity in all the phases understanding business processes, gather requirements, and coordinate ongoing iterative development of Software Development Life Cycle (SDLC).
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.

EDUCATION:
Master of Science in Software Engineering.

TECHNICAL SKILLS

Windows NT/2000/XP/Vista/7, MS SQL Server 2008 R2/2008/2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), MS SQL Server Integration Services (SSIS), SQL Query Analyzer, Bulk Copy Program (BCP), ERWIN, C,C++,MS Office suite (Word, Excel, Access, Power Point, Outlook Project), SQL Server Profiler.

EXPERIENCE:

Confidential,Virginia Beach, VA Dec 2011– Current
MS SQL Server Developer/SSAS/SSRS
Amerigroup is honored to be a Fortune 500 company serving approximately 2million members in12 states. Nationwide, It serve one out of every 35 Medicaid recipients and one out of every 25 kids covered by CHIP. Its improve access to quality health care for our members while lowering costs for taxpayers.Wecoordinate services for individuals in publicly funded health care programs.
Tools & Technologies:

MS SQL Server 2008 , SSIS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor and MS excel 2003, BIDS,SVN.

Responsibilities:

• 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.
• Created reports that can be browsed at Summary level and can be drilled down to the detail level.
• Created cubes for determining quarterly sales for real estate using SSAS by determining dimensions and measures for star schema.
• Designed, developed and created Pivot table/Pivot chart reports based on OLAP cubes.
• Designing Data Warehouse for error logging system.

Confidential,San Diego, CA Jul 2011 – Dec 2011
MS SQL Server Developer/SSIS/SSRS

Qualcomm CDMATechnologies (QCT) is the world\\\'s largest fabless semiconductor producer and the largest provider of wireless chipset and software technology, which powers the majority of all 3Gdevices commercially available today. The main aim of project was to develop the in-bound feed and reporting development for Database -supply/demand forecasting solution for the Corporation.

Tools & Technologies:

MS SQL Server 2008 R2, SSIS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor and MS excel 2003, BIDS,SVN.

Responsibilities:

• Created SSIS package to extract, transform and load data into the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension. Extensively worked on SCD transformation in SSIS package.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Maps, Functions and Maps using SSRS.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Defined the report layout and identified Datasets for the report generation.
• Generated reports on wealth information, asset information, account information, research reports using adhoc reporting to be used by the clients and advisors.
• Created numbers of complex formula in sub report.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• 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.
• Created reports that can be browsed at Summary level and can be drilled down to the detail level.
• Created cubes for determining quarterly sales for real estate using SSAS by determining dimensions and measures for star schema.
• Designed, developed and created Pivot table/Pivot chart reports based on OLAP cubes.

Confidential, Feb 2011 – Jun 2011
SQL SERVER DEVELOPER/ SSRS

Peracon is the leading Risk and Transaction Management platform for commercial real estate investors and lenders. Since inception, over 10,000 properties valued at more than $400 billion have been hosted by Peracon. Peracon’s Investor Risk Management solution provides clients with a secure, centralized location for the aggregation, normalization and analysis/reporting of all investment real estate data. The main aim of project was to develop a site and reports for history, current and forecasting solution for the LAMCO Corporation.

Tools & Technologies:
SQL Server 2008/2005, MS Office 2007/2003, SQL Server Profiler ,Database Tuning Advisor , SSRS and SSAS,XML,Microsoft Dynamic CRM, Windows XP/Vista/7

Responsibilities:

• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Generated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.

Confidential,NY May 2009 – Jan 2011
MS SQL Server Developer/BI Developer/SSIS/SSRS

Omnicom Group Inc. (NYSE: OMC) is a leading global advertising and marketing communications services company. My primary scope of this project was to design and develop an enterprise data warehouse, and to develop a daily basis feed for Renault-Nissan System using SSIS and Harvester [Omnicom’s SSIS tool] and generate reports using store procedures and SSRS 2008.

Tools & Technologies:

Microsoft SQL Server 2005/2008R2 Enterprise Edition, Microsoft SQL Server Management Studio, SSIS, SSRS, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor, MS excel 2003, Harvester.
Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to RNS (Renault-Nissan System).
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS, also perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• 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.
• Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Create Store Procedure using T-SQL to evaluate result for the reports to implement using Management studio