SUMMARY

• Over 7 years of IT experience as an ETL developer using MS SQL server R / 2000 in OLAP\OLTP environments.
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft business intelligence development studio (MSBI) using visual studio 2012/ 2010/2008/2005 .
• Expertise in writing T - SQL queries using joins, sub queries, stored procedures, triggers etc in MS SQL server 2012/2008R 2/2008/2005.
• Expertise in T-SQL DML and DDL queries for MSSQL server database.
• Experience in designing, creating, testing and modifying complex user-defined functions and stored procedures.
• Expert in writing complex SQL queries involving multiple tables inner and outer joins
• Expertise in optimizing the queries by creating various clustered, non- clustered indexes and indexed views.
• Developed applications using HANA(web server and version control repository )
• Expert in creating tables, views, triggers and other T-SQL statements for various applications.
• Expertise in creating and designing SSIS packages for integration and migration of data from XML, Excel, Db2, Sybase, Flat file, Oracle to MSSQL server using BCP and DTS utility and extracting, transforming and loading of data using SSIS.
• Implemented various control flow and dataflow elements of the SSIS package.
• Experience in creating XML data files using SSIS script task (Vb.net, C#.net).
• Expertise in error and event handling, precedence constraints, breakpoints, check points and logging.
• Experience in developing, deploying and managing various reports like ad-hoc reports, simple and parameterized reports using SQL Server Reporting Services (SSRS).
• Experience in building Web Services using WSDL and SOAP Protocol.
• Excellent working knowledge in Developing Windows Services, Web Services, SOAP, XML, XSD, XPATH, IIS and JavaScript.
• Good Hands on experience using WCF services.
• Have experience in developing applications using MVC.
• Experience in developing User Interfaces using ASP.NET, AJAX, XML, HTML/DHTML, CSS, Master Pages, J query, Themes, and Java Script.
• Experience with Data Accessing using Data Adapter, Data Reader and Data Set in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation Experienced in implementing applications using SOA, LINQ, and MVC.
• Experience in utilizing ASP.NET Server Controls, User Controls, Data Grid control, Form Validation controls, Custom controls.
• Expertise in creating parameterized reports and linked reports with thorough knowledge of report service architecture (Table, chart and matrix report).
• Experienced in power pivot data analysis expressions to troubleshoot data issues.
• Knowledge in SSAS and different schemas like star schema and snow flake schema.
• Involved in cube development and deployment in SSAS (SQL server analysis services).
• Extensive experience with database backups, recovery procedures, backup strategies and scheduling.
• Worked on performance tuning, query optimization, client/server connectivity, and running database consistency checks using DBCC utilities.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILL

Databases: MS-SQL server 2012/2008r 2/2008/2005/2000 , oracle 11g/10g/9i, Microsoft access, Share Point 2010/2007, oracle SQL server 9i/10g/11g.

Programming languages: T-SQL, PL/SQL, HTML, DHTML, XML, vb.net, c#.net

Scripting Languages: Java script, J Query, Html, XML, Angular Js

Ideal tools: Visual studio .net 2010/2008/2005

Framework: Microsoft .net framework 4.0/3.5/3.0

Data modeling: MS visio 2010.2007/2005.

ETL tools: SQL server integration services (SSIS); data transformation services (DTS).

Reporting tools: SQL server reporting services (SSRS) 2012\2008r2\2008\2005, power pivot and business objects

SQL server tools: SQL server management studio, SQL server business intelligence development studio, enterprise manager, SQL profiler, query analyzer, import & export (DTS), performance point server 2007.

Configuration management Tools: JIRA, team foundation server (TFS) 2010/2008/2005 .

Operating system: Windows server 2003, Windows 2000 advanced server/professional, Windows NT, Windows XP professional /standard

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

SQL/MSBI Developer

Responsibilities:

• Involved in requirement gathering and providing solutions to generate state files.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Tweaked SQL Queries to meet client requirement
• Experience in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
• Experience in creating and managing stored procedures, indexed views, Database Constraints to meet business requirements.
• Experience in working with SSIS Packages for applying various business rules, using various control flow tasks, dataflow components and event handling techniques.
• Experience in deployment and configuring the packages into different environments.
• Developed complex Stored Procedures and Views to generate various reports using Excel Macro’s and SSRS.
• Responsible for creating and maintaining the documentation for implementation and for future changes.

Environment: MS-SQL Server 2008R2 Enterprise Manager, MS-SQL Server 2008, Oracle SQL Developer, TOAD, MS Business intelligence (BIDS) SSIS, SSRS,SSAS, XML, MS Excel, Visual Studio 2010, Visual Studio 2008, Windows Server 2008

Confidential, Philadelphia, PA

MSBI -SSRS developer

Responsibilities:

• Scheduled and conducted meetings with business users work group members to identify requirements, documentation and identified priorities.
• Responsible for training business users about the functionality of SSRS reports.
• Excellent report creation skills using Microsoft SQL Server Reporting Services 2012.
• Responsible for creating of Metadata tables and replicating databases for reporting.
• Created drill down reports, drill through reports, linked reports and complex dashboards as required for Top management.
• Created different types of complex interactive pie charts, bar charts, line charts.
• Responsible for pushing canned reports into SQL server and then generating reports using SSRS.
• Developed tabular, parameterized, cascaded and sub-reports using SSRS.
• Wrote complex stored procedures and functions for generating desired results in reports.
• Responsible for creating cubes to generate extract reports.
• Responsible for leveraging power pivot tool.
• Developed reports and deployed them into SharePoint.
• Responsible for scheduling reports to run on daily and monthly basis.
• Responsible for creating user roles and granting permissions for users to access the reports.
• Validated the Production support documentation and also altered the reports for ease access for business users.
• Creating applications using VB.NET and enhancing projects for .NET applications
• Responsible for developing Application using ASP.NET MVC 3.0 and C#.
• Created web applications using Angular JS.
• Wrote a comprehensive Data Access Layer (DAL) using ADO.NET.

Environment: MS SQL Server Management Studio 2012, SQL Profiler, MS SQL Server Reporting Services (SSRS), Share Point, Windows 2010TFS, MS Excel Power Pivot.

Confidential, Springfield, IL

SSRS, SSIS Developer

Responsibilities:

• Involved in analysis of report design requirements and actively participated and interacted with team lead, technical manager and lead business analyst to understand the business requirements.
• Migrated reports to SSRS.
• Excellent report creation skills using Microsoft SQL server 2008R2 reporting services (SSRS) with proficiency in using report designer as well as report builder.
• Created SQL server reports based on the requirements using SSRS 2008.
• Worked on OLAP data warehouse, model, design, and implementation.
• Worked closely with the data modeler.
• Developed complex stored procedures, views and temporary tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Giving inputs to the team.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, build the dimensions, cubes with star schema using SQL server analysis services (SSAS).
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them onto Share Point using SQL server reporting services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly statements.
• Querying and manipulating multidimensional cube data through MDX scripting in SSAS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Worked very closely with business owners, end users and resolved any business process related issues.
• Used ASP.NET Master Pages, jQuery, utilizing Server Controls, User Controls, and Data Grid Controls, Form Validation controls, Custom controls and CSS.
• Used ADO.NET for data retrieving, querying, storage and manipulation interface screens developed using MVC and implemented MVC architecture.
• Developed middle layer using C#.Net and ASP.NET.
• Applied lot of basic validations in MVC using Data Annotations.
• Prepared a lot of Partial Views in MVC.

Environment: Windows Server 2003, IIS 6.0, MS SQL server-2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL profiler, OLAP, OLTP, office-2007, MS Excel, C#.net, Pro-Clarity analysis, j-query, MVC

Confidential

SSRS, SSIS Developer

Responsibilities:

• Involved in analysis of report design requirements and actively participated and interacted with team lead, technical manager and lead business analyst to understand the business requirements.
• Migrated reports from Cognos to SSRS.
• Excellent report creation skills using Microsoft SQL server 2008R2 reporting services (SSRS) with proficiency in using report designer as well as report builder.
• Created SQL server reports based on the requirements using SSRS 2008.
• Worked on OLAP data warehouse, model, design, and implementation.
• Worked closely with the data modeler.
• Developed complex stored procedures, views and temporary tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Giving inputs to the team.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, build the dimensions, cubes with star schema using SQL server analysis services (SSAS).
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them onto Share Point using SQL server reporting services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly statements.
• Querying and manipulating multidimensional cube data through MDX scripting in SSAS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Worked very closely with business owners, end users and resolved any business process related issues.
• Implemented the project according to the Software Development Life Cycle (SDLC).
• Designed and developed dynamic ASPX web pages using C#, ASP.Net, HTML, Java Script and JQUERY.
• Extensively used Master Pages, Web User and Custom Controls in developing the front end application.
• Used LINQ as middleware component for access to the database.

Environment: Windows Server 2003, IIS 6.0, MSSQL server-2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL profiler, OLAP, OLTP, ERWIN, office-2007, MS Excel, C#.net, ASP .net, J-query, Java script

Confidential

SSRS, SSIS Developer

Responsibilities:

• Involved in designing of conceptual logical model and physical model.
• Created new database objects like procedures, functions, packages, triggers, indexes and views using t-SQL in development and production environment for SQL server.
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for databases and transaction log. Performed restoration operations. Suggested backup strategies.
• Developed database triggers to enforce data integrity and additional referential integrity.
• Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
• Involved in performance tuning and monitoring of both t-SQL and pl/SQL blocks.
• Used SQL profiler and query analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (cluster index, non cluster index) tables.
• Responsible for cleansing up database for maintenance of the database.

Environment: SQL Server 2000, T-SQL, MS .net framework, MS Visio, Html, XML, Vb.net, SQL Profiler, Windows 2003 Server.