SUMMARY

• Over 6+ years of progressive IT experience in database design and development using with Microsoft SQL Server 2008/2012, OLTP, OLAP, Data Warehouse implementation as a Database Developer.
• Experienced in Data Modeling - Relational and Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Microsoft Visio in the OLTP and OLAP.
• Proficient in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server and Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objectscreation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers, user profiles, data dictionaries, and data integrity, SQL joins and query writing.
• Experienced in designing relational database according Normalization Forms.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS 2012.
• Skilled in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Extensive experience in creating SQL Server analysis projects using MDX in MS SQL Server 2012.Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developing reports using MDX and T-SQL.
• Expert in developing SSIS packages that extract and transforming data, import and export data, bulk load and BCP.
• Hands on experience working with verity of data sources and destinations, all major Control tasks and Data transformations tasks. Experience in using event handler for SSIS packages, dynamically configuring SSIS packages etc.
• Experience in upgrade projects of SQL Server from version 2005/2008 to 2012.
• Extensive experience with performance point services 2012 to build Performance point Scorecards, KPIs and Dashboards.
• Experience in the Share point 2010( Sites, Templates and Business Intelligence), Excel: V-Look Up, power pivot for developing the dashboards in the share point server
• Expert in Microsoft .NET Framework Programming skills (C#) in ASP.NET, ADO.NET, Windows Application Development and Web Services.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation ofvarious phases in a project life cycleof Client/Server Applications.
• Extremely motivated, diligent, conceptually strong team player with ability to adapt new technology quickly.

TECHNICAL SKILLS

Operating Systems\Languages\: MS Windows 7/8/2008R2/2012, Linux\T-SQL, C++, C#, VB.Net\

SQL server tools\Development Tools\: MS SQL Server Management Studio 2012/\Visual Studio 2010/2008, MS Project, \ 2008R2/2005, Business Intelligence \MS Office, Advanced Excel: V-Look Up and \ Development Studio, Query Analyzer, SQL \Pivot Table, Dream Weaver\Profiler, SQL Server 2012/2008R2 Integration \Services (SSIS), SQL Server 2012/2008R2 \Analysis Services (SSAS), SQL Server 2012/\2008R2 Reporting Services (SSRS), SQL \Performance Monitor, Database Index \Tuning Wizard\

Databases\Web Servers\: SQL Server 2012/2008R2, MS Access\IIS (Internet Information Services) 7.0/8.0\

.Net Technologies\Web technologies\: ASP.NET, WCF, ADO.NET, .NET \HTML, XML, Java Script, CSS\Framework 4.5/4.0/3.5\

Data Modeling Tools\: MS Visio 2010/2007\

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh PA

Business Intelligence/SSRS Developer

Responsibilities:

• SQL Server 2008 RDBMS database development using T-SQL programming, queries, stored procedures, views.
• Developing reports on SSRS on SQL Server 2012
• Using SSRS creating well-formed reports and web-based reports for health related applications and transactions.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Worked extensively on migrating ad-hoc reports from SSRS2005 to SSRS 2008.
• Worked on RDL files and Stored Procedures to fix the errors and modifications of the reports.
• Migrating all reports into Production environment and testing.
• Developed and OptimizedStored Procedures, Views, and User-Defined Functionsfor the Application.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Applied conditional formatting inSSRSto highlight key areas in the report data.
• Performed Debugging on theStored proceduresfor the requirement to handle the errors
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server.

Environment: MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integrated Services, Windows 2012R2.

Confidential, Advisors, Virginia

SQL Developer

Responsibilities:

• Involved in the information gathering and developed the Data Flow model based on the existing OLTP System and the requirements using MS Visio.
• Used Microsoft Project to schedule the project process.
• Selected sample data and used V-Look Up and MS Access to analyze the sample data.
• Formed data reconciliation methodologies for each department and used SSIS data flow tasks to trim or convert data according to different methodologies.
• Traced missing transaction data for data integrity and generated solutions for data unmatched.
• Improved the Multi-Dimensional Model with various business requirements and created several databases in Development scenario for fact and dimension tables’ concepts.
• Involved in creating the new staging database prior to the final data warehouse.
• Extracted the data from the different sources (From the Aqua Data and MS SQL) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Developed the SSIS package for the data warehouse for ETL (Extract, Transformation and Load) operations. Created many SSIS Package for the Application to validate business requirements and data cleansing and Load the Fact and Dimension Table.
• Created cubes - using the UDM and the Cube Build Wizard.
• Developed and designed cubes with around 45 dimensions, about 25 Measures, and 20 calculated members; designed Dimensions and using the MDX expressions for the various Calculated Members, Actions and KPI.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developing reports using MDX and T-SQL.
• Design and Implement the different concept for the reporting services for Data Marts/ DW) including the Business Intelligence Reporting Services (Matrix report).
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Scheduled reports to run daily, weekly and monthly and also automatically emailed reports to department directors and analyst to review it.

