SUMMARY:

• Having 6 years of experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2005/2008/2012.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP&OLAP.
• Expertise in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading the data from Oracle, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in creating SQL server Reports using SSRS 2008.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Proficiency in creating diverse types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down, Top N, Summary and Sub reports and formatting them.
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Experience in using Performance Monitor/Profiler to solve Dead Locks.
• Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.

TECHNICAL SKILLS:

Languages: C, C++, C#, .NET (4.5/4.0), T-SQL, PL-SQL, Oracle, HTML, CSS.

Databases: MS SQL Server 2000/2005/2008/2012/2014/2016, Oracle, MySQL.

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, DBCC.

Reporting Tools: SQL Server Reporting Services, MS Excel, Oracle Report Builder.

Application Packages: MS Front Page, Microsoft Suite, SSIS, SSAS, SSRS.

BI Tools: SSIS, SSRS, SSAS (DAX Language), Power BIOperating Systems: UNIX, Windows Server 2000/2003/2008.

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Actively participated in gathering business requirements to implement functional and technical specifications.
• Migrating databases\instances from SQL Server 2008 to SQL Server 2016 version.
• Installed, managed and administrated SQL Server 2016/2014/2012/2008 R2 Databases.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Used USHER product for convenient and secure way to control the Digital access.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment
• Developed SSIS ETL Packages& also modified packages into different environment (Development, Testing & Production), as ongoing requirement changes
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Enhance SSIS packages to perform dynamic functionalities from static configuration, and changed many of the packages by using C# coding for generic usage within the organization.
• Created & modified SSRS reports (2012 & 2016) depend on the requirement on the priority basis from the DW & BW bug tracker applications.
• Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created Development and Production support documents.
• Used Subversion for centralized storage within the Data Warehouse department.

Environment: MS SQL Server 2016, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2016/2013, Visual Source Safe, MS Office, Oracle 10g/ 9i, .Net Framework 4.0, C#.Net, Asp.Net 4.0, JavaScript, SQL Profiler, Red Gate Tools, Excel and Access, Team Foundation Server (TFS).

Confidential, Dayton, OH

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Design ETL packages and workflows for the Data warehouse project
• Design auditing, batching and logging the SSIS workflow.
• Develop SSIS packages to get data from multiple FTP and SFTP data sources.
• Decrypt SFTP files once received and load the data.
• Build SSIS packages using various control flow tasks and transformations to load the data into the databases.
• Work on setting up EDW from different data sources.
• Created ETL to load the data from Source System into stage and to EDW.
• Worked on Creating SSAS tabular Models to build reporting layer for Adhoc reporting.
• Implement Logging to track and create ETL dash boards to monitor the ETL Process.
• Error Handling and Auditing implemented in SSIS to track down the data discrepancies.
• Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file and XML in order to create and maintain a centralized database.
• Applying strategies for data acquisition ODS implementation, and archive Process.
• Designed and built relational databases.
• Worked on power pivot models, power maps and Power view.
• Worked in pulling data and deal with heterogeneous sources and optimize the data extraction and conversion process using SSIS.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors(SSIS).
• Extract and encrypt data files. Send them via SFTP to Client Sites.
• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map and Cross-join.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Designed and developed the reports according to the requirements using Power Map.
• Involved in Installation, Configuration and Deployment of Reports usingSSRS.
• Scheduled the reports to run on daily, weekly basis in the report manager.

Environment: MS SQL Server 2016/2014, Windows Server 2012, SSMS, SSRS, SSIS, SSAS, Report Model, Erwin, Team Foundation Server, Performance Point Server, ProClarity, snap manager, SharePoint (MOSS), FTP, MS-Visual Studio.

Confidential, Chicago, IL

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2012/2008
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Used Try catch and @@error for exceptional handling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2012.
• Managed up gradation of DTS packages to SSIS packages
• Expertise in applying correct filters/slicers on the Power BI report based on business need.

  Experience in consulting with IT, Business Users & Business Analysts for building reports and dashboards based their needs.

• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources ( SQL Server, Flat files, Excel source files) and loaded the data into target tables by performing various kinds of transformations using SSIS
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Responsible for developing, monitoring and deploying SSIS packages.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Created queries for generating drill down reports in SSRS 2012. Formatted the reports using the Global variables, expressions and Functions.
• Created Linked Servers to connect OLEDB data sources and providers.
• Deploying and troubleshooting the SSIS Packages.
• Designing dashboard / reports to give them consistent and professional looks using TIBCO Spotfire professional.
• Using SSRS/Spotfire for development of reports for Business users from various sources like tables, stored procedures and development of several types of reports.

Environment: SQL 2012/2008, DTS/SSIS, SSRS, SSAS, ERWIN, MS Access

Confidential - Trevose, PA

SQL Developer/SSIS/SSRS/SSAS

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 andappropriate 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 OLAPcubes 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 modelling 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.
• Wide experience in Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 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.
• 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.
• Used Tableau to develop dashboards for more intuitiveness as per the user requirements.
• Created Users and Groups and assigned object level security at Tableau server.

Environment: Microsoft SQL Server 2008R2/2008/2005, MS Access, SSAS, SSIS, SSRS, PL/Sql, Visual Studio 2005/2008, ERWIN, Windows server 2003, DTS, TSQL, Oracle 10g, SQL Profiler, DTS, Team Foundation Server, CITRIX.

Confidential

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Actively involved in all stages of Software Development Life Cycle from requirement gathering to maintenance of databases.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Implemented one to one and one to many relationships between the tables in the database.
• Identified and implemented the tables with Primary Key, foreign Key and Identity columns.
• Maintained the Referential integrity between the tables using Triggers and Stored Procedures.
• Created and manipulated the indexes for faster access of database tables.
• Wrote several SQL Scripts to query the tables to enforce constraints on tables with Identity and Primary Key.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Created T-SQL queries, dynamic Stored Procedures that calculate by taking the customer details as input.
• Created views and indexed views to reduce database complexities for the end users.
• Design and develop SSIS package for loading data from OLTP to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension (SCD) to maintain historical data in Data Warehouse.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Created reports using SQL Server Reporting Services (SSRS).
• Improved Performance of the database by creating clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Unit testing and Integration testing for various modules using Test Director.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, MS Office, Visual studio, SQL Profiler, Excel, Access, Windows Server XP, IIS 6.0, Erwin, Test Director.