SUMMARY:

• Around 6 years of IT work Experience in design, development, coding and testing of business applications including MS SQL Server 2008R2/2012, C#, ASP.NET, Web Services.
• Extensively used MS SQL Server services suite (SSAS, SSIS and SSRS) for various BI applications.
• Extensively worked in OLTP & OLAP environment that includes production support and application development in SQL Server and Data Warehousing database architecture.
• Experience in MS SQL Server Migration/upgrade from SQL Server 2008R2 to SQL Server 2012.
• Experience in creating database, tables, indexes, user - defined functions (UDFs), views, stored procedures and triggers using T-SQL.
• Experience with query optimization & performance tuning using tools such as SQL Profiler, Performance Monitor, and Database Console Command (DBCC) and trace flags to solve performance issues like dead locks and long running queries.
• Extensive knowledge of creating SSIS Packages for data extraction, transformation, and loading (ETL) solutions for data warehousing and upgrade packages from 2008R2 to 2012.
• Experience in creating alerts, jobs and scheduling SSIS packages using SQL Agent.
• Proficient 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, and Ad hoc reports using SSRS.
• Experience in creating SharePoint BI applications, PerformancePoint Services, Dashboards, Scorecards, Key Performance Indicators (KPIs) and reports using Microsoft SharePoint 2010 Server and Excel PowerPivot 2010.
• Proficient in defining measures, calculations & KPIs and writing Multi-Dimension Expressions (MDX) queries against the cube.
• Experience in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, Fact and Dimension tables, and Operational Data Store (ODS).
• Experience in SSAS including cube development/deployment and performance management.
• Hands on experience in creating data sources, data source views, dimensions, attributes, hierarchies, measures and cubes using SSAS.
• Experience in web/client server application development and testing using HTML, CSS, JavaScript, C#, ADO.NET and XML.
• Strong troubleshooting and organizational skills; independent, self-managing and team player.
• Excellent verbal and written communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: MS Windows 7/8, Windows 2008/2012\ T-SQL, C#, Java

SQL Server tools\ Databases: MS SQL Server Management Studio, MS SQL Server 2008/2008R2/2012Business Intelligence Development: Studio, MS Access 2007/2010 Query Analyzer, SQL Profiler, SQL Server, Integration Services (SSIS), SQL Server, Reporting Services (SSRS), SQL Server, Analysis Services (SSAS), Performance Monitor, Database Tuning Wizard

Web technologies: XML, HTML, ASP.NET, ADO.NET, \ SQL Server Reporting Services (SSRS)\JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

SQL BI Developer

Responsibilities:

• Actively planned, defined and designed database as per business requirements and provided documentation.
• Extensively designed the packages and data mapping using Control Flow task, Sequence Container task, Dataflow task, Execute SQL task, Data Conversion task, Derived Column task and Script Task in SSIS Designer.
• Created SSIS packages to automate the extract transform and load jobs.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Created error handling logic in all the SSIS packages to handle bad data and avoid package failures.
• Used the Script task, Look Up, Cached Look Up, Fuzzy Group Transformations and data flow tasks.
• Worked with packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/Snowflake schemas using Dimensional Modeling principles in SSAS.
• Developed and implemented partitioning and security in cubes based on user roles.
• Used the UDM Model to create Named Queries in the Data Source View.
• Designed relationships between the dimensions and measures. Resolved complex many to many relationships and referenced relationships between the dimensions and the measures.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Involved in unit testing, integrated testing and system testing.

Environment: Microsoft SQL Server 2008R2/2012, SSIS, SSRS, SSAS, Windows server 2012, .NET 4.0 Visual Source Safe, Visual Studio 2012

Confidential, New York City, NY

MS SQL Server Developer

Responsibilities:

• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex stored procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Managed index and optimized queries using execution plan.
• Created the SSIS packages for extracting data from OLTP to OLAP.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like .
• Developed Full Analysis Life Cycle Project.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Multi-Dimensional Expression (MDX) and OLAP cubes.
• Implemented data marts, facts, dimensions, star schema and OLAP cubes using SSAS.
• Created calculated measures and dimension members using MDX, mathematical formulas, and user-defined functions.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.