Environment: MS SQL Server 2012, SQL Server Reporting Services, SQL Server Integrated Services, SQL Server Analysis Services, Windows 2012R2, Visio 2010Client: Confidential group, Fairfax, VA Apr 2014 to Oct 2014

Confidential

SQL Server Developer/ SSIS /SSAS Developer

Responsibilities:

• Gathered business requirements, definition and design of data sourcing and data flows.
• Implemented the Multi-Dimensional Model with various business requirement and created several databases in Development scenario for fact and dimension tables’ concept.
• Used various SSIS tasks and data flow transformations on data staging.
• Perform data validation checks and filtered bad data.
• Created complex SSAS cubes with multiple measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Made various cubes based on the reporting requirements.
• Responsible for the discussing various issue and layout with the higher authority to build the layout and then generate the report.
• Responsible for generating high level SSRS reporting from the OLTP and OLAP cubes.
• Responsible for designing Dashboards and reports using T-SQL and MDX.
• Provided reporting links using Microsoft SharePoint through development and production environment.
• Involved in generating high level reports for executives and clients, i.e. parameterized report, cross tab report using cubes.
• Responsible for the ad-hoc reporting, modification and regenerating on request.
• Provided the Business review for the mobile content performance using MS Excel and power pivot
• Building scorecards and dashboards using the Performance Point Services 2013 with BI application.
• Responsible to manage reporting services using SharePoint server 2013.

Environment: Microsoft SQL Server 2012, SSIS 2012, SSAS, SSRS, Windows Server 2008R2, Microsoft Visio 2010, Microsoft SharePoint 2013

Confidential, Hoboken, NJ

SQL Server Developer/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of data sourcing and data flows, design and created relational database and SSIS package architecture.
• Gathered data and documenting it for further reference and designed Database using MS Visio data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Used SSIS to create ETL packages (.dtsx files) 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 Configurations to change the package properties dynamically, and Loggings in a Package, Deploying packages to target server.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Created different reports (Tabular, chart, dashboard, etc) based on the requirements, and retrieve data using stored procedures that accept parameters using SSRS.

Environment: MS SQL Server 2012, MS SQL Server Integration Services 2012, MS SQL Server Reporting Services 2012, MS SQL Server Analysis Services 2012, Windows 7

Confidential

SQL Server Developer/SSRS Developer

Responsibilities:

• Gathered data and documented it for further reference and designed Database using MS Visio.
• Created SSIS package to load data from Flat files and Excel files to SQL Server 2008R2 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Created Configurations to change the package properties dynamically, and loggings in a package, deploying packages to target server.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created different reports (Tabular, chart, dashboard and etc.) based on the requirements and retrieved data using stored procedures that accept parameters using SSRS.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services 2008R2, MS SQL Server Reporting Services 2008R2, MS SQL Server Analysis Services 2008 and Windows 7, MS Visio 2007

Confidential

.Net Developer

Responsibilities:

• Simplified access to employee information and calculation of working hours, developing all functionality of Payroll module of Payroll System including UI and various tables.
• Contributed actively to development of additional Payroll Management System, designing database and UI, and developing all primary functionalities of system.
• Program web and ecommerce applications for website specializing in global holiday, travel, accommodation, and event management industries.
• Developed all functionality in payroll section. Design some tables in MSSQL. Developed all functionality in payroll section. Designed user interface in HTML.
• Involved in daily scrums and weekly meeting with the project sponsors to meet deadlines and expectations.
• AJAX Library, CSS and various other web controls were used.
• Created Indexes, Stored Procedures, Triggers and Views using SQL server 2008.

Environment: ASP.NET, C#, SQL Server 2008, ADO.NET, .NET Framework 3.0, XML, Visual Source Safe, Visual Studio 2008

Confidential

ASP.Net Developer

Responsibilities:

• Played active role in developing company’s revenue management system software using pie chart, bar chart.
• Using XML, TXT and PDF reports for showing company revenue.
• Designed and developed modules, user interfaces and implement revenue management industries.
• Gathered user requirements and converting them into the user Specifications and developed Web forms using C#.NET.
• Applications logic was developed using C# and used HTML helper in a view to render the HTML content.
• JQuery was used to validate user controls and web forms
• Developed stored procedures, views, triggers, indexes, constraints and foreign keys for SQL Server.

Environment: ADO.NET, ASP.NET Framework 3.5, Visual Studio 2010, AJAX, XML, HTML, CSS, MS-Excel, ASP.Net