SUMMARY

• Over 8 years of Database Design and Development experience on SQL server 2012/2008/2005 & SQL Server 2000 in OLTP and OLAP environment.
• Expertise in generating reports using SQL Server Reporting Services (SSRS)2008/2005 and Tableau.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Expert in Ad - hoc reports, drill down and drill through reports, sub reports and cross tab reports.
• Expert in creating Dashboards and using different types of Gauges.
• Expert in creating SSRS reports using Bar charts, Line charts, Pie charts.
• Experience in developing and monitoring SSIS Packages and DTS packages.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2012/2008/2005
• Experience in implementing Change Data Capture and Table partitioning
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Expertise with T-SQL in writing complex queries, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and maintaining data integrity.
• Good understanding of Microsoft Systems Center Operation Manger (SCOM).
• Experience in using tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Experience with the .NET framework including C#, ASP.NET and Web Service.
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2008/2005, Oracle 8i/9i, MS Access.

Database Tools: SSIS, SSAS,SSRS, Enterprise Manager, Query Analyzer, SQL Profiler, Management Studio, SharePoint 2007,COGNOS 6.5/7.0, Crystal Reports 9.0/10

Programming Languages: SQL, TSQL, VB.NET, XML, C++, Java, VB 6.0

Scripts: JavaScript, VBScript, HTML, DHTML and XML

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express

Applications: Microsoft Office, Visio, and Visual SourceSafe

Operating Systems: Windows 9x/NT/2000/XP. Unix

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

SSIS/SSRS/SQL Developer

Responsibilities:

• Upgraded database tables from and 2012.
• Designed and developed databases for OLTP and OLAP Applications.
• Implemented Change Data Capture and Table partitioning.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
• Designed and developed SSIS ETL/ELT processes (SSIS 2008).
• Monitored allproduct and system applications by coordinating with Development.
• Monitored health of multiple environments and different products.
• Created SSIS packages to transfer data across heterogeneous data sources.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS).
• Developed reports in Tableau.
• Experience in strong SQL debugging skills, application level troubleshooting skills, Experience with monitoring tools and techniques, good understanding of security Practices.
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created triggers, UDF, views, tables and generated TSQL script for application.
• Analyzed execution plan and optimized queries by creating indexes.
• Created user defined functions in SSRS using VB script.
• Deployed SSRS reports on Microsoft office share point (Moss).
• Developed Test Plans and Test Cases.
• Created Cubes in Analysis Services.
• Created and executed manual test cases for a variety of applications, understand features and accurately created test scenarios and expected results, documented overall testing status for project, and communicated results and recommendations to team.
• Write SQL queries in SQL Server databases to validate data entered by service methods and to setup data for testing scenarios.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube’s data
• Created dashboards and scorecards using Dundas charts.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Tested the data with complex queries, joins and sub queries.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Written scripts using C # programming to customize the reports in SSRS environment.

Environment: SQL Server 2005/2008,SSRS 2008/2005,SSIS 2005,SSAS, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP

Confidential, Cleveland, OH

SSIS/SSRS/SQL Developer

Responsibilities:

• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports using SQL Server Reporting Services (SSRS).
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
• Created SSRS reports using Bar charts, Line charts, Pie charts.
• Created gauges and used gauges as Key Performance Indicators
• Created complex stored procedures for Reporting services
• Defined the report layout in SSRS.
• Analyzed Reports and Fixed Bugs in stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Design web based resource areas in collaboration with IT guidelines.
• Collaborate with the Operational business units to assess, design and maintain online reference materials on SharePoint.

Environment: SQL Server 2005/2008,SSRS 2008/2005,SSIS 2005,SSAS, T-SQL, Crystal Reports, T-SQL, Excel, Access, Windows 2000/XP

Confidential, Des Moines, IA

SSIS/SSRS/SQL Developer

Responsibilities:

• Upgraded database tables from and 2008.
• Designed and developed databases for OLTP and OLAP Applications.
• Created complex Stored Procedures for data retrieval.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
• Created SSIS packages to transfer data across heterogeneous data sources.
• Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Created dashboards and scorecards using Dundas charts.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Experience in strong SQL debugging skills, application level troubleshooting skills, Experience with monitoring tools and techniques, good understanding of security Practices.
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created triggers, UDF, views, tables and generated TSQL script for application.
• Analyzed execution plan and optimized queries by creating indexes.
• Created linked servers to fetch data from Oracle.
• Created user defined functions in SSRS using VB script.
• Deployed SSRS reports on Microsoft office SharePoint (Moss).
• Created Cubes in Analysis Services.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube’s data
• Tested the data with complex queries, joins and sub queries.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Written scripts using C # programming to customize the reports in SSRS environment

Environment: SQL Server 2005/2008,SSRS 2008/2005,SSIS 2005,SSAS, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP

Confidential, Pittsburgh, PA

SQL Developer/ DBA

Responsibilities:

• Provided support to 75 database Servers. Support included Production, QA and Development
• Worked on Migration from SQL Server
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Wrote complex T-SQL Scripts for generating reports
• Wrote stored procedures and designed triggers
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output
• Ensured Security by defining access control to data
• Generated reports using SSRS
• Designed and developed DTS packages for data import and export
• Configured Linked Servers
• Worked on OLAP and OLTP
• Interacted with development and testing team
• Importing and exporting of Databases using various techniques like BCP, DTS
• Analyzed and Installed Security patches as required

Environment: SQL Server 2000/2005, .NET Framework, ASP.NET, ADO.NET, WINDOWS 2000/2003

Confidential 

SQL Developer

Responsibilities:

• Implemented the database for production and marketing purpose.
• Designed databases for OLTP applications
• Created tables, indexes and constraints.
• Created Triggers, Stored procedures for implementing the business logic.
• Managed Database files, transaction log and estimated space requirements.
• Configured and monitored database application.
• Designed and implemented several complex reports
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Created stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database
• Managed ongoing activities like importing and exporting, backup and recovery.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.

Environment: SQL server 2000, Visual Basic 5.0, Win NT.