SUMMARY

• Over 8 years of experience in Data Modeling, Dimension Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2014for both OLTP (Batch Processing, Online Processing) & Kimball Methodology.
• Experience in various business domains like financial services, Insurance & healthcare, in high transactional and multi-server production environments.
• Strong T-SQL experience in creating database objects like tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes.
• Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, Star schema for OLTP/OLAP systems.
• Involved in heavy data migration/ETL activities using BCP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) 2012.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2012 advanced features in Control flow, data flow, Error Handling and event handling.
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Real time Experience in Modify SSIS Package & Create SSIS Package by using different sources like XML, SSAS cube, Web-service.
• Development & maintain Tools like C#, C++ related work tool.
• Extensive experience in SSRS (Reporting services) and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Form, OLAP and Sub reports, and formatting them.
• Migration of SSRS reports from SQL 2008R2 to SQL 2012.
• Developing reports on SSAS & SSRS on SQL Server (2012/2014). Good Experience and understanding of SSAS, OLAP cube and Architecture.
• Worked on SQL BI solution integration with Microsoft SharePoint Server (MOSS).
• Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Involved in Security Administration, Managing schemas (2012), creating Credentials, creation of users, configuring permissions and assigning roles to users.

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

MS SQL Server/ Business Intelligence Developer

Hardware/Software: MS SQL Server 2008/2012, SSRS 2008/2012,2016,2017, SSIS 2014, SSAS 2008, SSMS, MDX, ASP.NET, VB.NET, C#.NET, T-SQL, MS Share Point and Excel/Power BI,Infromatica, Austosys Job scheduler

Responsibilities:

• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2012.
• Creating and managing schema objects such as Tables, Views, Indexes, Unique/Check Constraints and referential integrity depending on user requirements and converting them into technical specifications.
• Developed SSIS packages to transfer data from OLTP to OLAP database.
• Developed the SSIS packages with different transformations, precedence constraints, configuration settings, check points and security levels while gathering data from different sources.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2014 and refined the existing cubes by adding the new attributes to the dimensions and defining the relationship between the new attributes and the measure groups.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, and sub reports using SSRS 2012 and migrated the reports from SSRS 2012 to SSRS 2014.
• Wrote complex MDX queries to develop the Calculated Members and while gathering the data from the OLAP cubes while generating the reports in SSRS.
• Integrated the reporting services with MS Share Point while deploying the reports.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.
• Added/modified Users, Groups, folders, rights and implemented log shipping, mirroring to maintain the high availability of the servers.
• Ran/Tested required queries, reports before publishing and scheduled the tasks to run every day to update changes in the base tables.
• Published the reports.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/modified SQL Joins, sub-queries, and other T-SQL and PL/SQL code to implement business rules.
• Involved in documenting the project steps and presenting to the team members.

Confidential, Pasadena, CA

Responsibilities:

• Managed index, statistics and optimize queries by using execution plan for tuning the database.
• Participate in sprint planning session to elicit requirement, design decisions and estimate effort required to complete a product backlog item (PBI) using agile scrum methodology.
• Extensive experience with optimizing existing stored procedures and various T-SQL queries.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Performed ETL operations using the SSIS and PL/SQL.
• Created SSIS packages to import and export data from Excel, text files and various flat files.
• Developed various processes and automate it using T-SQL for exporting data to different systems.
• Deployed and Schedule SSIS Package for Production Support & Requirement from Client Side.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Produced parameter driven, matrix, sub-reports, and integrated report hyperlink functionality to access external applications
• Migrated data from SQL Server 2008 R2 to the SQL Server 2012 using SSIS as ETL tool.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.

Confidential, Brea, CA

MS SQL Server/ Business Intelligence Developer

Hardware/Software: MS SQL Server 2008/2012, SSRS 2008/2012, SSIS 2014, SSAS 2008, SSMS, MDX, ASP.NET, VB.NET, C#.NET, T-SQL, MS Share Point and Excel/Power BI.

Responsibilities:

• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2012.
• Creating and managing schema objects such as Tables, Views, Indexes, Unique/Check Constraints and referential integrity depending on user requirements and converting them into technical specifications.
• Developed SSIS packages to transfer data from OLTP to OLAP database.
• Developed the SSIS packages with different transformations, precedence constraints, configuration settings, check points and security levels while gathering data from different sources.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2014 and refined the existing cubes by adding the new attributes to the dimensions and defining the relationship between the new attributes and the measure groups.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, and sub reports using SSRS 2012 and migrated the reports from SSRS 2012 to SSRS 2014.
• Wrote complex MDX queries to develop the Calculated Members and while gathering the data from the OLAP cubes while generating the reports in SSRS.
• Integrated the reporting services with MS Share Point while deploying the reports.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.
• Added/modified Users, Groups, folders, rights and implemented log shipping, mirroring to maintain the high availability of the servers.
• Ran/Tested required queries, reports before publishing and scheduled the tasks to run every day to update changes in the base tables.
• Published the reports.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/modified SQL Joins, sub-queries, and other T-SQL and PL/SQL code to implement business rules.
• Involved in documenting the project steps and presenting to the team members.

Confidential, Los Angeles, CA

MS SQL Developer/BI developer

Hardware/Software: MS SQL Server 2012/2014, SSRS 2012, SSIS 2012, T-SQL, C#.NET 3.0, Visual studio 2012, ASP.NET, DTS, Data Analyzer, java script, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2, VSS 2012,Power BI

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the halp of SSIS.
• Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS 2012.
• Designed and developed SSIS packages to move data from SQL 2012 to SQL 2014.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2012.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Created parameterized, drill down and sub reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Developed data access layer using C# classes.
• Established backup and recovery of SQL server 2012.
• Wrote complex MDX queries to develop the Calculated Members and while gathering the data from the OLAP cubes while generating the reports in SSRS.
• Integrated the reporting services with MS Share Point while deploying the reports.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.
• Ran/Tested required queries, reports before publishing and scheduled the tasks to run every day to update changes in the base tables.
• Published the reports.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/modified SQL Joins, sub-queries, and other T-SQL and PL/SQL code to implement business rules.

Confidential, Los Angeles, CA

SQL Server/SSIS /SSAS/Data Stage

Hardware/Software: MS SQL Server 2012, .NET, Data Stage 8.0/7.5.1(Ascential, IBM Web Sphere), Management Studio, SSIS, SQL Profiler, MS Excel (Documentation), Windows XP Professional.

Responsibilities:

• Responsible for migrating data from staging area to enterprise-wide data warehouse to store reliable data for decision support systems using DataStage.
• Gathering and analyzing the requirements from both external and internal users.
• Created reports using SQL Server Reporting Services based on the requirements.
• Responsible for transferring the data using SSIS packages.
• Involved in creating web portal for External clients using Microsoft SharePoint 2010.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Transform data in ODS databases and load in the Enterprise data warehouse using SQL Server Integration Services.
• Used several stages like Transformer, Sequential flat file, Aggregator, Remove Duplicates, Merge, sort, and Lookup during the development process of the DataStage jobs.
• Working to design Dimension model for Business Process during project.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• SSIS Package Deployment to Production Server as well as Job Scheduling for Package In Daily bases.
• Generate Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Create Complex SSIS Package from POS/XML Source.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the project work in Interface and for all process.