SUMMARY:

• ­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­Over 8 years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2012/2008R2/2008/2005 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) in SQL Server.
• Experience in optimizing code and improving efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Strong technical knowledge in MS SQL Server development including Microsoft Analysis Services, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• 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.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Experience with handling moderate to large tables/databases, Query performance tuning, Distributed Transaction, Distributed Queries/Linked Servers.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Hands on experience in creating the Cube dimensions and facts. (SSAS)
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
• Experienced in report generation using XML, Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet.
• Experience in generating drill down Reports, handling parameterized Reports in SSRS 2005.
• Experience in designing and developing reports using different tools such as Visual Studio and Report Builder.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN.
• Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server 2012/2008/2005 .
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SSAS.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• SQL Server OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience with Power shell language in writing complex T-SQL Scripts.
• Experienced in creating Jobs, Alerts using SQL Server Agent.
• Excellent backend skills in creating SQL Data Objects.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in deploying SQL Server Analysis Services Projects using MS SQL Server.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• Experience with software development life cycle (SDLC) and project management methodologies.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL,.Net(C#,VB)

SQL Server Tools: Management Studio, Business Intelligence Development Studio, SQL Server Data Tools, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard

Databases: SQL Server 2012/2008R2/2008/2005, MS Access, Oracle 9i/10g

Operating Systems: Windows Server 2008/2003/2000, Windows 8/7, UNIX

ETL: SSIS, BCP, Import/Export Wizard

Data Modeling: Erwin Data modeler, MS Visio

Web Technologies/ Tools: HTML, DHTML, XML, Visual Studio, MS Front page

OLAP Tools: SSAS, MS Excel

Reporting Tools: Visual Studio, Report Builder, SSRS, Crystal Reports

Web Servers: IIS, APACHE Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

SQL Reporting Analyst/SSIS

Responsibilities:

• Involved in reviewing the E-commerce application and interacted with business users to understand the report requirements for creating documents like data dictionary and technical specs.
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
• Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012.
• Created reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services and SharePoint.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Involved in migration of several reports of SQL Server 2005 to SQL 2008.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2008 and then created reports using this data using SSRS 2008
• Configured and maintained Report Manager and Report Server for SSRS
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Developed an automated report subscription process using SSRS 2008.
• Developed user requested reports using Crystal Reports and Excel
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Created report links to refer other reports in a particular report. And also created report links for different servers.
• Created report snapshots to improve the performance of SSRS.
• Developed several sales, marketing, finance reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI’s
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Worked with SharePoint 2010 to publish documents and share reports for various Users.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005 and SQL 2008
• Developed complex reports against SSAS Cubes and MDX Queries.
• Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS transformations.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.

Environment: SQL Server 2008, 2008R2 and 2012, T-SQL, SQL Profiler, Report Builder, SSRS, SSIS, Visual Studio 2005/2008, XML, Crystal Reports, Excel.

Confidential, Chicago, Illinois

SQL/SSRS Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for report design and enhancements.
• Interacted with users to get the new report requirements as per the business rules.
• Designed and created SQL Server Tables, Indexes , Stored Procedures , Views, and Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Experience in creating multiple reports ( SSRS ) in Drill mode using tables, financial tables, cross tabs and charts.
• Advanced extensible reporting skills using SQL Server Reporting Services ( SSRS ).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down , Drill through , Cross tab Reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports in SharePoint Mode.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Design, develop and maintain various SSRS Reports in Report Manager, SharePoint.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Environment: Microsoft SQL Server 2012/2014, MS Access, SSDT, HTML, Visual Studio 2010/2013, IIS, Windows server 2008R2, TSQL, Report Builder 3.0, SQL Profiler, SharePoint, Team Foundation Server, CITRIX.

Confidential, Baltimore, Maryland

SQL/MSBI Developer

Responsibilities:

• Involved in Complete Software Development Life Cycle (SDLC) by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created Database Object Schemas, Tables, Triggers and Constraints.
• Designed and developed SSIS packages to import and export data from MS Excel, SQL Server and flat files.
• Migrated data from different sources (delimited, csv, text, fixed width files) to SQL Server databases using SQL Server Integration Services ( SSIS ).
• Developed Complex Packages to load data into Stage and Data Ware House systems.
• Involved in daily, bi-weekly, semi-monthly, monthly, annual batch loads (Full & Incremental) into staging and ODS area, troubleshooting load issues and errors using SSIS.
• Involved in complete SSIS Life Cycle in creating SSIS packages, building, testing, deploying and executing the packages.
• Deployed the SSIS packages to Test and Prod using XML Package Configurations.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Used Various Control Flow and Data Flow Tasks like Execute SQL Task, For Each Loop Container, Derived Column, Data Conversion, etc. for Creating SSIS Packages.
• Designed and Modified XML Package Configurations used different types of Event Handlers to send an automated alert for package Failures.
• Extracted Data from SQL Server to Different File Formats (Excel, Pipe, CSV, Tab, Fixed Width).
• Created Jobs through SQL Server Agent and scheduled them for Daily, Weekly, Bi-weekly, and Semi-Monthly, Monthly and annually based on the business requirements.
• Created Maintenance Plans and setup log files to Monitor SQL Agent Jobs.
• Performed Data Cleansing using several Transformations like Derived Column, Data Conversion, Lookup, Fuzzy Lookup etc.
• Involved with DBA’s for long hour running jobs, Transaction logs being full issues.
• Provided On-Call Support to Production Loads for any SQL Agent Job Failures.
• Involved in writing Documentation of Standards, Best Practices and ETL Procedures.

Environment: Microsoft SQL Server 2012/2008/2005, MS Access, BIDS, SSDT, HTML, Visual Studio 2005/2008/2010, IIS, Windows server 2008R2, TSQL, ..NET, SQL Profiler, Team Foundation Server, CITRIX, CISCO Any Connect, Visual Source Safe.

Confidential, Richmond, Virginia

SQL BI Developer

Responsibilities:

• Created and maintained Databases for development, testing and production environments.
• Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, and Constraints.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed complex T-SQL code for the application.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user’s requirements.
• Worked with T- SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Involved in designing data marts and giving suggestions for the application needs.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Generated different types of SSRS reports using Visual Studio as per the requirements.
• Expertise in report modifications like sorting, grouping and adding rich content to the report as per the user needs.
• Involved in Database Migration from SQL Server 2008R2 to SQL Server 2008.
• Migration of Databases Using Generate Script Wizard.
• Involved in day to day activities like writing the scripts and loading into SVN.
• Experience in version controlling Using SVN.
• Created Logins and Permissions to the developers as per their requirement.
• Involved in migrating users and roles from one database to another database.

Environment: SQL Server /2008 R2/2008/2005, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, MS Access, MS Excel, MS Visio, Windows Server 2003 Enterprise Edition, HTML, SVN.

Confidential, Denver, Colorado

SQL Server SSRS/SSIS Developer

Responsibilities:

• Installed and Configured SQL Server 2008R2 successfully.
• Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• 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.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Developed scripts to migrate data and the database objects to/from multiple sources.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in creating front end user interface to allow customers to interact with the application using C# objects and HTML.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed complex stored procedures using T -SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Proficiently created Reports based on the requirements using SSRS 2005, 2008.
• Identified the database tables for defining the queries for the Reports.
• Defined parameters for parameterized Reports.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Excelled in deployment and generation of Reports.
• Migrated data from different data sources.
• Converted few reports from crystal reports to SSRS.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre calculated measures.
• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery.
• Held responsibility for database maintenance plans.
• Actively involved in gathering and analyzing stakeholder’s requirements

Environment: SQL Server 2008 R2/2008, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, C#, MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, HTML

Confidential, Charlotte, North Carolina

SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Involved in system analysis & design of the Enterprise data warehouse implementation, Requirements gathering and understanding the business flow.
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Creation of database tables and procedures to update and clean the old data.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
• Created PL/SQL code to validate and convert the invoice data from non-oracle data format to Oracle databases.
• Designed dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS (Microsoft Office SharePoint Server).
• Developed OLAP cubes using SSAS and calculate the metrics that were revealed in the functional analysis.
• Created MDX script for representing Cube Calculation using SSAS.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Proficient on and designing Data Mart and Data Warehouse using Erwin in Star and Snowflake Schemas.
• Helped Database administrators with power shell in building robust administration scripts.
• Wide experience in Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Responsible for support of MOLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.
• Well-versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing Reports from Multi-Dimensional OLAP Cubes.
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2005.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Modifying existing Sybase stored procedures to make them ready for Sybase IQ data warehousing use.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Environment: Microsoft SQL Server 2008R2/2008/2005, MS Access, SSAS, SSIS, SSRS, PL/Sql, HTML, Visual Studio 2005/2008, IIS, Query Analyzer, ERWIN, Windows server 2003, DTS, TSQL, ..NET, SQL Profiler, DTS, Team Foundation Server, CITRIX.