SUMMARY

• Over 7+ years of MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management, domains with expertise in MS SQL Server 2000/2005/2008 R2/2012 and over 5 years of experience in Microsoft’s Business intelligence stack products like SSIS and SSRS.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Expert in TSQL-DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS.
• Expert in creating the MDX cubes and dimensions.(SSAS)
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Excellent skills in implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Developing reports on SSAS & SSRS on SQL Server (2005/2008 R2/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Proactively resolved open defects against MDM and other subject areas
• Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/20 ) generate drill down reports, drill through reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2012 .
• Good understanding of Normalization /De-normalization and database design methodology.
• Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors on Microsoft SQL Server.
• Excellent skills in Database backup, Replication, recovery, restoration, DTS and Linked servers.
• Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Proficient in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

TECHNICAL SKILLS

Databases: SQL server 2000/2005/2008 R2/2012, MS Access

Languages: Transact- SQL, SQL, HTML, C.

Operating Systems: Windows NT/98/ 2000/XP/Vista/2003, MS-DOS

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio, Erwin.

Data Modeling Tools: Microsoft Visio 2000/2003,Altova tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server2008/2012 Analysis Services and SQL Reporting services, DTS, ProClarity, PPS-2007, MOSS

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, VA

SQL/BI (SSIS, SSRS) Developer

Responsibilities:

• Involved in planning, defining and designing database as per Business requirements.
• Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012, Text Files, Excel and Access to OLAP systems (SQL Server 2012).
• Have experience in data modeling in Erwin, Star Schema Modeling and Snow Flake Modeling, Fact& Dimension tables.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats usingSQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS) . Also done reporting using Excel with Power pivot.
• Define and design the Data Acquisition, Transformation, and Data Cleansing approach for theMDM implementation.
• Scheduled jobs to call the packages and stored procedures.
• Developed Query for generating drill down reports in SSRS 2012 R2/2012.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Wrote T-SQL queries, stored procedures and used them to build packages. Extract Transform Load(ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS)
• Generated several drill down and drill through reports using SSRS.
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on OLAP cubes using SSAS. Responsible for documentation of system related activities. Used Dataset, Data Table, Data Adapter, Data Reader and other ADO.NET connectivity controls
• Created stored procedures and functions to perform business operations on the back-end using MS SQL Server 2012 database
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Created and Managed OLAP Cubes using SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards. Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder 2.0.
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.

Environment: MS SQL Server 2012 R 2/2012/2008/2005 , Business Intelligence, SIS, SSRS, SSAS, * Plus, TOAD, SQL Profiler, T-SQL,MDM, ASP.Net, DHTML, XML, C#, CSS, ADO.Net, AJAX, VB Script, MS Access, Excel, MS Visio, MS Office 2007/2003,Windows 2003/2000/XP .

Confidential, Atlanta, GA

SQL BI Developer (SSRS/SSAS)

Responsibilities:

• Created SQL Server Integration Services (SSIS) packages to import data from heterogeneous data sources like Oracle 9i, SQL Server Text files (CSV, Xls, and XML).
• Understanding the Erwin ER Diagrams
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2012,SQL 2012 Integration Services(SSIS)
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2010 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2012 Analysis Services (SSAS).
• Activities included the design and development of Business Intelligence processes using SSIS to load, extract, and transform data for the university Data Warehouse.
• Maintained Medimmune's Informatica Platform with included Power Centre andMDM.
• Involved in design and development of ETL Jobs using SQL Server Integration Services (SSIS) for data migration between different maintenance systems (VMS, VTrak, and D7i).
• Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance system.
• Created many drill through and drill down reports using SSRS.
• Generated custom and parameterized reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Deployed these reports into the SharePoint after developing the reports.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012(SSAS)
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Scheduling the SSIS packages and Jobs
• Developed perspectives to simplify the process of browsing the cubes.
• Used Lookups Transformation to get the data from data sets
• Created SSIS Packages to migrate slowly changing dimensions

Environment: SQL Server 2012 Enterprise Edition, Business Intelligence, SSAS, SSIS, T-SQL, MDM, SSRS, Windows Server 2008, Oracle 9i, Ms excel 2003, Microsoft Visual Studio 2008.

Confidential, CT

MS SQLServerDeveloper/SSIS/SSAS.

Responsibilities:

• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Building UAT and Test environments using Production back ups.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Experience in building and maintaining Data marts. Created roles for using the cubes
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2005 to SQL 2012
• Used SharePoint views for the end users to do modifications to the data through SharePoint designer.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 R2/2012 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, SharePoint, C#, Asp.NET, Windows Server 2003, MS Access,Oracle 9i, Sybase.

Confidential, Atlanta, GA

Sr. SQL BI Developer (SSIS, SSRS)/Migration Specialist

Responsibilities:

• Converted different types of reports such as Tabular, Matrix, Drilldown and Drill Through from 2005 and 2008R2 to 2010.
• Created Water fall diagrams from scratch using SSRS 2010.
• Converted Dundas Charts reports to using different charts.
• Promoted converted SSRS reports to new environments using SourceControl.
• Converted SSIS packages from .
• Created Project Deployment models, project parameters and package level parameters for all SSIS packages.
• Deployed SSIS packages to Integration ServicesCatalog in SSMS.
• Created different (DEV, TEST, PROD) environments in SSISDB database.
• Developed few SSRS reports and SSIS packages from scratch in 2010.
• Resolved high priority issues during support for SSRS and SSIS.
• Involved in performance tuningof TSQL queries and Stored Procedures.
• Extensively used TSQL in SSRS reports and SSIS packages.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
• Experience in building multidimensional cubes using SSAS and create multidimensional expressions (MDX) queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services using SSAS and SSRS.

ENVIRONMENT: MS SQL Server 2010/2008R2/2005, MS SQL Server Integration Services (SSIS) 2010/2008R2/2005, MS SQL Server Reporting Services (SSRS) 2010/2008R2/2005, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), T-SQL.

Confidential

SQL Developer

Responsibilities:

• Installing, configuring, administering and securing production servers.
• Setup new MS SQL Server instances and databases.
• Capacity planning of MS SQL Servers.
• Implement and maintain database security.
• Going through the clients' requirements and coming up with database design and application architecture.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Maintaining User account administration for Different domains.

Environment: SQL Server 7.0, Transact-SQL, Enterprise Manager, Query Analyzer, MS-ACCESS 2000.

Confidential

SQL BI Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables

Environment: SQL Server 2000, Access, Excel, Query Analyzer, Oracle, Crystal Reports 9.0 and DTS.