PROFESSIONAL SUMMARY:

• Overall 7 Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2014/2012/2008 R2/2005, SSIS and SSRS.
• Expertise in SQL Server 2012/2008R2/2005 Reporting Services (SSRS), SQL Server 2012/2008 Integration Services (SSIS) and in SQL Server 2012/2008 Analysis Services (SSAS) in Business Intelligence (BI).
• Excellent knowledge to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like Microsoft Excel.
• Excellent in Design of ETL SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating reports using SQL Server Reporting Services, like Crystal Reports, parameterized reports, sub reports, drill down reports, drill through reports, MS Excel spreadsheets and PowerPivot for client requirements in SSRS 2005/2008.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions and features.
• Good understanding of Normalization / De - normalization, Normal Form and database design methodology.
• Expertise in writing SQL Queries, Dynamics, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS).
• Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.
• Experience in Migrating Data from an older version to newer version of MS SQL Server 2012.
• Expertise in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, OLAP and Sub reports in Business Intelligence Development Studio.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Good knowledge of Software Development life Cycle (SDLC) and N-tier Application Architecture.
• Expertise in Functional testing, Manual Testing, Automated Testing, User Acceptance testing (UAT), System testing in working environments.
• Experienced in creating interactive dashboards and scorecards utilizing Power BI.
• Hands on experience in MS Power BI desktop and Power BI service.
• Hands on Experience in Data Migration from MS SQL Server to Oracle ERP Systems.
• Very good communication and interpersonal skills, hardworking and an excellent team player.

TECHNICAL SKILLS:

Tools & packages: SQL Server Management Studio(SSMS), MS Visual Studio 2010/2008, Business Intelligence development Studio(BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), SharePoint 2010/2007, Enterprise Manager, Team Foundation Server

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

Language: T-SQL, ASP.net, VB.net, C#

Operating Systems: Windows 7/ Vista /XP professional. Windows Server 2008/2003/2000, UNIX.

Application Packages: MS Office 2013/2007/2003/2000 (Word, Excel, Power Point, Access).

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

SQL Server/SSIS Developer

Responsibilities:

• Created and worked on complex stored procedures, cursors, common table expressions (CTE’s), temp tables and SQL Joins and statements for applications by using T-SQL.
• Worked on optimization and tuning of SQL queries and Indexes.
• Generated T-SQL scripts for data retrieval, manipulation and validation for various applications and used version control tool to track the code changes.
• Transformed data from various data sources like Excel, Flat file using OLE DB connection by creating various DTS packages.
• Created SSIS/DTS packages and scheduled them using SQL Server Agent.
• Exposure to complete development life cycle of Data Warehouse design and development.
• Modified the existing custom reports and deployed them to the prod server using SQL Server Reporting Services (SSRS).
• Used various SSIS tasks such as conditional split, multicast etc which did Data scrubbing, including data validation checks during staging, before loading data into Data Warehouse.
• Worked with MS Team Foundation Server (TFS) for code check-in and code check-out as part of the code deployment process.
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler and Database Engine tuning Advisor.
• Extensively used T-SQL in constructing view, indexes, CTE’s, Tables, Joins, Relational database models and data integrity.
• Involved in validating data using SQL queries, testing data and reports and doing User Acceptance Testing (UAT) before production.

Confidential, Phoenix, AZ

SQL Server/SSIS Developer

Responsibilities:

• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2012.
• Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts.
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Maintained error logs for the Stored Procedures.
• Used Team Foundation Server and Visual Source Safe as a version control tool.
• Developed logical queries to not triggering email limit error for ETL batch jobs.
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2010, Team Foundation Server (TFS), MS VISIO, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, Microsoft Office SharePoint Server

Confidential, Charlotte, NC

Sr. MS BI Developer

Responsibilities:

• Interacted with business resources on a daily basis for analyze business processes, requirements progress and deliverables.
• Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow.
• Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Created packages using the various control flow task such as data flow task, execute SQL task.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2012.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated monthly reports and budget analysis to drive forecast production plan with SQL Server Reporting Services (SSRS).
• Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Created database objects like tables, users, roles, stored procedures, triggers.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Worked on Data Warehouse Modeling with SQL Server Analysis Services (SSAS).
• Involved in automating SSIS Packages using SQL Server Agent Jobs. Generated Parameterized reports, Sub reports, Drill down and Drill through reports using SQL Server Reporting Services (SSRS) working along with MDX queries.
• Involved in Analyzing, Designing and testing of OLAP cubes with SQL Server Analysis Services (SSAS) 2012.
• Debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed dashboards with Power BI which display key KPIs for business analysis and decision making.
• Published reports on Power BI services, shared dashboards utilizing within the office 365.

