SUMMARY:

• Over 7+ years of experience in SQL Server database development and administration, extensively worked in OLTP, OLAP, Client - Server & Enterprise Data Warehouse Environments.
• Strong experience in Microsoft Business Intelligence Tools including Integration Services, Reporting Services and Analysis Services.
• Skilled at developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T-SQL.
• Well versed in Normalization/De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Worked with Java scripting to connect or for security of the database.
• Experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in SQL Server 2012 Self Service BI tools like Power view, BISM Tabular models and SQL Server Data tools.
• Strong experience in Oracle database, worked with versions Oracle 9i, 10g, 11g.
• Solid experience in converting legacy MS Access and Crystal Reports to Reporting Services 2008/2008 R2.
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
• Experience in integrating SSRS reports into external applications using report viewer controls and custom URLs.
• Experience in End to End Master Data Management to manage data from multiple sources.
• Hands-on experience in using self-service BI tools such as power view, report builder and BIDS and
• Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Involved in developing reports from SSAS cubes using client tools like SSRS 2008, Excel 2007 and Report Builder.
• Experience in installing, configuring and monitoring MS SQL Server 2012/2008/2005/2000 installations.
• Hands-on experience in Upgrade/Migration of MS SQL Server 2005 to 2008, 2000 to 2005 using any suitable approach.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
• Strong knowledge in implementing Transactional, Merge and Snapshot replications.
• Good understanding of high availability SQL Server solutions using active-active and active-passive Clustering modes.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Sound knowledge of software development life cycle (SDLC) models like Agile and RUP (Rational Unified Process) along with substantial experience with objects oriented analysis and design methodologies.
• Solid experience in version control tools such as Team Foundation Server (TFS) and Sub version (SVN).
• Experience in Data Modeling & Database Design with Erwin, Performance Tuning and Optimization of SQL Server 2005 and 2000.
• Experience in dimensional modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in migration of MS SQL Server 2000 to MS SQL Server 2005 (Side by Side).
• Expertise in writing DML and DDL Code, Dynamic SQL as well as Query optimization& performance tuning
• Expert in using Complex Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), SharePoint 2010 development and Performance Point Services (PPS).
• Hands on experience with data modeling Erwin tools, entity relationship diagrams and data analysis concepts on data warehouse.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SSIS, SSAS, SSRS, SQL Server Agent, SQL Profiler, SharePoint 2007(MOSS)

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, Physical and Logical Data Modeling.

Databases: T - SQL, MS Access

Programming GUI: SQL, PL/SQL

Environment: Windows 95/98/2000/XP/Vista, Sun Solaris, Linux (Red Hat)

PROFESSIONAL EXPERIENCE:

Confidential, Oaks, PA

Sr. SQL Developer

Responsibilities:

• Worked closely with the EHS & DPH leadership for gathering, analyzing and maintaining all the data requirements related to business applications.
• Proficient in BASE SAS and worked on startup project of SAS Enterprise level.
• Utilizing standard data modeling and ETL tools by avoiding hand written SQL or program coding methods, developing and implementing highly efficient, scalable and automated ETL process.
• Worked on various environments of agile methodologies.
• Worked on creating new SSIS packages by using Microsoft visual studio for import and Extract files.
• Performance Tuning of the Database, which includes indexes, and Optimizing SQL Statements, Monitoring the Server.
• Responsible in running monthly reports, managing data extracts/imports. Extensively used Star Schema Methodologies in building and designing the logical data model into Dimensional Models
• Familiar with C#, dot.net programming and Ad Hoc reporting databases.
• Knowledge about File transmission protocols (FTP, web services, XML, Flat File)
• Ensuring adherence and compliance to department policies, guidelines and objectives and working with internal management, external consultants and software vendors.
• Used java script in connecting to the database and also pulling the data out from the tables.
• Experience with oracle and SQL server databases and their native utilities (Query Analyzer, Analytical workbench)
• Worked on Excel reporting to create some simple excel reports by pulling the data from SQL and creating pivot tables on it for one-time requests by the users.
• Hands on experience in SQL server 2008R2/2012/2014 and MSBI(SSIS/SSAS/SSRS)
• Handling prioritized workload, monitoring performance and providing expertise in application, infrastructure and internal support related matters.
• Conducted internal and Final DFD Reviews with the ETL Team, Data Quality, Metadata Management Team, Data Architects, Business and Application Data Stewards
• Handling application security including authentication and role based access control by using metadata including self-generated documentation.
• Worked on Excel reporting to create some simple excel reports by pulling the data from SQL and creating pivot tables on it for one-time requests by the users.
• Providing technical assistance and information to technical and non-technical users.
• Worked with Master Data Management to centrally manage data from multiple sources to get a single and master data.
• Research, analyze and maintain all application and technical documentation.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Responsible for gathering, analyzing, documenting and maintaining all data requirements related to the business application, interfaces and reporting environment.
• Worked on data analysis concepts like data definition, data dictionary and business matrix.

Environment: SQL server 2008R2/2012/2014, MSBI (SSIS, SSAS, SSRS), Erwin, Visio, C, C#, Dot net, SAS, Excel 2013, Power view, Power pivot, Performance Point, T-SQL, Base SAS and SAS/SQL, HTML, XML, VB.NET,SQ1 Server … DB2, Oracle 10g/11i.

Confidential, Mooresville, NC

SQL Developer

Responsibilities:

• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
• Worked on ETL SSIS Development, created packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the System.
• Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.
• Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2.
• Setup and monitored jobs for loading and processing SSAS Cubes.
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2008R2.
• Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created SSRS dashboards using charts, gauges, indicators and data bars.
• Deployed SSRS reports in native and SharePoint mode.
• Used SSRS reports with parameters from Performance Point Services deployed in SharePoint 2013.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Used Master Data Management along with SQL Server 2008 to provide a single view and clean data across all the sources.
• Involved in designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database
• Developed power view reports using Tabular Models in SQL Server Data Tools.
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Extensive used Team Foundation Server to implement version control for MSBI (SSIS/SSRS/SSAS) projects.

