SUMMARY:

• 8+ years of experience in design, development & analysis of SQL Server 2014/2012/2008/2008 R2/2005 and hand on experience in SQL Server Business Intelligence tools (BIDS) - SSIS and SSRS in various Industry domains.
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation
• Expertise in writing T-SQL Queries, sub-queries and complex joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors, migration.
• Worked on Power BI and prepared dashboards using Tableau to drill down deep on Reporting needs for the client.
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Extensive experience in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import and Export Data
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, DrillDown, Drill-Through, Multi-valued parameters etc.
• Hands on experience in Power BI.
• Experienced with DAX to create various calculations, including ratios to total/parents, financial comparisons between dates and previous runs.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Worked with report manager for deploying the reports across all the environments.
• Extremely diligent with an ability to take new roles.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

BI Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS)Databases: MS SQL Server 2014/2012/2008/2008 R2/2005/2000, Oracle 8i/9i/10g, MS Access and DB2

Web Technologies: HTML, XML, XSL, JavaScript.

Application Packages: MS Office, MS Outlook (Microsoft Office Suite), Microsoft Dynamics

Languages: T-SQL, C#, VB.NET

Operating Systems: Windows Server 2012/2008/2003/2000 advanced server, Windows XP/7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Hawthorne, CA

Responsibilities:

• Gathering reporting requirements from client and analyzing requirements.
• Generated reports that could be used to send information to different Primary vendors, clients and managers.
• Developed Dashboards to analyze sales, ranking and graphical representation.
• Generated Report to visualize the huge data in Geographical by city state and county.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement. Performing query plans and making sure each query is using appropriate useful indexes.
• Optimized long running stored procedures and queries for effective data retrieval.
• Experience in maintaining the database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
• Worked on various tasks and transformations in SSIS like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Automate and enhance daily administrative tasks, including space management, object alteration, and performance monitoring.
• Implemented replications like Snapshot and Transactional.
• Experience in using Windows Azure.
• Experience in using Power Shell.

Environment: SQL Server 2008/2014, Replication, T-SQL, Windows 2008 64- bit, DTS, Red Gate, Profiler.

Confidential

Responsibilities:

• Managed and Administrated SQL SERVER 2008 Production, QA and Beta Environment
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure (400), Constraints and Roles.
• Migrated databases from SQL Server 2000 to SQL Server 2008 and documented the process with Pre-Migration and Post-Migration steps.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Checking Database Health by using DBCC Commands and DMV’S.
• Monitored and modified Performance using execution plans and Index tuning.
• Scheduled jobs to run the SSIS Packages on timely manner using SQL Server agent.
• Worked on trouble shooting and fine-tuning of databases for its performance
• Did Performance Tuning of the Stored Procedures.
• Routine Developer/DBA jobs like Backups and Restores
• Hands on experience in trouble shooting database issues.
• Update statistics, database integrity check and Backup operations
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call and remote - 24/7 Support on weekly basis.

Environment: SQL Server 2000/2008, Replication, T-SQL, Windows 2008 64- bit, DTS, Red Gate, Profiler.

Confidential

Responsibilities:

• Integration of invoices and payments from ChromeRiver to Confidential .
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Constraints and Roles.
• Scheduled jobs to run the SSIS Packages on timely manner using SQL Server agent.
• Did Performance Tuning of the Stored Procedures.
• Created dashboards for financial Analysis of the expenses.
• Routine Developer/DBA jobs like Backups and Restores
• Hands on experience in trouble shooting database issues.
• Update statistics, database integrity check and Backup operations
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call and remote - 24/7 Support on weekly basis.

Environment: SQL Server 2014, Replication, T-SQL, Windows 2012 64- bit, DTS, Red Gate, Profiler.

Confidential

Responsibilities:

• Worked as a developer on database MS SQL Server 2008.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Designed and implemented the Logical and Physical model of the database.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Installed and maintained MS SQL Server 2008.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Maintained the consistency of the client’s Database using DBCC.

Confidential, Hawthorne, CA

Responsibilities:

• Created database design, ER diagram.
• Wrote complicated stored procedures related to invoices and billing
• Designed SSRS report design and wrote procedures related to the reports.
• Monitored and modified Performance using execution plans and Index tuning.
• Worked on trouble shooting and fine-tuning of databases for its performance
• Scheduled jobs to run the SSIS Packages on timely manner using SQL Server agent.
• Did Performance Tuning of the Stored Procedures.

Confidential

.Net & SQL developer

Responsibilities:

• As a member of Confidential (Data automation System) team, involved in Designing and Coding.
• Worked on Creating Store Procedures, Triggers, Indexes for fast file processing.