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 teh business process and transforming requirements into screens, performing ETL, documenting and rolling out teh 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 teh 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 BI

Operating Systems: UNIX, Windows Server 2000/2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

SQL BI Developer/SSIS

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/2008R2 Databases.
• Managed teh entire ETL process involving teh access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding teh business requirements, analyzing source system, source files, setting up teh goals for implementing teh new client.
• Created teh Logical, Physical model and ETL Mapping Documents based on Business logic.
• Used USHER product for convenient and secure way to control teh Digital access.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse teh data.
• Configured teh 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 teh packages by using C# coding for generic usage within teh organization.
• Created & modified SSRS reports (2012 & 2016) depend on teh requirement on teh priority basis from teh DW & BW bug tracker applications.
• Worked on teh 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 teh 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 teh OLAP reporting needs.
• Created Development and Production support documents.
• Used Subversion for centralized storage within teh 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

Responsibilities:

• Design ETL packages and workflows for teh Data warehouse project
• Design auditing, batching and logging teh SSIS workflow.
• Develop SSIS packages to get data from multiple FTP and SFTP data sources.
• Decrypt SFTP files once received and load teh data.
• Build SSIS packages using various control flow tasks and transformations to load teh data into teh databases.
• Work on setting up EDW from different data sources.
• Created ETL to load teh 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 teh ETL Process.
• Error Handling and Auditing implemented in SSIS to track down teh 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 teh 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 teh reports using SSRS.
• Designed and developed teh reports according to teh requirements using Power Map.
• Involved in Installation, Configuration and Deployment of Reports usingSSRS.
• Scheduled teh reports to run on daily, weekly basis in teh 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

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 teh 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 teh SSIS Import/Export, migrated teh 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 teh 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 teh 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 teh 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 teh statistical analysis of teh 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 teh reports using teh Global variables, expressions and Functions.
• Created Linked Servers to connect OLEDB data sources and providers.
• Deploying and troubleshooting teh 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

Responsibilities:

• Involved in system analysis & design of teh Enterprise data warehouse implementation, Requirements gathering and understanding teh business flow.
• Designed teh Functional Requirements and Mapping Technical Specifications on teh basis of Functional Requirements.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors andappropriate User defined functions to implement teh business logic.
• Creation of database tables and procedures to update and clean teh 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 teh invoice data from non-oracle data format to Oracle databases.
• Designed dashboards, including scorecards and reporting with teh Dashboard Designer delivered via MOSS (Microsoft Office SharePoint Server).
• Developed OLAPcubes using SSAS and calculate teh metrics dat were revealed in teh functional analysis.
• Created MDX script for representing Cube Calculation using SSAS.
• Involved in data modelling for teh 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 teh users and troubleshooting teh problems involved with teh development of stored Procedures, triggers and problems related to teh privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Used Tableau to develop dashboards for more intuitiveness as per teh 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

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 teh tables in teh database.
• Identified and implemented teh tables with Primary Key, foreign Key and Identity columns.
• Maintained teh Referential integrity between teh tables using Triggers and Stored Procedures.
• Created and manipulated teh indexes for faster access of database tables.
• Wrote several SQL Scripts to query teh 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 teh T-SQL overhead successfully by avoiding unnecessary use of teh UNION, statement & using teh TOP operator to limit teh Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Created T-SQL queries, dynamic Stored Procedures dat calculate by taking teh customer details as input.
• Created views and indexed views to reduce database complexities for teh 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 teh database by creating clustered and non-clustered Indexes and by optimizing teh 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.