Environment: - SQL Server 2014/2012/2008 R2/2008, SharePoint 2013/2010, SQL Server Data Tools, T-SQL,SSIS, SSRS, SSAS, Tabular, Excel 2013, XL-Cubed, Power view, Power pivot, Performance Point, MDX, Report Builder 3.0, DTS, C#, VB.NET, Erwin 4.0, XML, SVN, Rally, Windows Server 2008,.NET 3.5.

Confidential, Perrysburg, OH

SQL Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2012/2008 R2/2008.
• Developed power view reports using BISM tabular models as data source in SharePoint 2010.
• Developed and deployed BISM tabular models using SQL Server Data tools.
• Developed stored procedures with multi-valued parameters for generating complex reports.
• Created operational and analytical SSRS reports from Oracle 11g databases.
• Involved in setting up Report-Models for ad-hoc reporting.
• Created reports from SSAS cubes using MDX and used Excel 2007 and SSRS 2008 R2 client tools.
• Developed Query for generating drill down reports in SSRS 2008 R2/2008.
• Designed and implemented stylish report layouts.
• Creating dashboards consisting of charts, maps, indicators and data bars.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Developed custom report templates, report viewer controls and custom URLs to integrate SSRS reports in Cold fusion application.
• Worked with java scripting to create some connections between various databases on the same server and to join multiple tables to get the required data.
• Rendered reports in multiple formats including Excel, PDF, MS Word and TIFF.
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Scheduled SSRS 2012 Data alerts on mission critical reports to send alerts based on business rules.
• Upgraded SSRS 2005 reports to SSRS 2008 R2.
• Extensive used Sub version (SVN) and Visual SVN to implement version control for reporting services projects.
• Trained new and existing reporting services users with SSRS 2008 R2 features, resolving issues and provide step-by-step documentation on SSRS reports development and deployment.
• Responsible for reporting services installation, security and administration in both native and SharePoint modes.
• Worked on SharePoint 2010 and Performance Point Services with the knowledge of MDX. Created sharepoint pages, master pages, navigation and security, charts, score cards, KPI, SSRS reports and lists. Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients
• Deployed the generated reports directly on the client's workstation.
• Improved Report Performance and performed unit testing.
• Hands-on experience using Master Data Management to manage data from multiple sources with a single view.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses for reporting purposes.
• Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis including the development of logical data models.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Created partition function, schema and file groups for fact tables.
• Wrote stored procedures to transform raw data into suitable format for use in the data warehouse.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins with T-SQL.
• Responsible for performance tuning and optimization of SQL queries and indexes.
• Upgraded SQL Server 2005 to SQL Server 2008 using Side-by-Side approach.
• Involved in web development using C#, VB.NET, ASP.NET, XML, ADO.NET, HTML, VBscript and Ajax.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.

Environment: - MS SQL Server 2012/2008 R2/2008, Oracle 11g, SharePoint 2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tabular, Excel 2013, Power view, Power pivot, Performance Point, MDX, Report Builder 3.0, DTS, C#, VB.NET Erwin 4.0, XML, SVN, Windows Server 2008,.NET 3.5, DTS.

Confidential

SQL BI Developer

Responsibilities:

• Developed and Optimized database structures, stored procedures, Triggers, Views, Joins, Cursors and Functions for the application.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
• Responsible for logical and physical data modeling, database design, data analysis, programming, documentation and implementation.
• Involved in Performance tuning the Stored Procedures to by removing unnecessary cursors.
• Developed SSIS Packages to pull data from Access, Excel sheets and Flat files into SQL Server 2005.
• Performed ETL operations using SSIS to validate, extract, transform and load data to data warehouses.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Developed, deployed and monitored SSIS Packages.
• Responsible for DTS to SSIS Migrations, designing and maintaining SSIS packages.
• Handled the migration of SQL Server 2000 to SQL Server 2005.
• Designed and populated reporting tables, views and stored procedures.
• Responsible for analyzing/gathering the user requirements to generate the reports using SSRS 2005.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Identified the Data Sources and defining them to build the Data Source Views.
• Developed Query for generating drill down and drill through reports in SSRS 2005.
• Formatted SSRS reports using Global Variables, Expressions and Functions for the reports.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Created SSAS Cubes using snow-flake schema with Facts, Measure Groups and dimensions.
• Created SSRS reports from Analysis Services using MDX queries.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup& recovery and performance monitoring.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
• Involved in implementation of replications like Snapshot and Transactional.
• Successfully designed logical and physical database models using ERWIN data modeler, designed initial database migration plans and procedures for migrating data.

Environment: MS-SQL Server 2008/2005, Windows Server 2003/XP, T-SQL, SSIS, DTS, SSRS, SSAS, MDX, C#, VB.NET, ASP.NET, MS Access 97/2000, Oracle, XML, Excel, ERwin4.0, Business Intelligence Studio2008/2005.

Confidential

SQL Server Developer

Responsibilities:

• Involved in writing Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Dimensions, to maintain Historical Data in Data warehouse
• Used configuration files in SSIS to ease the process of moving the packages across servers (development to production).
• Designed and developed tabular reports with drill down, drill through and drop down menu option using SSRS.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server2005, MS SQL Server Integration Services2005(SSIS), MS SQL Server Reporting Services 2005 (SSRS), MS SQL Server Analysis Services 2005 (SSAS), SQL Profiler, MS Office, Windows Server 2003.