SUMMARY

• Over 7+ years of IT industry experience with Microsoft SQL Server 2000/ 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS, and OLAP as SQL Developer.
• Extensive SQL Development experience in Banking, Insurance, Healthcare and Telecommunication industries with a strong understating of data & analytics
• Expertise inMS SQL Server Installation,Configuration, Migration and Maintenance.
• Experienced in working withSQL Query Analyzer,SQL Server Management Studio and Business Intelligence Development Studio.
• Involved in all the phases of software development life cycle (SDLC) process.
• Highly proficient in the use of T - SQL for developing stored procedures triggers and various database objects. Experience in executing software lifecycles such as Agile (Scrum), RUP Iterative Model, Incremental Model, Waterfall and Object Oriented Methodologies.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Expertise in Report writer.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in upgrading or migrating Analysis Services.
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Proficient in working with Multidimensional Expressions (MDX).
• Expertise in UDM and Data Mining objects.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team.
• Expertise in approaching strategies for designing the appropriate DMExpress solution.

TECHNICAL SKILLS

Languages: SQL, T-SQL, C, C++, HTML.

Databases and Databases tools: SQL Server 2012/2008R 2/2008/2005. SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

BI Tools: SSIS (SQL Server 2005/2008/2008 R2, 2012 Integration Services),SQL Server 2000 DTS, Import Export Data, Bulk Copy Program (BCP)

Tools: and Packages: SQL Server Management studio, Business Intelligence Development studio, Visual Studio .NET.

Productive applications: MS Office- 2010/2007/2003/2000, Adobe Professional.

Operating Systems: Windows / 98/2000/2003/ XP/Vista /7, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

MSBI Developer

Responsibilities:

• Designed relational data base in SQL server for Line Management section. Applied data integrity rules, defined relationships between foreign and primary keys in the tables.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
• Generated Reports using Global Variables, report expressions (including simple VB codes) and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2008.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server
• Used various transformations such as Lookups, Multicasts, Pivots, Derived Columns, Merge joins, Conditional splits etc. when data transformations process was done.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
• Expertise in scheduling and running the DMExpress applications
• Worked On DMExpress client software that is used to develop the jobs
• Look up transformation was used to check whether data is already in the source table before inserting. SQL task was used to truncate or delete tables before loading data.
• Added SQL Server Providers for logging to capture information about a package at run time, making it easier to troubleshoot package performance and failure. Performed package, container, and task level logging.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS)
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment inTFS2012.
• Created various SSIS configuration settings including SQL Server and XML configuration files. Implemented Check Points to restart execution of failed packages only from the point of failure instead of re-running the whole package from the start.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Generated SSRS report form SSAS OLAP Cube.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Documented design and development works for report deployment, uploaded reports into SharePoint site, created new pages and folders and maintained reports in SharePoint site.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.
• Created different SQL jobs and maintained those jobs in the production.
• Used Ralph Kimball’s Data Modeling concept when designing an OLAP cube for Line Management section. Created dimension and fact tables. Created SSIS packages and stored procedures to load those dimension and facts tables.
• Partitioned the cube for current year and previous years in order to improve the performance.
• Created MDX queries to create custom pivot reports and calculated members in the cube.

Environment: MS-SQL Server 2012/2008R2/2012, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, WindowsServer 2012, MS-SQL Server Analysis Services, T- SQL, MDX, Source Safe, Team Foundation Server (2012)

Confidential, Ann Arbor, Michigan

MSBI Developer

Responsibilities:

• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• 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.
• Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Worked on other packages of the SQL server 2008 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Performed ETL using SSIS by extracting data from various data sources such as MS Access, Excel, Flat files, CVS files and network locations
• Designed and developed Star and Snow Flake Schema as a data analyst.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created reports with Analysis Services Cube as the data source using SQL Server 2008/2008R2 Reporting Services.
• Involved in developing and modifying XML reports for exporting the reports to web application.
• Involved in providing information to functional segments of the organization using Data marts.

Environment: SSIS, SSRS, SSAS, MS SQL Server 2008 R2,OLAP, ERWIN, Front Office 8.3 / 10.2 / 10.3, Windows 2008, MS Office 2010, TFS2010.

Confidential, Austin, TX

SQL Server SSRS/SSIS Developer

Responsibilities:

• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
• Responsible for scheduling the subscription reports with Data Driven Subscription Windows File share and Email Delivery using SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Worked on Report Subscription for Report Delivery using Email Delivery for the NFPs and FSA(Fed) Using Data Driven Subscription.
• Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, maintenance.
• Developed complex packages which takes data from various sources like excel, Flat file, DB2, oracle using AS400 IBM and ODBC drivers, calling reporting service within the package to create SSRS reports on fly and calling web service to transfer data of XML type.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Involved extensively in designing of OLTP database
• Created schemas, keys and indexes considering the granularity of the data
• Designed data flows, workflows and jobs to load data from source to target in BO Data Integrator.
• Schedule Data Integrator jobs using Data Integrator Administrator.
• Develop data staging tables and created indexes in the destination table in order to make the ETL process faster than expected.
• Deploy the packages in production server ad schedule the packages according to the requirements.
• Deployed SSIS packages and Reports to Production Servers.

Environment: SQL Server 2008 R2, Visual studio 2008, SSIS, Window 7 Professional, windows server 2007, Microsoft Dynamics, Performance Point Server 2010, Share Point 2010.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Developed Business Process Flows and created ER diagram using ERwin for social media management software for the development team to understand the system.
• Designed a relational database using Erwin data modeling tool. Created logical and physical data models. Defined the relationships between primary and foreign keys in tables. Generated the data base script using Erwin.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Integrated Database maintenance jobs to perform full, differential & transaction log backups and scheduled them with the SQL Server agent job scheduler. Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into destination databases for further Data Analysis and Reporting.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Created rollback and committed transactions in SQL queries, used collections, inserted various kinds of constraints and indexes to enhance the queries.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.
• Write complex SQL queries and create stored procedures for retrieval of the data and analysis of the data. Created complex Triggers, Functions, Indexes, Tables, Views, SQL Joins and T-SQL code to implement business rules.
• Identified key dimensions and key measures. Built dimensional model and assign hierarchy, attribute relationship to the various dimensions and measures defined using SSAS.
• Written SQL queries, MDX queries and developed Social Media reputation reports like dynamically driven cascade parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2008/2008R2. Create scorecards, KPIs and dashboards, analytical charts and reports.
• Use different features like grouping, sorting, and reports parameters to build sophisticated reports. Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical reports from SQL/OLAP data sources using SQL Server 2005/2008/2008 R2 Reporting Services.

Environment: MS-SQL Server 2005/2008/2008 R2, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, MS-SQL Server Analysis Services, TFS 2008,T- SQL, MDX, SharePoint Server, MS Access, MS Excel, Visio.