SUMMARY

• Over 8+ years strong experience in the IT industry as SQL Server and BI Developer in Development and Implementation.
• Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Ad - Hoc Reports.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity and query writing.
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Extensive experience in writing SQL Queries, Stored procedures, Functions, Packages, Database triggers.
• Experienced in Qlikview Server, Creating scheduled jobs for QVD extracts and report reloads.
• Proficient in tuning data flow tasks in SSIS using SQL Profiler, SSIS performance monitor.
• Expertise in solving run time issues using error and event handler, breakpoint, check point and loggings in SSIS.
• Well experienced in creating various types of reports like Tabular, Matrix, Drilldown, Cascaded parameterized, Sub reports, Ad-Hoc Reports, Cross Tab Reports in multiple formats like Excel, Word, PDF, Image, and Power Point using SQL Server Reporting Services (SSRS) and Tableau based on client requirements.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN and hints.
• Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing SQL code, modifying database query.
• Extensively worked in Client-Server application development using SQL, PL/SQL, T-SQL, SQL Server 2008/2010/2012 , SSIS 2010/2012, and SSRS 2010/2012.
• Experience in the Analysis, Design, Development, Testing and Implementation of business application systems.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Experience in MS Excel skills like Pivot Tables, Macros.
• Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Extensive experience in data migration techniques using SQL* Loader, Import/Export, bulk and batch processing.
• Experienced in SDLC data analysis, data modeling, development, testing and documentation of projects.
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data and deploying them on various production servers.
• Experience in Production Support and troubleshooting data quality and integrity issues.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.
• An Enthusiastic and goal oriented team player with excellent analytical, communication and interpersonal skills and proficient in technical writing and presentations.
• Ability to work independently or part of a team to accomplish critical business objectives.

TECHNICAL SKILLS

Databases Tools: SQL Server 2005/08/10/12 , SQL * Loader, TOAD, Oracle SQL Developer, SQL Tool, SQL*Plus, SSIS, SSRS, SSAS, Crystal Report, Visual Basic.

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Dashboard Tools, Web Tools

Reporting Tools: SQL Server Reporting Services (2012/2008), Microsoft Access 2013, MS Excel, Microsoft-Access, Excel

Database: MS SQL Server 2014/2012/2008 , MS Access, SharePoint 2013/2010/2007

Languages: Unix Shell Scripting, XML, C, C#, C++, Java, JavaScript, CSS, VBScript, .Net, HTML, XML

Operating Systems: Windows 2008, 2000 Advanced Server, Windows XP, Windows Vista, Windows 7

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash

Framework: Microsoft .Net Framework 4.0/3.5

Dash boarding/Analytics: Tableau, Qlikview, MS SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

SQLBI SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Used SSIS to unite data from existing system and performed transformations on MS SQL.
• Extract Transform Load (ETL) development Using SQL server 2012, SQL 2012 Integration Services (SSIS).
• Generated drill down and drill through reports using SSRS.
• Created cubes using SSAS.
• Developed SSIS packages with Error Handling.
• Experience in using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Bulk inserted data from huge files to different destination tables in SQL server using SQL Server Integration Services (SSIS).
• Designed, developed, implemented and supported QlikView dashboards.
• Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.
• Wrote many TSQL Stored procedures to perform specific tasks as per the requirements.
• Performed debugging on various Stored Procedures to handle errors.
• Good understanding of healthcare domain, HIPAA regulations and continuous communication with different stakeholders, clients like Medicare, Medicaid, CHIP.
• Developed different kind of reports such as charts, matrix, graphs, etc.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Environment: MS SQL Server 2008/2012, T-SQL, SSAS, SSIS Packages, SSRS, SQL*Plus, MS-Office, Beyond Compare, QlikView, Oracle SQL Developer, SVN.

Confidential, Charlotte, NC

MS SQL SSIS/ETL Developer

Responsibilities:

• Worked with data analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of reporting, decision support and analysis using SSRS and SSAS
• Involved in creating cubes measure groups and dimensions using MS SQL Server Analysis Services (SSAS).
• Experience in developing high performance data integration solutions with SSIS, including extraction, transformation, and load (ETL) packages for data warehousing.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.
• Gathered requirements about the project which was used to create the SSIS 2008 packages.
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.
• Used Package configurations, Variables and Expressions while creating the SSIS packages.
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Used SQL server agent to automate the SSIS package execution.
• Test cases and performed system testing for the SSIS packages using SSIS 2008.
• Implemented caching of reports and managed the report history in the Report Manager.
• Used complex Expressions to create calculated fields and used Global Variables in SSRS 2008R2.
• Deployed and managed the reports in the Report Manager using SSRS 2008R2.

Environment: MS SQL Server 2008R2, SSIS, SSRS 2008R2, SSAS, MS SQL Server Reporting services, MS SQL Integration services, T- SQL,, MS Excel, MS word, Visual Studio 2008. SQL Profiler, Erwin v7.3.

Confidential, Sacramento, CA

MS SQL Server BI Developer

Responsibilities:

• Created databases objects using T-SQL, scripts, stored procedures views and DTS.
• Conducted GAP Analysis and Function Point Analysis to estimate the benefits of the new system v/s. the existing system.
• Scheduled and, conducted meetings with client/user work group members to identify requirements, documented them in SR Specification Documents and Identified Priorities
• Designed Logical and Physical data models using ERWIN data modeling tool.
• Created complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008 R2.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Experience in implemented Stored Procedures and Triggers for automating tasks.
• Experience in migrating Visual source safe (VSS) repository to Team foundation server (TFS).
• Knowledge in working with SAP application.
• Generated MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Compressed data files by removing empty database pages and updating index statistics.
• Managed and monitored the system utilization.

Environment: MS SQL Server Management Studio 2008/2008R2, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), DB2, Microsoft Visual source Safe (VSS), SharePoint MOSS, Oracle9i, XML, ASP.Net, Windows server 2008/ windows 7, TFS

Confidential, Mettawa, IL

SQL Server/BI developer

Responsibilities:

• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Production support, ad hoc queries meeting requirements from other development teams in a test driven agile development environment.
• Design and implementation of SSIS/ETL process for the system.
• Data conversion from mainframe system and Oracle databases to SQL server.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.
• Modified stored procedures to meet current design and used them in SQL Server.
• Moving data from SQL server to Dynamics CRM and initial entity creation.

Environment: MS SQL Server 2008/2008R2, Red Gate tools, PowerPivot, TFS 2013, MS SSRS/SSIS 2008, T-SQL, Visual studio 2005, MS Visio

Confidential

Data base Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various MSBI data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing MSBI (SSIS) packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in SQL Server environment using MSBI (SSRS 2008).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Worked with SQL loader and control files to load the data in different schema tables.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Created database objects like tables, views, Stored procedures, Packages using Oracle Utilities like PL/SQL, SQL* Plus, Toad.
• Developed Complex queries to retrieve the data as per client requests based on certain parameters and restrictions.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP.
• Used Exception Handling extensively to display the error messages in the application.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: SQL Server 2008, SSIS, SSRS, SQL *Plus, MS-Office, Crystal Reports XI, Toad, Windows.