SUMMARY:

• Over 8+ years of IT industry experience with Microsoft SQL Server 2000/2005/2008/2012, SSRS/SSIS/SSAS as SQL Developer.
• Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• Expertise in scripting T - SQL queries, complex stored procedures, user defined functions (UDF), Database triggers, Java Script.
• Extensive experience in Performance monitoring and tuning of SQL Statements, Sub Queries, Joins, Cursors and Functions.
• Good knowledge of defining and deploying and developing Star Schema, Snow flake Schema and Dimensional Data modeling, cubes using MS SQL Server Analysis Services (SSAS) on a Data Warehouse.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS 2008/2005/2012.
• Experience in Data Modeling (Logical and Physical Design of Databases) using Visio/Erwin, Normalization and building Referential Integrity Constraints.
• Proficient in server side programming like Stored Procedures, Stored Functions, Database Triggers, Packages using PL/SQL and SQL.
• Experience in Data Modeling, Database Design, Programming and Implementation of Client-Server Applications & Database systems using MSSQL 2000/2005/2008/2012 for both OLTP (Batch Processing, Online Processing) & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008/2012 .
• Knowledge in creating the MDX cubes and dimensions.
• Expertise in developing reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Sub reports and filters, charts in SSRS 2005/2008.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and Re-indexing.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Designed and written the queries in the query builder for retrieving the data.
• Experience in developing applications reports (10g/9i/6i). Well experienced in backend programming (Triggers, Procedures, and Functions) using Oracle 11g/10g/9i/8i/8.x and web enabled application development and deployment using Oracle application server.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated Organization, Orders, Adjustments, Objectives and Callidus data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008/2012/2014.
• Developed Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP) and Hybrid OLAP (HOLAP).

TECHNICAL SKILLS:

Platforms: Windows95/98/Me/XP/NT/2000Server/XP/2003 server/Vista,Linux, and UNIX

Data Warehouse/BI Tools: SQL Server Business Intelligence Development - SSIS, SSRS, DTS, Performance Point Server, Informatica and Data Stage

RDBMS/DBMS: MS SQL Server 2000/05/08, MS Access, Oracle 11g/10g/9i/8i/

Database tools: Management Studio, Enterprise manager, Query Analyzer, DTS,BCP, SQL Navigator and PL/SQL Developer, OSQL, Performance Monitor, Client Configuration Utility, Server Configuration Utility, SQL Agent, SQL Mail, SQL Trace, Visio, SQL Server Agent.

Web Technologies: HTML, DHTML, XML, XSLT, XMLA, IIS, Apache

Programming Languages: C#.Net, VB.Net, Java, JavaScript, VBScript and ASP.Net, T-SQL,And PL/SQL

Reporting tools: SSRS 2005/ 2008/2012/2014, Crystal Reports, Developer 11g/10g/9i/6i.(6i, Reports 10g/6i), Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Lakeland, FL

Sr SQL Developer/ SSIS/SSRS

Responsibilities:

• Developed Various SSRS reports for the easy analysis of Claimants information.
• Worked on various Adhoc reports.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations.
• Generated Drill Through, Drill Down, and Ad hoc Reports. Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server. Scheduled the monthly/weekly/daily reports to run automatically.
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server.
• Dynamically supported business users for given requirements and developed the reports accordingly.
• Generated Tabular reports, Linked reports, parameterized reports to SSRS reports.
• Scheduled and Maintained jobs for data messaging from development server to test server for generating daily reports.
• Developed various T-SQL stored procedures, triggers, views, cursors, stored procedures, functions and adding/changing tables for data extraction, data load and transformations.
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server.
• Created various database objects such as tables, indexes and views based on the requirement.
• Developed SQL Queries to fetch complex data from different tables in remote databases by using joins, database links and formatted the results into reports and kept logs.
• Generated Tabular reports, Linked reports, parameterized reports to SSRS reports.
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Environment: MS SQL Server 2010/2008/R2/2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows 2007, Business Intelligence Development Studio (BIDS), XML, Java Script, .Net.

Sr. SQL Developer Consultant

Responsibilities:

