SUMMARY

• 5+ years of experience in analysis, design and implementation using Microsoft SQL Server (SSRS, SSAS, SSIS) and other MS technologies like .NET, SharePoint, PowerPivot etc.
• Experience in BI suite - using integration services (SSIS), ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.
• Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema), Fact & Dimension and ODS(Operational Data Store)
• Hands on knowledge in basic database maintenance and SQL Server optimization using SQL Profiler, Index Tuning Wizard.
• Experienced in development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services (SSIS)
• Experienced in importing and exporting the data between homogenous and heterogeneous systems using various Extraction Transformation and Loading (ETL).
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement
• Expert in creating various types of reports like complex drill down, drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Extensive knowledge in designing reports using cascading parameters, Parameterized reports, Drill through reports and Adhoc reports using SQL server Reporting services (SSRS) based on Requirement
• Expert with T-SQL in writing Complex Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries to make sure that efficient data manipulation..
• 3 years ofexperience in Web/Client Server Application development and testing using ASP.Net, C#, ADO.Net, XML, and HTML
• Experience on working with Performance Point and SharePoint server 2010 to create KPIs, reports and Dashboards
• Highly motivated and possess ability to think critically as well as communicate with users and discuss their data, application and project requirement.

TECHNICAL SKILLS

SQL Server Tools\Operating Systems\: SQL Server 2005/2008/2012 Enterprise, \Windows Enterprise 2003 /Windows XP \ SQL Server Integration Service (SSIS), \Professional/NT 4.0 Server, \ SQL Server Analysis Service (SSAS), \ Windows Vista/Windows 7\ SQL Server Reporting Service (SSRS), \ SQL Profiler, Index Tuning Wizard, \ Performance Monitor, SQL Profiler\ SQL Server 2012 Upgrade Advisor\ Web Servers\ Best Practices Analyzer\ IIS 5.0/6.0\ System Configuration Checker\

Applications\Language\: Visual Studio 2010/2012, Report Builder 2.0/3.0\ T-SQL, MDX, C++, VB, .Net, C#, Java Script\ SharePoint 2010, Microsoft Office, SAS, \ MatLab, Excel Power Pivot\

Web Technologies\: HTML, CSS, XML\

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL BI Developer

Responsibilities:

• Upgraded databases from SQL Server 2005 to SQL Server 2012.
• Identified compatibility and new requirements for several business applications to work with SQL Server 2012.
• Responsible to upgrade SQL objects (queries, SPs, views, triggers).
• Created complex Stored Procedures, Triggers, Views, SQL joins, CTE’s and other T-SQL code to implement business rules.
• Responsible to upgrade and design SSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archive data files for different DBMS.
• Involved in transferring data from homogeneous and heterogeneous data sources such as MS Access, MS Excel, Flat files, and CSV files into SQL server
• Designed many SSIS for migrating data using various complex transformations such as derived column, lookup, Bulk insert, SCD and merge join
• In SSIS packages used various control flow tasks like for each loop, Sequential container and execute SQL tasks. Created packages to extract data from flat files with ragged right data mapping.
• Involved in creating user variables, Script tasks and involved in creating dynamic SSIS packages
• Maintained system monitoring jobs and providedhigh availability support.
• Designed and maintained various types of reports using SSRS, such as cascading (collapsed), printable, interactive reports (drill-down and drill through), parameterized and cascading parameterized reports.
• Designed, developed, reported all events and requirements inSSRS and deployed SSRS Reports in SharePoint for web based access for multiple end users

Environment: SQL Server 2005/2012, Windows 7, Microsoft office 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Visual Studio 2012, SharePoint 2010, SQL Server 2012 Upgrade Advisor, Best Practices Analyzer, Configuration Checker, Performance Monitor

Confidential, Hoboken, NJ

BI Developer

Responsibilities:

• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals ofdata warehouse.
• Extract Transform and Load (ETL)source data into respective target tables to build the required datamarts
• Responsible to create T-SQL Functions, Cursors,views, indexes,stored proceduresand triggers.
• Involved in management and optimization of database using SQL Profiler, Index Tuning Wizard.
• CreatedSSIS Reusable Packagesto extract data fromMulti formatted Flat files, Excel, XMLfiles into SQL Server and used Analysis Services processing task to update thecubewith current data.
• Identified thedimensions, fact tablesand designed thedata warehouseusingStar Schema.
• DevelopedMulti-dimensional Objects(Cubes, Dimensions) using Dimensional modeling with dimension Hierarchies for several client side BI requirements.
• Developed Aggregations, partitionsand calculated members forcubeas per business requirements.
• Defined appropriate measure groups andKPIs&deployed cubes.
• CreatedParameterized reports, Cross-Tab reports,Drill down reports& Summary reports fromOLAP, sub reports, bar charts and matrix reports by usingSSRS, and created report snapshots to improve the performance.
• Designed Dashboards, Scorecards and several KPIs in Performance Point Services and also in Excel Power Pivot.
• Deployed SSRS Reports in SharePoint for web based access for multiple end users
• Responsible for managing daily activities of department including compliance initiatives, and helping manage the daily operation of the company, holding employee meetings andresolving conflicts.

Environment: SQL Server 2008, Windows 7, Microsoft office 2010, XML, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Profiler, Visual Studio 2012, SharePoint 2010, SQL Profiler, Index Tuning Wizard

Confidential, Pennington, NJ

