PROFESSIONAL SUMMARY:

• Over 7 years of experience using Microsoft Business Intelligence (MSBI), SSIS, SSRS, SSAS/OLAP and Microsoft SQL Server 2005/2008/2008 r2/2012 stack. Knowledge of Data Warehousing (DW) concepts and Data warehouse applications.
• Experience in database programming skills with SQL Server 2012/2008 R2 /2005, and T - SQL, Advanced SQL and SQL Functions.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008/2012.
• Expert in SSIS package Optimization for log running process.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experienced in migration from SQL Server 2008 to SQL Server 2012.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill-through, Top N, Summary, Form, Lists, Sub reports, Matrix Reports and formatting them.
• Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Experience in building Star schema and Snow Flake schema depending on business requirements.
• Experience in creating Perspectives, Partitions, KPI’s and Design Aggregations in cubes using SSAS.
• Experience in Providing the cube level security(Data level, Column level)
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance. Expert in database creation maintenance, monitoring, backups and recoveries using SQL Server Agent (Scheduling Jobs), Import/Export Wizard and Maintenance Plans.
• Able to work with minimal supervision in any collaborative environment.
• Highly motivated with an ability to learn new systems and business processes.
• Knowledge on Tableau Reporting tool and SharePoint
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS:

SDLC Methodologies: Agile Scrum, Waterfall

Modeling Techniques/Tools: Flow Charts, Use case diagrams, Data Modeling, ER Diagrams; MS Visio, TFS,SVN

Languages: TSQL,UML, C#, .NET

MS Office Suite: Word, Excel, PowerPoint, Access, Outlook, Project

Reporting Tools: SQL Server Reporting Services (SSRS), MS Excel, MS Access, Power pivots, Power View, Tableau, Share Point

ETL and Analysis Tools: SQL Server Integration Services (SSIS), DTS 2000, SQL Server Analysis Services (SSAS) Multidimensional Cube, Tabular Cube

Project Management/Others: MS Visual Studio, MS Project, MS SharePoint, Snipping Tool, WebXtender DMS, Igrafx

RDBMS: MS Access, SQL server 2000/2005/2008/2012 , Oracle,MS Visual Studio 2008/2010, SQL Server Profiler.

PROFESSIONAL EXPERIENCE:

Confidential, Farmington, CT

MSBI Developer

Responsibilities:

