SUMMARY

• Over 11 years of IT experience with database development experience, Business Intelligence and have Software Development experience.
• Expert in writing T - SQL and implement SQL server objects.
• Expertise with writing, performance analyzing and troubleshooting complex stored procedures.
• Expert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
• Expert in designing, writing, performance tuning and troubleshooting SSIS packages.
• Expert in MS BI tools (SSIS/SSRS).
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
• Strong expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration Service.
• Experienced in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables and star schema modeling and data modeling for ODS and DW using Erwin.
• Extensive experience with data profiling.
• Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP.
• Expert in database administration activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Expertise in generating enterprise reports using Crystal Reports, SQL Server Reporting Services (SSRS), Tableau and Excel spreadsheet, scheduling and deploying reports on report server.
• Expertise in publish reports in front-end using web viewer.
• Experience in Data Modeling skills using MS VISIO and ERWIN.
• Expert on gathering business requirement and writing technical specification.
• Expertise with agile development.

TECHNICAL SKILLS

• MS SQL Server 2014/ 2012/2008 R 2/2008/2005/2000
• Oracle 10g
• MS Access
• SQL
• Transact-SQL(T-SQL)
• PL/SQL
• C
• C++
• XML
• .NET
• ASP.NET
• MVC
• VB.NET
• C#.NET
• FTP
• SFTP
• Sales Force
• JDBC
• VBScripts
• SOAP
• MS SQL Server Integration Services(SSIS)
• MS SQL Server Analysis Services(SSAS)
• MS SQL Server Reporting Services(SSRS)
• Power BI
• SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Visual Studio 2013/2012/2008/2005
• ERWIN
• MS Project
• TFS
• SVN (Sub-Version)
• Crystal Reports 8.5
• MS VISIO 2003
• 2010
• UML
• Windows Server-2003/NT/XP/2000
• Windows Vista
• Microsoft Azure
• MS DOS
• UNIX
• BCP.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. SQL BI Server Developer

Responsibilities:

• Responsible for design and develop and maintain SSIS packages.
• Create and manage complex stored procedues.
• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Writing ETL process from the scratch using SSIS.
• Working with large volume of data and performance issue for SSIS, SSRS reports.
• Working with production tickets to fix the issues.
• Working with data profiling.
• Building and managing SSRS, Tableau reports.
• Studied the data requirements and the impact analysis on the existing schema.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Normalized and De-normalized entities for the Data Warehouse.
• Work on performance tuning on existing SSIS packages.
• Recognized the fact and dimension tables from the OLAP database.
• Work on creating various such as Tableau, dashboard reports.
• Create and deliver daily ad-hoc report.
• Created linked reports, sub reports as well as drill-through reports in support of management.
• Closely work with the business users to gather business requirements.
• Design, coding, testing, debugging and documentation of applications.
• Working with QA team for testing SQL codes.
• Managed and coordinate with remote user for change request and optimization of application.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Actively participated in the meetings to meet the goals.
• Gathering requirements from business users.
• Tested SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Developed approaches for data warehouse implementation and data acquisition.
• Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.

Environment: MS SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TFS, Visual Studio 2012, ASP.Net 2.0

Confidential, Nashville, TN

Lead SQL BI Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Writing ETL process from the scratch and performance analysis.
• Built various types of SSIS package for ETL.
• Troubleshoot and performance tuning on existing SSIS packages.
• Working with large volume of data performance issue for SSRS reports.
• Working as a production support, find and solve the production issues.
• Working with production tickets to fix the issues.
• Working with data profiling.
• Creates and manage data warehouse.
• Studied the data requirements and the impact analysis on the existing schema.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Normalized and De-normalized entities for the Data Warehouse.
• Work on performance tuning on existing SSIS packages.
• Recognized the fact and dimension tables from the OLAP database.
• Work on creating various such as Tableau, dashboard reports.
• Create and deliver daily ad-hoc report.
• Created linked reports, sub reports as well as drill-through reports in support of management.
• Building Tabular & MDX cubes from the scratch.
• Closely work with the client to gather business requirements.
• Design, coding, testing, debugging and documentation of applications.
• Create test cases to complete ETL development test.
• Working with QA team for testing SQL codes.
• Managed and coordinate with remote user for change request and optimization of application.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Actively participated in the meetings to meet the goals.
• Tested SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Developed approaches for data warehouse implementation and data acquisition.
• Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.
• Efficiently completed maintenance task like checking database integrity, history cleanup, Maintenance cleanup, rebuild indexes, reorganize indexes, update statistics etc.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), SVN (Sub-version), Visual Studio 2012, ASP.Net 2.0

