Summary

• Over 6 years of experience as Technical Solutions Developer/ IT Consultant for SQL Server 2005/2008R2/ 2012/2014 and major Business Intelligence platforms SSIS, SSAS, Tableau 8.0, Qlikview 11.
• Experience Analyzing, Designing and Documenting Logical, Physical data models, SQL Server Strategies and plans for clients in Insurance and Healthcare Domain.
• Worked on various activities of table partition and moving partitions to different file groups to reduce IO latency and CPU utilization.
• Worked as Database Administrator handling databases of 1TB and configuring Clustering Active-Passive, Active- Active , Database Mirroring, Log Shipping, Server Upgrade and Server patching.
• Designed database models for DataWarehouse as well as designed ETL strategies to integrate needed data into existing dimensional data warehouse.
• Highly efficient in adopting Microsoft stack technologies to automate the developing, debugging and executing database unit tests interactively in SQL Server Data Tools SSDT .
• Involved in designing, developing and deploying complex Data Warehouse using Star Schema, Snow Flake Schema depending upon business needs as supported by organization.
• Adept with process automation, data integrity, and adherence to business rule requirements for tuning of existing processes.
• Worked on developing stored procedures and creating schema design for Line of Business applications.
• Developed disaster recovery plans and automating the processes by developing PowerShell 2.0, 3.0 scripts.
• Designed, Implemented and coordinated with developers to tune large volume databases for end user clients like METLIFE, USI Holdings, COMCAST, PADI.
• Performed and implemented complex ETL Strategies that would grab data from various different heterogeneous sources like DB2, Oracle, Flat Files, and Excel Files and dump it into centralized Data Warehouse in accordance to business scenario.
• Extended the functionality of newly created SSIS packages by implementing transactions, checkpoints, error-handling, logins and configurations and deployed them on the production servers.
• Created OLAP cubes using MultiDimensional SSAS by implementing various facts, dimensions, hierarchies and granularity levels.
• Implemented Calculated Members and Key Performance Indicators KPIs , Perspectives and other cube objects for better analysis.
• Involved in creating Drill down Reports, Sub-Reports, drill through and parameterized reports using SQL Server Reporting Services SSRS .
• Adept in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services SSRS .
• Developed Report Models based in Relational databases and created Ad Hoc reports to the specific users in the requested formats Using Report Builder 2.0/3.0.
• Great understanding of delivery modes that compliment business policies and needs like push delivery, pull delivery of reports using Standard/Data Driven Subscription in SSRS.
• Debug and test new software or significant enhancements to existing software applications typically on C , Asp.net MVC 4, Web Services, WCF.

TECHNICAL SKILLS:

• Database technology: SQL Server 2012 2008/R2 2005 2000, Oracle 9i, MongoDB
• BI Tools: SSIS, SSAS, SSRS, SSDT, Seagate Crystal Reports 9.0,
• Power Pivot, Power View, TFS, SharePoint
• Third Part Tools : Redgate SQL Compare Pro, SQL Monitor, SQL Backup Pro, Quest SQL Toad
• Programming languages: C , Asp.net, T-SQL, PL/SQL, C , Python, jQuery, Javascript
• Cloud Computing: Windows Azure Amazon Web Services
• Continuous Integration Tool: Jenkins

WORK EXPERIENCE:

Confidential

Role: Senior SQL Server BI Developer

Responsibilities:

• Designed data workflow plan for migrating data from IBM DB2 to SQL Server 2012 and developed SSIS packages for auditing and regression testing of data.
• Developed database schema for storing spatial data using Geometry and Geography datatypes and created PADI Dive Shop locator using google maps.
• Developed highly efficient SSIS packages as part of migration activity and index tuning of database for bulk load of data from other databases.
• Worked with the business analysts to gather business requirements for Online materials and eLearning and created the logical and physical data modeling using ERWIN.
• Implemented new BI solutions and converted legacy VB, VB.Net applications to SSIS packages.
• Implemented transactions at package level and task level to meet the business requirements.
• Implemented Package configuration/parameters to make packages dynamic in order to modify the SSIS packages from a test /development environment to the production servers for day to day operation.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
• Creating dashboard for observing the performance of different zones in PADI by designing star schema for SSAS cube.
• Designed different types of reports using Report Designer 2008R2/12 for analysis and validating the information inserted to the data mart.
• Formatted and extended reports by creating parameters within reports, multi value parameters and extended reports with expressions as well as embedding functions with expressions
• Using PowerPivot/View, and created multiple rich dashboards visually telling stories of the business status, strength weakness, potentials etc. for the company at a glance, also interact with data as necessary.
• Deployed reports to the Report server in Native Mode SharePoint Integrated Mode and implemented Report delivery using Subscription in SSRS.
• Responsible for authentication and authorization on SSRS reports using Report manager and Active directory.