Environment: MS SQL Server 2012, Micro Soft Visual Studio, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, Oracle, ASP.Net and C#.

Confidential, San Jose, CA

Sr. MS BI Developer

Responsibilities:

• Worked with Business Analyst in Gathering the Business Requirements and analyzing to design and create the database.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Created package configurations for dynamic connection string to enhance the ease of package deployment, implemented Event Handlers and Error Handling in SSIS packages.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server2008 R2 and Flat files.
• Created corresponding RDLs by using the stored procedures on New System.
• Using SSRS creating well-formed reports and web-based reports for Finance related applications and transactions.
• Advanced extensible reporting skills using SQL Server 2012/2008 Reporting Services (SSRS).
• Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Defined Key Performance Indicators (KPI’s) metrics to create scorecards.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created SSIS Packages to move files from one location to another using FTP Task.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Optimized queries by using Execution Plan for better tuning of the database.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Having worked on configuring and developing Power BI dashboards.
• Experience in refreshing dataset using Power BI gateway.
• Worked on Data transformations, Data Migration/ Data Conversion to extract data from SQL Server Databases.
• Worked on Data Migration activities such as extracting, migrating, validation of data.
• Created SQL scripts for tuning and scheduling.
• Created extensive stored procedures and updated tables and triggers as per the changes in the requirement.
• Involved in debugging and testing of reports in SQL Server Reporting Services (SSRS).

Environment : SQL Server 2012/2008/2008 R2 Enterprise Edition, VB Script, ASP.NET,XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Tableau.

Confidential, Dublin, OH

ETL/SSIS/SSRS/ Developer

Responsibilities:

• Requirement gathering and understanding the trends that is to be shown in the reports.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Written complex stored procedures and SQL queries.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Worked on tuning the queries and fixing the stored procedures to get the data consistency.
• Using various SSIS data transformation tasks like SCD, Look-ups, Fuzzy Look-ups, Merge Union-All, Conditional Splits, Multi cast, Derived column etc.
• Wherever required, ETL process was created, the reports, will be stored, refreshed and utilized in the report on daily basis.
• Involved in design of SSIS Package configuration, logging, deployment & job scheduling.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Create Tabular, Drill down, and Parameter reports using SSRS and configured Reports Snapshots, Report Caching for reporting performance.
• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL task, Send mail task, for each loop, row count, union all, merge, data conversion etc.
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL Server Management Studio.
• Developed SSRS Reports weekly and monthly for business requirements.
• Designed and developed custom .NET components and user controls using ASP.NET.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.
• Developed SSRS reports which include dynamic grouping fields, drilldown and dashboard report and Export reports into various formats such as PDF, HTML, EXCEL, and WORD.
• Created Dashboards using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008/2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio.Net 2008 (C#.NET), ASP.NET, Web service.

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

• Developed complex T-SQL codes for the application.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications using SQL 2005/2008.
• Designed and implemented the stored procedures, minus/union, inline queries, and triggers for automating tasks in relational database management system.
• Developed SQL Server Stored procedures and DTS packages to extract data from database.
• Implemented constraints on tables.
• Created SSIS Packages to migrate slowly changing dimensions.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Testing of applications for performance, data Integrity.
• Database and Log Backups and restoration, backup strategies, scheduling backups.
• Generated reports using MS Reporting services.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Created indexes, constraints and rules on database objects.
• Documenting the current project work and process.

Environment: SQL Server 2005, MS Access, DTS, Query Analyzer, SSIS, MS reporting Services, Erwin, Import & Export Data, Windows 2003 Server.

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service (SSRS) 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2008 Integration services (SSIS).
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Create Tabular, Drill down, and Parameter reports using SSRS and configured Reports Snapshots, Report Caching for reporting performance.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service (SSRS) 2008.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Generated SSRS Reports using global variables, expressions and functions for various reports.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008/2008R2, SQL Server Integrating Services (SSIS), SQL Server Reporting Services (SSRS), C#.NET, VB Script, MS Access, MS Excel, SSIS, BCP, T-SQL.