Confidential, Atlanta, GA

Sr. SQL BI Developer

Responsibilities:

• Developed, created and managed complex stored procedures and UDF in SQL Server 2008 R
• Create SSIS packages for new clients.
• Maintain ticket system to fix the production issues.
• Working with EDI team to work with EDI process.
• Create, fixed and maintained daily, monthly jobs scheduled.
• Lead the Migration process from SQL Server 2008 R2 to 2012.
• Created dimensions and fact tables based on the business requirement.
• Designed complex ETL strategies to pull data from different sources, like SQL server, flat files and load it to the destination database after using multiple transformations
• Implemented the Master Child Package Model for easier maintenance and better performance
• Created ad- hoc and drill-through reports.
• Create Tableau reports.
• Created linked reports, sub reports as well as click through reports in support of management.
• Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code to implement business rules.
• Developed approaches for data warehouse implementation and data acquisition.
• Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.
• Efficiently worked on database maintenance task like checking database integrity, database back-ups, history cleanup, maintenance cleanup, rebuild indexes, reorganize indexes etc.

Environment: MS SQL Server 2008/2008 R2, MS SQL Server 2012, SQL Server Reporting Services 2008(SSRS) TFS 2012.

Confidential, Atlanta, GA

Sr. SQL BI Developer

Responsibilities:

• Design and develop Integration Services solution in MS Business Intelligence Development Studio (BIDS).
• Responsible for running, maintaining, trouble-shooting daily production jobs.
• Create dashboard reports using Tableau.
• Creates ETL process for data migration TSQL script and SSIS
• Studied the data requirements and the impact analysis on the existing schema.
• Responsible for creating ad-hoc reports for daily/ weekly/ monthly basis.
• Responsible for creating SSRS, CRYSTAL report.
• Create MDX cubes from scratch.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS with pro clarity 6.3.
• Normalized and De-normalized entities for the Data Warehouse.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Actively participated in the meetings.
• Actively participated in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Create Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Create of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
• Worked on production maintenance tickets.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS). SQL Server Analysis Service (SSAS), Visual Studio 2012, Tableau, TFS.

Confidential, San Francisco, CA

SQL BI Developer

Responsibilities:

• Analyzed the business requirement and functional specifications provided by the data analyst.
• Create various reports (ad-hoc, Tableau, drill-through, crystal).
• Used MS SSIS as the main ETL tool
• Data profiling.
• Developed, created and managed complex stored procedures and UDF in SQL Server 2008 to support the functionality various front-end applications and performing different data
• Operations like data profiling and data verification.
• Created various database objects like Indexes, Views, Triggers and User-defined functions depending upon business rules and optimized them.
• Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code
• Ensured the integrity on the database by creating triggers and constraints to make sure that the data is always stored in consistent way Confidential any given point of time.
• Played a major role in optimizing large tables by creating indexes (clustered and non-clustered indexes) and partitioning the table depending upon the no of records coming in from the front-end application.
• Designed Staging Database using ER-win.
• Created dimensions and fact tables based on the business requirement.
• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, flat files and load it to the destination database after using multiple transformations
• Implemented the Master Child Package Model for easier maintenance and better performance
• Defined Data sources, Data Source views and Created MOLAP cube using SSAS 2008.
• Implemented Attribute Relationships and Hierarchies to design more aggregations in order to improve summarization performance of queries.
• Created ad hoc crystal and SSRS reports in the test environment for data validation
• Created dynamic Reports from the cube using SSRS 2008, and stored procedures.
• Created linked reports, sub reports as well as click through reports in support of management.
• Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.
• Efficiently completed maintenance task like checking database integrity, history cleanup, maintenance cleanup, rebuild indexes, reorganize indexes, update statistics etc.

Environment: SQL Server 2008 R2, SSRS, SSAS, SSIS, Windows 2003 Server / Vista Enterprise, MS Visual Studio 2005, Erwin, Crystal reports.

Confidential, San Francisco, CA

SQL System/ Data Analyst

Responsibilities:

• Responsible for campaign load and create member eligibility.
• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Taking care of EDI process.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Worked with data migration and create complex stored procedures and ETL strategies.
• Created value reports and opportunity analysis.
• Managed and coordinate with remote user for change request and optimization of application.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Actively participated in the meetings.
• Documented all work so that the user can easily understand the flow of the process.
• Work in offshore team from

Environment: MS SQL Server 2005/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services 2008(SSRS), TFS, EDI.