SUMMARY

• Over 8+ years of experience using Microsoft Business Intelligence (MSBI) Stack, SSIS, SSRS, SSAS/OLAP and Microsoft SQL Server 2005/2008/2008 r2/2012/2014 in various Health Care, Banking, Finance and Insurance domain.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL and PL SQL.
• 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 using tools like Bulk Copy (BCP), Lookup, Data Transformation Services (DTS) and SSIS.
• Experienced in migration from SQL Server 2008 to SQL Server 2012.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations and involved in package configurations and deployment process.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, Graphs, web reporting by customizing URL Access.
• Proficiency in creating different types of reports such as Cross-Tab, Charts, Conditional, Drill-down, Drill-Up, Drill-through, Top, Graphs, Summary Form, Pivot tables, 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 designing, developing and operating Kimball method Data warehouse DW/BI systems.
• Able to work with minimal supervision in any collaborative environment.
• Knowledge of Data Warehousing (DW) concepts and Data warehouse applications.
• Have experience in PowerShell scripting.
• Have knowledge ofFacets Data Modelin Membership and Billing.
• Knowledge in tableau.
• Have good knowledge on Teradata database development.
• Working knowledge in Agile/Scrum Environment and used TFS team foundation server.
• Highly motivated with an ability to learn new systems and business processes.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills

TECHNICAL SKILLS

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), SQL Server Data Tools Enterprise Manager, SQL Profiler, Query Analyzer

Business Intelligence Tools: Tableau,SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

RDBMS: MS SQL SERVER 2014/2012/2008 R2/2005/2000, MS Access

Programming Languages: C,C#,T-SQL, PL SQL, asp.net,UNIX shell programming, VB.NET, HTML, XML

Data Modeling: ERWIN, MS Visio, Star, Snow flake schemas

MS Office: Word, Excel, PowerPoint

Operating Systems: Windows (XP, 2008 server), Windows 7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

SQL Developer/MSBI Developer

Responsibilities:

• Installed SQL SERVER 2008/2008r2/2012/2014 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system and VM WARE, Hyper - V in PROD/TEST/DEV from scratch.
• Regularly supported service packs and hot fixes for both clustered and standalone SQL Server.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2005 and 2008R2.
• Developed SSIS packages and SSRS reports in SQL Server 2005/2008/ 2008 R2/2012.
• Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
• Performed data cleansing by creating tables to eliminate the dirty data and implemented Error Logging using SSIS.
• Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
• Strong background in Data Warehousing principles and methodologies.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Created Report Models for building Ad hoc reports using SSRS and deployed reports into SharePoint.
• Created and managed roles for security in Reports.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Worked in AGILE methodology in development of Database Objects in SQL Server 2008R2/2012.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server 2012,2008R2,VS2010, Business Intelligence Development Studio (BIDS), T-SQL, XML, Performance Point Server 2007, SSIS, SSRS, SSAS,OLAP, OLTP, Windows 7, Microsoft Excel.

Confidential, Nashville, TN

SQL Developer\MSBI Developer

Responsibilities:

• Responsible for installation of SQL Server, OS, and Cluster Service (2005, 2008, 2012) on all SQL database servers.
• Worked on T-SQL skills in creating stored procedure, functions, views, triggers.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Creating tables with cluster and non-clustered indexes on columns and created various database objects such as tables, indexes and views based on the requirement.
• Performed security updates for all user types and responsible for Clustering.
• Expertise in Performance Tuning, Index Tuning wizard, maintenance, troubleshooting and Query optimization skills.
• Modified the existing stored procedures to get the new functionality depending on the client requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.
• Hands on experience in using different transformations like Script task, Fuzzy Lookup, Derived column, Conditional split, Multicast transformation, Pivot etc., using SSIS.
• Expert in Creating Complex SSIS packages using proper Control and Data Flow elements with the error handling.
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Generated various reports with drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.
• Deployed the SSRS reports in Microsoft office share point portal server.
• Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• 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.
• Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL 2005 databases.
• Experience in working on Agile/scrum.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Used Kimball’s Data warehousing architecture for the ease of end user and for high level of data warehouse performance.
• Works with product development teams and senior designers on complex program designs to develop architectural requirements that meet design and performance requirements