Environment: T-SQL, MS SQL Server 2012, MS SQL Server Analysis Services 2012, MS SQL Server Integration Services 2012

Confidential, New York City, NY

BI Developer

Responsibilities:

• Responsible for transferring the data using SSIS packages.
• Managed the reports and fixed bugs in stored procedures.
• Implemented different types of constraints on tables.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Monitored scheduled jobs and alerts.
• Involved in Creation Reports, Created ODBC Connections and database Connections.
• Experience in analyzing Business and Technical specifications, developing Use-Case diagrams, Data Modeling, Data Mapping
• Created SQL Server Reports using SSRS.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed queries for generating drill-down reports in SSRS.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Team Foundation Server (TFS) for central repository as a versioning control.

Environment: SQL Server 2012, SQL Server Reporting Service, SQL Server Integration Service, MS Visual Studio 2010

Confidential, Jacksonville, FL

MS SQL Server Developer

Responsibilities:

• Involved in writing scripts for the clients requirements for reporting purposes.
• Involved in the logical and physical database design and implementation using data warehouse or analytic tools for business purposes.
• Involved in writing SQL and understanding of ETL Development Tools.
• Extracted data using Flat files by creating appropriate files to load data into the BW data targets for both transaction and master data.
• Integrated SQL and SAP servers using SSIS 2008.
• Developed SSIS project for transferring the data.
• Created cubes and dimensions using SSAS 2008.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Automatic generation of grouping attribute members.
• Defined Granularity with in a measure group and drill through actions.
• Implemented calculations to aggregate physical measures.
• Defined the Browsing Prospective and Browsing Translations.
• Responsible for identifying KPIs in SSAS 2008.
• Responsible for Process Database Objects Security Role.
• Responsible for writing T-SQL code for creating cursors and handling the data validations.
• Developed complex T-SQL code for the application.
• Transformed the complex business logic and calculations into coding.
• Developed stored procedures, functions, tables, views and triggers.
• Created subscription and tabular reports using SSRS 2008

Environment: MS SQL Server 2008, MS Analysis Services 2008, MS Access, SAP, Windows 2008R2

Confidential, Cincinnati, OH

MS SQL Server Developer

Responsibilities:

• Involved in Logical & Physical design, development and testing of the system.
• Developed complex T-SQL code for the application.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Designed and implemented the stored procedures and triggers for automating tasks.
• Developed SQL Server Stored procedures and SSIS packages to extract data from database.
• Implemented constraints on tables.
• Generated reports using MS Reporting services.
• Worked on complex data loading (implemented the batch data cleansing and data loading).

Environment: SQL Server 2008, MS Access, SSIS, Query Analyzer, MS reporting Services, Windows 2008 Server

Confidential

.Net Developer

Responsibilities:

• Involved in the requirements gathering, analysis and database design.
• Designed the web pages and programmed the web enabled modules using HTML, CSS and used JavaScript for Client Side Validation.
• Used CSS (Cascading style sheets) used for look and feel and same font for the entire web site.
• Developed business logic using OOP features in C#.
• Used ADO.NET for data access logic from the SQL Server 2008 database and created tables, views using SQL Server 2008.
• Extensively used Dataset and Data Reader to transfer Data between the Client and Server.
• Written Stored Procedures and functions using SQL Server 2008.
• Developed Custom User Controls To reduce the Complexity in User Interface Coding and provide better look and feel.
• Designed the Reports using SSRS and Integrated in ASP.NET.
• Involved in Debugging of the Application.

Environment: .NET 3.5, Microsoft Visual Studio 2008, ASP.NET, C#.Net, ADO.Net, SQL Server 2008, HTML, CSS, Java Script, XML, IIS, Web Services, TFS

Confidential

Associate Software Engineer

Responsibilities:

• Engaged in project across the full life cycle development. Designed, developed and Unit tested application using .NET framework
• Designed web based user interface with Web Forms, HTML Controls and Web Controls
• Created Cascading Style Sheet (CSS) and integrated styles in user interface
• Coded SQL queries, stored procedures and implemented SQL queries in the C# code in middle tier components
• Coded program logic to execute SQL queries and stored procedures using ADO.NET to access and update data on SQL databases
• Prepared and executed test cases according to specifications

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