SUMMARY

• 5+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 in Development, Test and Production Environments with various business domains like Financial, pharmaceutical and manufacturing.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) and
• Developing reports on SSRS & SSAS on SQL Server ( 2014/2012/2008 ). Good Experience and understanding of SSAS, OLAP cube and Architecture.
• Worked Extensively on ETL process using SSIS package.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Used MDX to interact with the back end OLAP Services
• Migration experience with DTS to SSIS 2014/2012.
• Experience in creating reports through ProClarity. Used ProClarity for accessing and analyzing cubes and dimensions.
• Well aware of SDLC procedures, Change control rules, problem management and escalation procedures.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back - up/recovery, running Database Consistency Checks using DBCC.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart,Adhoc and Sub Reports.
• Having good knowledge in developing OLAP Cubes using SQL server Analysis services (SSAS) through MDX queries.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2014,2012 and 2008 platforms.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation.
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS

Languages: Transact SQL, C#.net, VB.Net, ASP.NET.

Databases: MS SQL SERVER /2008, MS Access 2003/2007/2010

ETL Tools: SQL Server Integration services (SSIS) 2013/2008/2005 , DTS

Reporting Tools: SQL Server Reporting services (SSRS) 2013/2008/2005

OLAP Tools: SQL Server Reporting services (SSAS)2008/2005

Operating Systems: Windows 9x/NT/2000/XP platforms, MS Dos and UNIX

Markup Languages: XML,HTML,DHTML

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSAS, SSIS,SSRS

Other Tools: Microsoft Visual Studio 2010, 2012 Crystal Reports, ProClarity ODBC, and MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SQL Server Developer / BI Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2014 and SQL Server 2012 SQL Server 2008 and with latest Service Packs.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Created the SSIS /DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Involved in developing logical and physical modeling of the database using Erwin.
• Actively participated in planning of clustering activities using an Active-Passive configuration to achieve high availability.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Created and managed the databases in development environment.

Environment: Windows 2008/2010 Advanced Server, Windows XP, MS SQL Server 2014/2012,2008 SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential, Denver, CO

MS SQL Server / BI Developer

Responsibilities:

• Developed flowcharts for complex stored procedures.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis
• Designed and implemented stored procedures and triggers for automating tasks.
• Involved in developing SSIS packages using BIDS/SSDT for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
• Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Created SSIS Packages to migrate slowly changing dimensions
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Deployed SSRS Reports inSharePoint for web based access for multiple end users
• Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
• Created reports usingstored procedure and also involved inscheduling, creating snapshotsand subscriptions for the reports SSRS.
• Involved in improving the performance of the system.
• Developed and executed several optimized queries in SQL.

Environment: MS SQL Server 2012, Windows 2008/NT/XP, SSIS, SSRS, SSAS, T-SQL, Query Analyzer, MS Office 2007, Oracle 9i/10g,Erwin 4.0

Confidential, PA

SQL SERVER DEVELOPER

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2012 Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in creating highly interactive score cards and Dashboards using Performance Point Server.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012 from different environments for the SSAS cubes.
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in designing, developing, debugging and testing of reports in SQL Server 2012Reporting Services (SSRS).
• Generated several drill down and drill through reports using SSRS.
• Expert in creating Star schema cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Setup replication within the sql databases.
• Provides technical documentation of the system
• Code reviews to move it to the production developed by developers.
• Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.

Environment: MS Visual Studio.NET# 2012, MS SQL Server 2008, SQL Server Integration Services (SSIS), Visual Basic/VB.net, VB Script, Visual Source Safe.

Confidential

SQL BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Designed and developed forms using Visual Basic with ODBC.
• Designed and developed reports using Crystal Reports.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance
• Designed and developed various complex reports.
• Generated reports that can handle dynamic grouping and dynamic sorting
• Involved in dimensional modeling to design data warehouse.
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
• Used the calculated members in the fact tables to improve efficiency.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Created roles, assigned permissions and users/groups to roles to limit the access for the users.

Environment: MS SQL Server 2008, Windows NT platform, Visual Basic, Crystal Reports 9.0, Oracle 9i/10g