• Responsible for getting, understanding the business specs, preparing technical Specifications, SSIS Packages, Cubes and Reporting.
• Involved in Database Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, Database Objects authorization, DTS, ETL using DTS (SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures.
• Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Involved in troubleshooting of existing SSIS Packages by reviewing Data Source/Destination Configurations, transformations and data type conversions.
• Worked on designing and building data load procedures, using MS SQL Server SSIS.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Extensive Experience in Cube development, Performance point implements the Partitions, Aggregation, Perspectives, Actions, KPI, Calculations and Translations.
• Experience in SQL Server Reporting Services (SSRS).
• Developed various kinds of interactive reports like Drill Down reports, Aggregate reports, reports containing parameters and groups. Also, developed Matrix, Chart and Graph reports.
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Developed ad-hoc reports using Report Builder.
• Developed Report Model so that the end users can create their own reports using Report Builder.
• Published reports in PDF, Excel, CSV formats.
• Deployed SSRS reports into SharePoint Server.
• Scheduled reports to be generated on predetermined time.
• Experience on DBA Activities: Creating Databases, Back & Restore, Attach, Detach, Security, Scheduling jobs.
• Involved in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Created and monitored the jobs to perform tasks such as Database cleansing, backups, data loading.
• Played the vital role in the team.

Environment: SQL Server 2012,SSIS,SSAS,MDX, Power Pivots, SSRS, Windows Server 2012, IIS, .NET, Enterprise Manager, SQL Query Analyzer, ASP.NET,TFS.

Confidential, Glen Allen, VA

SSIS Developer

Responsibilities:

• Involved in Data Source layer, data transformation layer, data storage and retrieval layer, analytical layer and presentation layer of business intelligence solution.
• Worked on Data cleansing Techniques, Excel Pivot tables, Formulas and Charts.
• Proven background translating cell formulas in Excel into VBA code using Excel code and also design, analyze and deploy a program.
• Used Linked servers to connect to remote OLEDB source and joined the data present in OLEDB source with local data (referred the OLEDB source more than once)
• Used Open Row Set function for one time access of the other OLEDB source data.
• Used data from sources like MS SQL Server, Oracle, Text files and MS Access to extract, transform and load into a Data Warehouse.
• Involved in the design of Star and Snow flake schemas for the DW.
• Handled Inferred and Slowly Changing Dimensions (SDC) while loading Fact and Dimension tables respectively.
• Identified and defined fact and dimension relationships.
• Used SSIS tasks and transformations to accomplish the ETL process.
• Deployed reports on to the Report manager and presented them to the users creating custom VB.Net applications and ASP.Net pages.

Environment: SQL 2008/2012, T-SQL, Query Analyzer, Visual Studio 2010, VB.NET, ASP.NET, SQL Server Profiler, SSMS, SSIS,SSRS

Confidential, Chantilly,VA

SQL ETL Developer

Responsibilities:

• Interacted with the client as part of the Requirements engineering team to understand the reporting requirements and finalize the project scope.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS by running upgrade advisor tool against DTS packages, troubleshooting issues and converting into SSIS through DTS migration wizard.
• Designing and building data load procedures, using MS SQL Server SSIS
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and loaded them into Fact and Dimension tables of data warehouse
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Developed Stored Procedures, Functions and Database Triggers.
• Developed various reports using SQL Server Reporting Services (SSRS) and Landscape reports.
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Developing a Report as per user requirement using MS Reporting Services
• Published reports in PDF, Word and Excel formats.

Environment: SQL Server 2008 R2, Windows 2008, C# 3.0, .NET 3.5, Excel, TSQL, MS Visual Studio 2005/2008, SSIS, SSRS.

Confidential, San Diego, CA

SQL Developer

Responsibilities:

• Involvement in Development, design and implementation of Intranet based web portal system for handling all the necessary database requirements.
• Creating Stored Procedures that helped speed up the application, as front-end programming was eliminated.
• Used XML extensively in the Stored Procedures.
• Involved in writing Stored Procedures, Functions, Triggers, Views and Indexes in SQL Server 2000.
• Extensively used SQL Server Reporting Services to generate the reports.
• DTS was used to bring information from other data sources into their database on a nightly basis. The other sources consisted of Excel spreadsheets and text files.

Environment: MS SQL Server 2005, TSQL, IIS 5.0/4.0, VB.NET, XML, DTS, SSRS

Confidential

SQL Server Developer

Responsibilities:

• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Created and enhanced streamline data models and data integration strategies.
• Predictive modeling/scoring system development to calculate the risk of improper payments.
• Performance optimization for maximum efficiency, Query tuning using SSMS and troubleshoot slow running queries and stored procedures..
• Using DMV and DBCC commands for identifying missing indexes, index stats and fragmentation levels of indexes for query/stored procedure tuning.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
• Highly used T-SQL for developing complex Stored Procedures using CTE.
• Responsible for rebuilding the indexes and tables as a part of performance tuning
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Troubleshooting various issues encountered while converting existing DTS Packages to SSIS Packages.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Interacted with concerned application team in fixing the problems when ever needed.
• Modified Job scheduling, alert and notification Email settings.

Environment: SQL Server 2008/2005, C#., VB, VBA, ASP, .NET,SSIS

Jr. SQL Server Developer

Responsibilities:

• Involved in Web Interface Development using HTML, DHTML and ASP.NET.
• Designed DDL and DML for MS SQL Server 7.0.
• Created and managed schema objects such as Tables, Views, and Indexes.
• Involved in writing SQL batch scripts.
• Created Stored Procedures and functions.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created Triggers to enforce data and referential integrity.
• Created various stored procedures for data manipulation and database triggers.
• Scheduled and maintained routine jobs, tasks and alerts.
• Worked on Application documentation and ER Diagrams.
• Involved in building and deploying applications.
• Involved in Unit testing of the database objects created.

Environment: Windows NT server/2003/2003R2, C# 2.0, .NET 2.0, ASP.NET, SQL Server 2000, Enterprise Manager.