• Responsible for the creation of reports/cubes using SQL Server 2005 Reporting Services (SSRS) and Analysis Services (SSAS). Created various reports using MS Reporting Services (SSRS). And deploy public reports in dynamic Web portal.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting. Tested and analyzed relational and OLAP data. Enforced different business constrains and rules using triggers and check constraint.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Developed SQL scripts to pull the required dashboard data from QNXT staging by applying the business conditions and rules.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects. Developed dimensions and fact tables based upon the requirements and based on these facts and dimensions, designed SSAS cubes.
• Generated Drill Through, Drill Down, and Ad hoc Reports. Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server. Scheduled the monthly/weekly/daily reports to run automatically.
• Generated reports that can handle dynamic grouping and dynamic sorting. Was involved in Debugging and then scheduling the reports to run automatically. Created monthly dashboard Reports for automatic changing of User Credentials.
• Provided technical support to internal developers and external clients. Set up database backup and recovery strategies.

Environment: MS SQL Server 2008, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Windows server 2003, and Visual Source Safe.

Sr SQL Developer Consultant

Responsibilities:

• Design and develop various customized reports like Sub-reports, drill-down reports, parameterized reports for different users.
• Involved in designing and developing the Back End functionality using SQL Server 2008/2012.
• Developed Various SSRS reports for the easy analysis of Claimants information.
• Worked on various Adhoc reports.
• Create stored procedures to generate required datasets based on individual report specifications.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and Re-indexing.
• Develop SQL Scripts to dynamically manipulate data and generate well-formatted reports based on user requirements.
• Test, modify and/or debug internally developed reports and stored-procedures.
• Designed and developed the required SQL stored procedures and database functions using SQL Server 2008.
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from database.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Business Intelligence Development Studio (BIDS)

Sr SQL Developer Consultant

Responsibilities:

• Design and develop various customized reports like Sub-reports, drill-down reports, parameterized reports for different users.
• Involved in designing and developing the Back End functionality using SQL Server 2008.
• Developed Various SSRS reports for the easy analysis of Claimants information.
• Worked on various Adhoc reports.
• Create stored procedures to generate required datasets based on individual report specifications.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and Re-indexing.
• Develop SQL Scripts to dynamically manipulate data and generate well-formatted reports based on user requirements.
• Test, modify and/or debug internally developed reports and stored-procedures.
• Designed and developed the required SQL stored procedures and database functions using SQL Server 2008.
• Involved in performance testing. Involved in performance tuning, query optimization.
• Designed ETL packages for different data sources (XML, SQL Server, and Flat Files). Created indexes for the fast retrieval of data from the database.
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from database.
• Worked on advanced dimension Design and Cube design.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).

Environment: SQL Server 2005/2008, JavaScript, SQL Server Reporting Services (SSRS) and XML

Sr SQL Developer/ SSRS

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed various T-SQL stored procedures, triggers, views, cursors, stored procedures, functions and adding/changing tables for data extraction, data load and transformations.
• Performed Fine Tuning of SQL, PL/SQL Procedures.
• Involved in development of User Interface Objects (Reports9i) and Testing of entire module.
• Created various database objects such as tables, indexes and views based on the requirement.
• Developed SQL Queries to fetch complex data from different tables in remote databases by using joins, database links and formatted the results into reports and kept logs.
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server.
• Dynamically supported business users for given requirements and developed the reports accordingly.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and Re-indexing.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Generated Tabular reports, Linked reports, parameterized reports to SSRS reports.
• Scheduled and Maintained jobs for data messaging from development server to test server for generating daily reports.
• Created Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP).

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS)

Sr SQL Developer/SSRS

Responsibilities:

• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Created packages in SSIS with error handling.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the Olap processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts.
• Involved in migration of SSRS from SQL 2000 to SQL 2005.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, 2003, and Sybase.

SQL Server Developer/T-SQL

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions.
• Created the storage type (ROLAP), Created cubes for Business Intelligence.
• Involved in writing MDX Scripts for the Olap Cubes.
• Configured SSRS 2005 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in building and maintaining Data marts. Created roles for using the cubes.
• Wrote DTS packages to transfer data from heterogeneous database and different files format (Text File, Spread Sheet) to SQL Server.
• Actively involved in Normalization & De-normalization of database.
• Materialized views, dimensions and stored outlines for optimal performance.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise.

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.Net

SQL Server Developer/T-SQL Consultant

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions.
• Configured SSRS 2005 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Actively involved in Normalization & De-normalization of database.
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.Net, MS PowerPoint, and MS Project