SQL Server Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in the performance of data consistency and tuning effectively with SQL Profiler, Index Tuning Wizard.
• Involved in creating and maintaining database objects, Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications.
• Involved in SQL Server Database Installation, Administration, Backup & Restore Procedures, and Database Security.
• Expertise in exporting and importing data using SSIS and using check points in SSIS packages.
• Involved in cube partitioning and developed various calculations using SSAS.
• Created many Complex Queries using MDX Expressions.
• Used SSRS for creating, editing and scheduling various complex reports and sub reports in various formats like MS Excel, PDF, HTML, and XML etc.
• Delivered reports for day-to-day as well as weekly/monthly purposes using Report Builder and Power Pivot.
• Designed and implemented the security of the Databases (Creating User Groups and Granting Permissions)
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Provided 24x7 on call support for various projects and ensure that all critical database problems are resolved in timely manner.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting

Environment: SQL Server 2008, Windows 7, Microsoft office 2010, XML, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Profiler, Visual Studio 2010, .Net Frame Work 4.0, Power Pivot, Index Tuning Wizard, Performance Monitor, SharePoint 2010

Confidential, Edison, NJ

MS SQL Server Developer

Responsibilities:

• Actively supported business users for change requests.
• Maintained data integrity by performing validation checks.
• Fine-tuned database objects& server, and optimized SQL queries for maximum efficiency.
• Developed complex Stored Procedures and other SQL joins, fixed bugs in them.
• Created views as per design needs.
• Responsible for sorting the detail data.
• Identified database tables for defining the queries for the reports.
• Designed and maintained cascading, printable, interactive reports (drill-down and drill through) using SSRS.
• CreatedParameterized reports, cascading parameterized reports, Cross-Tab reports,bar charts and matrix reports using SSRS.
• Used SSRS for creating, editing and scheduling various reports and sub reports in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: Windows XP, ASP.Net, Visual Studio 2010, MS SQL Server 2008, MS SQL Server Reporting Services 2008, Microsoft office 2010

Confidential

.Net Developer

Responsibilities:

• Working in an Agile Environment to deliver higher-quality software far more rapidly
• Wrote SQL Queries to create tables, stored procedures. Used SOAP to Implement Web Services.
• Involved in development of Web Forms, Classes using C#.NET that incorporates both N-tier architecture and database connectivity
• Developed ASP.Net pages using ASP.NET 3.5 web form controls, Custom user Controls, HTML server controls in C#.
• Used Visual Studio.NET 2008 IDE to design the forms, develop and debug the application.
• Used hibernate, WPF and WCF to communicate between DAL and other business components.
• Implemented version controlling using Visual Source Safe.
• Deployed web application on Internet Information Server for production.
• Created event driven Web Forms using ASP.NET and implemented form validation using Validation controls using both Custom validation and JavaScript was written for Client side validations and also used the new validation controls in VS 2008.
• Enhanced and developed UI functionality using ASP.NET, HTML, XML and XAML.
• OO development for web and business tier: MVC pattern implementation
• Created CSS files to be applied to various web forms on the web pages.
• Used Ajax tool kit, Multi views, regular expressions, regular expression validates, user search controls
• Leading role in Source Control management using VSS.

Environment: ASP.NET 3.5, C#.NET 3.5, ADO.NET, SQL Server 2008, Visual Studio 2008, IIS 7.0, VSS, WPF, WCF, Silverlight 3

Confidential

.Net Developer

Responsibilities:

• Designed and developed an n-tier architecture that included Presentation, Business and Data Access Layers.
• Implemented Presentation Layer using Web Forms, User Control, Web Controls, HTML, and Cascading Style Sheets.
• Used Ajax Control Tool kit to run client side script, enhance rich web UI, validation and showing div based Ajax extender.
• Designed, implemented and configured WCF service layer.
• Created custom controls, data binding and graphics.
• Managed to implement a layout system which adapt to changing window and display conditions by using WPF layout controls.
• Developed using C#.NET 3.5 to in corporate business logic and ASP.NET 3.5 for GUI and implemented WPF technology to provide Rich Interactive Application.
• Developed and consumed WCF Services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.
• Worked with WPF, Silverlight in creating custom controls, 3D graphics, data binding etc.
• Worked with SQL Server Database to access customer records.
• Performed unit testing and the complete system integration testing.

Environment: ASP.NET 3.5, C#.NET 3.5, ADO.NET, SQL Server 2008, Visual Studio 2008, IIS 7.0, VSS, WPF, WCF, Silverlight 3, SOA

Confidential

.Net Developer

Responsibilities:

• Involved in gathering the requirements from end-user.
• Involved in the analysis, design & development of the project.
• Designed and developed a web application using .net framework 3.5 and visual studio 2008.
• Involved in the design of security module that authenticates users based on the roles.
• Responsible for design and development of Web Forms using ASP.Net.
• Created user interface layers, web pages and integrated to maintain the performance of data flow and data integrity by using ASP.NET User Controls, Web Server Controls and ADO.NET.
• Implemented Server and Client side validations using ASP.NET validation controls and JavaScript.
• Provided session level security and password authentication using session objects and cookies.
• Used SMTP mail class of .NET for the users to send mail with suggestions, receive any alerts, receive confirmation notifications etc.
• Used service oriented architecture (SOA) for developing applications.
• Used MSMQ for implementing reliable, scalable, high performance distributed applications.
• Involved in System and Integration Testing as part of N-unit testing.

Environment: ASP.Net, C#, SQL-Server 2008,VSS, SOA, Visual Studio 2008, XML, Ajax, MS Project 2003