Environment: MS SQL Server 2014,2012,2008R2 VS2010, Business Intelligence Development Studio (BIDS), T-SQL,PL/SQL, XML, Performance Point Server 2007,PL SQL, SSIS, SSRS, SSAS,OLAP, OLTP, Windows 7, Microsoft Excel.

Confidential, Dallas TX

SQL Developer\MSBI Developer

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Performed Data Modeling in ER Studio Data Architect 9.0 in the initial stages of the project.
• Alter the schema for the required objects. Designed and optimized all the SSIS packages.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Created Ad-hoc reports and cascading reports, Pivot Tables for historical data using SSRS 2008.
• Involved actively as a part of team for collecting and analyzing the needs of end user requirement.
• Generated various reports with drilldowns, calculated members, and dropdowns from the cubes by connecting to Analysis server from SSRS and Crystal reports.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy the various report items like charts, maps, images, graphs, tables etc. to the R2 report server along with the reports.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.
• Created subscriptions to provide a daily basis reports.
• Worked on SSRS in SharePoint Integrated Mode.
• Managed and troubleshoot report server related issues.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and Named queries.
• Involved in defining referenced relationships with measure group and fact tables.
• Experience in writing PowerShell scripts.
• Performed day to day Database Maintenance tasks - Database Backups, Space Management, and Resource Utilization, responsible for performing object Migration.
• Worked under Team Foundation Server (TFS).
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs
• Provided on-call support to production system to resolve any issues.

Environment: SQL Server 2012, SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, Crystal reports Server Analysis Services, Business Intelligence Development Studio-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.

Confidential, Bridgewater, NJ

SQL server Developer\SSIS\SSRS\MSBI Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• Responsible for the architecture, design, development and implementation of SSIS templates and packages.
• Designed and created user based reports, admin level reports against the SSIS logs and report server to monitor the SSIS packages and the reports for the execution time using SSRS 2005 and 2008.
• Optimized SSIS packages for the performance as the high volume data flows were taking more than the desired time to execute.
• Created Drill Reports which gives all the details as per business requirements which runs on daily basis using SSRS Reporting services and crystal reports. Designed and implemented stylish report layouts.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Designed the data models to meet the requirements of each report.
• Responsible for the architecture, design, development and implementation of the SSAS 2005/2008.
• Created OLAP applications with OLAP services in SQL Server and build cubes with many dimensions using both star and snow flake schemas.
• Taking weekly database backup and schedules job using SQL Agent.
• Created Logins and server roles.
• Responsibilities include meeting with users to define business rules and requirements and ensuring proper documentation for all phases of the project.

Environment: SQL Server 2005 Enterprise Edition, SSIS, SSRS,Crystal Reports SSAS, XML, T-SQL, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 2008/2005.

Confidential

Business Intelligence MSBI Developer

Responsibilities:

• Involved in Installation, Configuration, Development, Deployment and Troubleshooting Reporting services using SSRS 2000/2005/2008 across various environments.
• Responsible for getting, understanding the business specifications, preparing technical specifications, DTS Packages.
• Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
• Involved in migration of DTS packages to SSIS.
• Creating jobs for scheduling the SSIS packages.
• Using different transformations like excel source, data conversions, lookup functions, Pivot tables OLEDB command, derived columns, OLEDB destination, etc.,
• Designed dynamic SSIS with VB.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Loading these data into data warehouse like SQL server.
• Worked on SSRS to design reports and deploy them to the Report Manager.
• Worked on SSRS with expressions and designing of reports.
• Participated in report authoring, used conditional formatting to make the reports more user friendly.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Wrote and integrated stored procedures to generate the reports.
• Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
• Multilingual SSRS reports are built based on client specifications
• Fine-tuned the complex database stored procedures and increase performance up to 5%.