Environment: ER-Win, SQL Server 2008R2/12, SSIS, SSAS, SSRS , Redgate SQL Monitor, Power Pivot, Quest SpotLight, Power View, TFS

Confidential

Role: Senior SQL Server/ETL Engineer

Responsibilities:

• Used various approaches to collect the business requirements and worked with the business users for ETL application enhancements by conducting various JAD sessions.
• Used Erwin to design the 'Dimensional Model' of the Data mart with team.
• Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Optimized the existing Index by analyzing and came up with more efficient plan to use Clustered and Non-Clustered Indexes for significant performance boost.
• Used SQL Profiler and Database Engine Tuning advisor tools to optimize indexes and execution plans.
• Designed Mappings between Sources to Staging Targets, Using Star Schema, and Implemented logic for incremental load using Checksum and CDC.
• Developed SSIS Packages for ETL process to load and transform the data from multiple sources into the data mart.
• Developed master child package technique to manage big ETL projects efficiently.
• Identified and handled early arriving Facts and late arriving dimensions using inferred dimensions.
• Implemented Package configuration/parameters to make packages dynamic in order to modify the SSIS packages from a test /development environment to the production servers for day to day operation.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS.
• Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.

Environment: ER-Win, SQL Server 2008R2/12, SQL Server Agent, SSIS, SSAS, Reporting Services, Power Pivot, Power View, TFS, SharePoint

Confidential

Role: SQL Server/BI Developer

Responsibilities:

• Responsible for coordinating with many departments to assure satisfactory data content, quality, data integrity and receipt of desired information using SharePoint and other services.
• Rich experience on creating and management of schema objects such as tables, views, triggers, indexes, stored procedure and maintained referential integrity between these instances.
• Identified potential blocking, deadlocking transactions and written SQL code to avoid those situations.
• Fine-tuned SQL queries using Show Plans and Execution Plans for better performance.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in the Analysis and creation of Staging DB, various facts and Dimensions in the data warehouse.
• Developed SSIS packages to extract, transform and load data from multiple input sources like flat files, excel with multiple sheets, Production SQL Servers into SQL Server 2008R2 Staging Database.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Written C script to load data from multiple sheets of an Excel work book and to customize the loading from flat files.
• Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Tested the packages developed to find out any bug and handled the errors encountered at the time of testing.
• Deployed the package after performing the debugging steps.
• Created various types of hierarchy to enable easy navigation for the end users.

Environment: SQL Server 2008/R2, T-SQL, SSIS, SSAS, SSRS, MS Excel, ER-Win, MDX, SharePoint

Confidential

Role: SQL/ETL Developer

Responsibilities:

• For better performance of the application Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Developed various types of stored procedure parameterized and without parameterized for most of the operation of the front end application.
• Database documentation was created for table and column dictionaries and other reference material.
• Responsible for the indexing and troubleshooting performance issues as well as fine-tuning queries and stored procedures

Environment: SQL Server 2008/R2, Transact-SQL, SSIS, SSRS Reporting Services , ERWIN.

Role: SQL/SSIS Developer

Confidential

Responsibilities:

• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
• Successfully implemented indexes on tables and views for optimum performance tuning.
• Supported some business specific relationships, and advance constraints by embedding triggers on tables.
• Set up scheduled Jobs and alerts for updates and backups.
• Involved in designing of shift based reports, chart reports line and column , parameterized reports for performance analysis.
• Set up report delivery schedules and report back up schedules by configuring subscriptions and snap shot respectively

Environment: SQL Server 2008/05, T-SQL, SSIS, SSAS, Crystal Reports 8.0