SUMMARY:

• 6+ years of IT working experience in MS SQL Server 2008/2012 as ETL/Business Intelligence Developer.
• Expert in building various SSIS packages to complete different Extraction, Transformation, and Loading (ETL) tasks
• Expert in deployment of SSIS packages using different mechanisms.
• Highly proficient in complete ETL cycle including data analysis, database design, data mapping, data conversion and data load.
• Worked with SSIS packages to see incremental changes in Data Warehouse done through any update or deletion of data.
• Experience in performance tuning and debugging of SSIS packages also schedule jobs for SSIS packages to run on specific routine.
• Experience in working with business analysts, data architects and application developers.
• Experience in Data Modeling using Star and Snowflake Schemas along with developing OLAP Cubes, and Data Mining applications using SSAS.
• Expert in designing reports using SSRS and PowerPivot based on OLAP Cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.
• Hands on experience in BI integration of MS SharePoint.
• Good experience in calculating measures and dimension members using Multi - Dimensional Expression (MDX), mathematical formulas, and user-defined functions.
• Highly proficient in the writing T-SQL queries for developing complex Stored Procedures, Triggers, and Functions.
• Proficient in creating Tables, Views, Indexes and other DDL/DML statement writings using T-SQL.
• Proficient in database performance tuning and query optimization.
• Good experience with checking the physical and logical consistency of a database using DBCC Utilities.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS:

Databases Technologies/Tools \Utilities/Applications \: MS SQL Server 2008/2012, MS Access, \MS Visual Studio 2008/2010, Report \SQL Server Integration Services (SSIS), \Builder 2.0/3.0, MS PowerPivot, MS \SQL Server Analysis Services (SSAS), \SharePoint, MS Office Suite, MS Visio\SQL Server Reporting Services (SSRS), \

Programming Languages \Operating Systems: T-SQL, MDX, C#.NET, HTML, Java Script, \Windows XP/7/8/2008R2/2012\CSS\

PROFESSIONAL EXPERIENCE:

Confidential, Bethlehem, PA

MS SQL Server Developer/ SSAS /SSIS Developer

Responsibilities:

• Interacted with users to gather business requirements.
• Involved in creation of database objects like schemas, logins, tables, clustered and non-clustered indexes, views, functions and stored procedures.
• Created SQL scripts for tuning and scheduling.
• Implemented the automated processes for the activities such as database backup processes.
• Designed SSIS packages for extracting the data and load into the appropriate tables in the database to complete various ETL tasks.
• Worked on SSAS and participated in creation of Dimensions, Measures and Partitions on Cubes, Develop KPIs and Calculations for various Measures Groups.
• Implemented partition tasks that create or drop partitions for the Cube.
• Involved in taking backups of SSAS database and restoring them when needed.
• Worked with development team to optimize application specific database operations and implement security restrictions.
• Designed, Developed and Deployed reports using SSRS.
• Developed single value and multi valued parameterized reports for business users using SSRS.
• Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using SSRS.
• Used Report Builder to doAd-hoc Reporting.
• Responded to and resolve database access and performance issues.

Environment: SQL Server 2008R2, T-SQL, Windows 2008R2, Visual Studio 2008, Oracle, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Integration services, SQL Server Reporting services, SQL Server Analysis Services, Team Foundation Server, Visio, Share-Point

Confidential, Reading, PA

MS SQL BI Developer

Responsibilities:

• Implemented ETL using Bulk Insert, createdSSIS packagesto extract data from OLTP to OLAP systems and Scheduled Jobs to run packages and stored procedures.
• Transferred data from variousOLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012.
• ImplementedEventHandlersand Error Handling inSSISpackages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using various transformations in dataflow such as Fuzzy /Exact Lookups, Data Conversion, Conditional Split and Slowly Changing Dimension etc.in SSIS.
• Built the OLAP Cubes using Star Schema and Snow Flake Schema.
• Designeduser defined hierarchies in SSAS including parent-child hierarchy.
• Involved in implementing partitions, aggregations and calculation, KPIs, Actions, and Perspective in SSAS.
• Developed and defined relationships between attributes in Dimension structure.
• Designed and developedmatrix, chart and tabular reportswithdrill down,drill throughand drop downmenu inSSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SSRS and PowerPivot.
• Performed maintenance duties likeperformance tuningand optimization of queries, functions and stored procedures.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Environment: SQL Server 2008/2012, T-SQL, SQL Profiler,SSIS, SSRS, SSAS, MDX, XML, Visual Studio 2008/2010,PowerPivot 2010, MS SharePoint 2010

Confidential, Division Wayne, NJ

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• .
• Created parameterized reports for the channel partners and clients, formatted the report layout for the requirement of the end users in SSRS.
• Createdreports, Cross-Tab reports,Drill Down/ Drill Through reports& Summary reports by UsingSSRS.
• Deployment of the developed reports on to the server for the end users.
• Implemented Ad-hoc Reporting using Report Builder
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.

Environment: Windows Server 2008, MS SQL Profiler, MS SQL Server 2008R2, MS Visual Studio 2010, T-SQL, SSIS, SSRS, Report Builder 3.0

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in logical and physical development of the database using Erwin data modeling tool and MS Visio.
• Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL queries for applications.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Created multiple SSIS packages for transferring the data from different formatted source files loading into SQL Server database.
• Implemented data transformation and standardized tasks in BIDS to meet the data processing requirements.
• Designed and implemented stylish report layouts.
• Generated multiple reports using SSRS.
• Developed multiple Drill-down and Drill-through reports in SSRS.
• 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.
• Looked at the reports and fixed bugs in stored procedures.
• Monitored Scheduled jobs and alerts.

Environment: MSSQLServer 2008, T-SQL, BIDS, SSIS, SSRS, Visual Studio 2008, ERwin, MS Visio

Confidential

.Net Developer

Responsibilities:

• Involved in the project initiation and requirements gathering phase during the meetings with client.
• Designed and Developed Database for the new Web application in SQL Server 2008.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL SERVER data sources.
• Extensively worked with designing and developing reports using SQL Server Reporting Services (SSRS)
• Stored Procedures were extensively used for database operations like Select, Insert, Update and delete.
• Master pages were used to provide consistent design all over the application.
• Cascading Style Sheets (CSS) were extensively used all over the application to provide rich user interface.
• Extensively used Dataset, Grid View controls to display and manipulate data
• Customized the sites by using AJAX and CSS
• Writing effective queries, stored procedures and views.
• Created classes, interfaces, properties, methods, user controls in C# using ASP.NET.
• Implemented user authentication by forms based.

Environment: MS Visual Studio 2008, C#, ASP.NET, ADO.Net, HTML, CSS, MS SQL Server 2005