SUMMARY

• Having Over 7 years of professional experience on MS SQL Server Database Design, Development and Analysis related to Health care, Banking and Insurance domains.
• Expertise in managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008/2005.
• Active participation inSoftware Development Life Cycle (SDLC)specifically waterfall and Agile Scrum methodology.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization/ DE Normalization techniques on database Tables.
• Expertise in creating, modifying, using and debugging Stored Procedures, Views, Triggers, User Defined Functions.
• Efficient, in implementing Sub-Queries and Joins for complex queries using multiple tables, using Exception handling.
• Experience inrebuilding the indexes and tablesas part ofperformance tuning in OLTP Databases.
• Experience in partitioning the Table by creating partition Function and partition Schema based on business rules.
• Extensive knowledge on developing applications using C#, .Net.
• Experience in Developing Power BI Reports and Dashboards from Multiple data sources using Data Blending.
• Knowledge of working with Tableau reports and dashboards.
• Experience inupgradationandMigrationofSQL Server 2008 to SQL Server 2012.
• Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
• Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL
• Experience, in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS Packages, using SQL Server Agent
• Experience in designing Ad hoc reports and different types of Drill Down, Drill Through reports, Tabular reports, Crosstabs, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services (SSRS)
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Good experience building star schema and snowflake schema depending on the business data requirements.
• Good knowledge of Azure Subscription, Firewall setting, Connecting with SSMS on premises, Creating and managing Azure SQL Databases.
• Knowledge of DB high availability concepts like MS SQL Clustering, replication and log shipping, DB Mirroring, Database Backup, disaster recovery.
• Experience in query optimization, running DB Consistency Checks using DBCC commands.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Knowledge of generating status report, involved in production support.
• Knowledge of Healthcare domain dealing with the EDI (837/835) transactions of HIPAA.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

• TSQL (2012/2008/2005 )SSIS (2012/2008/2005 )SQL Server (2014/2012/2008/2005 )
• SSAS (2012/2008/2005 )TFS
• SVN
• GITOracle
• SSAS TabularC
• C#
• .NetErwin
• Microsoft AccessPower BIMS Access
• TableauSSRS (2012/2008/2005 )MS Excel

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and calculations.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for migrating the data from Excel files to the ODS data base which is the OLTP data base without any transformations by using SSIS packages.
• Responsible for data analysis, loading data from ODS DB to ENT Data Warehouse DB with transformations using SSIS packages with components Script Task, Fuzzy Lookup, OLE DB, Conditional Split, Derived Column, Slowly Changing Dimension, Execute SQL Task, Multi Task and Cache Transformation.
• Used C# scripts for customized transformations.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Responsible for creating STAR schema using Facts and Dimensions tables in ENT DB.
• Set package configuration in SSIS to redirect path from development environment to test environment.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the date base on Daily basis using SQL Server Agent.
• Created Cubes from the ENT DB which can be retrieved rapidly by enterprise information consumers.
• Designed and configured Dimensions, Attributes, Hierarchies, Aggregations and Cube Partitions.
• Designed KPI’s in cube and imported them to Excel.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports using SQL server 2008 Reporting Services (SSRS).
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.

Environment: Erwin, SSIS, SSRS, SSAS, Excel, Windows, T-SQL, SQL Profiler, SQL Tuning Engine, SQL Server Agent, SQL Server 2008/2012.

Confidential, Irvine, CA

SQL/SSIS/SSRS Developer

Responsibilities:

• Importing data from existing database to SQL Server using SSIS packages
• The SSIS Packages include, a Master Package which executes many of Child Packages with a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop
• Debugging and maintenance of ETL packages and optimization using SQL Server best practices (using non-block transformations and row transformations for better performance).
• Configured dynamic Checkpoints to allow rerunning a package from the point of failure.
• Implemented Event Handlers, Error Handling and Logging for the packages as per the requirements.
• Modified stored procedures to meet current design and used them in SQL Server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Developed Multi-Dimensional Objects (Cubes, Dimensions, Hierarchies, partitions and calculated members) using SQL Server Analysis Services (SSAS)
• Optimized the query performance on SSAS cube by following recommended best practices.
• Developing financial reports based on the cube by bring it into SSRS
• Created jobs, alerts to run SSAS, SSRS packages periodically.
• Developed and troubleshooter of error in connection managers for the source.
• Developed query for generating drill down, drill through and parameterized reports for all the project modules in SSRS.
• Developed dashboards using Tableau desktop.
• Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.

Environment: MS SQL Server 2012/2008, MS BIDS, T-SQL, SSRS, Erwin 4.x, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Management Studio, Transact-SQL, MS Excel, Excel VBA, Windows XP/2003.

Confidential, San Ramon, CA

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Going through the clients’ requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008
• Managing logins, roles, assigning rights and permissions. Created views to implement security
• Troubleshoot and minimize production down issues
• Have written several stored procedures and Triggers as per the client requirements worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP
• Used C# to code in both Script Task and Script component.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers
• Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports
• Designed SSAS cube to hold summary data for dashboards.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Transformed the complex business logic and calculations into coding.

Environment: SQL Server 2008/2012 Enterprise Edition, Enterprise Manager, Erwin, UML, MS Project, Windows 2003 Server, SSIS, SSRS, SSAS.

Confidential, Erie, Pennsylvania

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Gather requirements and design of data warehouse and data mart entities·
• Designed Multi-Dimensional models, DATA MART/ WAREHOUSES and SSAS cubes
• Performs design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2008 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Deployed SSIS packages and Scheduled Jobs
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Generated test cases to meet the functionalities deliverables in the project documentation and specifications.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).
• Ensured database integrity, indexing, segmentation and recovery and update database design over time.
• Developed Reporting structure for account performance Data Mart.
• Performed DBA functions, installing, configuring and supporting SQL Server based databases.

Environment: SQL Server 2008 Enterprise Edition, Enterprise Manager, Erwin, MS Office, Windows 2003 Server, SSIS, SSRS, SSAS.

Confidential

SQL Server Developer

Responsibilities:

• Experience in support and management of databases, systems, applications and Application Development.
• Experience in Implementation of Production environment requirements and application support.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008 and MS SQL Server 2005 databases/ servers.
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Created SSIS packages to load the data into the tables.
• Experience in planning and implementing the Replication of MS SQL Server 2008 Databases and databases Backup recovery strategy.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Experience on working with BRP (Business recovery plans) and EPP exercises (Emergency prepared plans).
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server and database to another database.

Environment: SQL Server 2008, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, SSIS, Windows Performance Monitor.

Confidential

SQL Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2008.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Backupandrestoredatabases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2008, T-SQL, MS-Office, MS-Excel.