PROFESSIONAL SUMMARY:

• Around 7 years of experience in the analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.
• Experience in Logical &Physical Data modeling, data architecture designs.
• Good Experience in Data Warehouse development starting from inception to implementation and ongoing support, Strong Understanding of BI application design and development principles
• Excellent command with MS SQL Server 2016/ 2014/2 worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Experience in ETL from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT.
• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Good Knowledge in Microsoft SQL Server 2016, 2014, 2012, 2008 and 2005 backend programming.
• Designed and developed DS data flows and ETL components.
• Outstanding skills in using Client/Server architecture in implementing MS SQL Server based applications.
• Experience with Backup and Recovery of MS SQL 2016/ 2014/2 Server Databases.
• Good Experience in creating SQL objects like Tables, Complex Stored Procedures, Triggers, Views, Indexes, and User Defined Functions to facilitate efficient data manipulation and consistent data storage.
• In - depth knowledge of T-SQL (DDL and DML).
• Experience in Database design, Development, Data Modeling, Administration, ETL packages using DTS / SSIS, Performance Tuning, Stored Procedures for Database applications using MS SQL Server 206/2014, 2012, 2008 R2, 2008, 2005
• Proficient in implementing all transformations available on the SSIS toolbox.
• Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel
• Experienced in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Installed, configured and maintained SSRS server.
• Experienced in creating ad-hoc reporting in SSRS.
• Experienced in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export and SSIS packages.
• Excellent in creating reports, dashboards, standardize templates setting up new parameters and implementing the reports in different process with writing observations, insights, recommendations in the reports.
• Create usage base reports and performance monitoring Power BI dashboard reports by extracting data from DMV’s and Performance Counter.
• Explore data in a variety of ways and across multiple visualizations using Power BI and designed the new dashboards in Power BI
• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power BI Service Desktop tool.
• Worked on creating reports using Power BI desktop like tabular report, Bar graph, icon map.
• Good Experience in Data Visualization development using Tableau to create complex, and innovative dashboards. Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports.
• Experience in reports validating and modeling data with the purpose of understanding or making conclusions from the data for decision making.
• Functionality includes CGI Advantage Finance & HCM integrated with Info Advantage reporting, Neogov Recruiting & Applicant Management, and KRONOS Time & Leave.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX

Databases: MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000

DWH/BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual studio 2 /2010/2008, Crystal Reports, Tableau 9.0/10.3, Info Advantage, Power BI

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques, RDBMS, OLTP, OLAP

Packages: MS Office, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Microsoft Office, ALM

Operating Systems: Windows 2003/2000/VISTA/XP/7/8, NT & Windows 9x, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Grand Rapids, Michigan

Business Intelligence Developer II

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Worked in multiple large end-to-end data warehousing implementations in different domains.
• Expertise in the concepts of Data Warehousing, Dimensional Modeling, logical and physical Data Modeling.
• Migrated data from legacy system (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) and stored procedures to overcome the transformation constraints.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Worked on migrating data from non-relational database to relation database.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Written complex stored procedures and SQL queries.
• Worked on tuning the queries and fixing the stored procedures to get the data consistency.
• Data migration (Import & Export using BCP) from text to SQL Server 2016.
• Experience in execution of test cases in complex data warehousing projects and reporting results.
• Semantic Layer setup for the self-service BI, building tabular cubes, for Power BI and implementing DAX expressions and Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis from multiple data sources to visualize the reports.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2015.

Environment: Windows2008 Advanced Server, Advanced SQL, MS SQL Server 2014/2016, Notes, SSRS, SSIS, SSAS, Power BI, Query Analyzer, TFS.

Confidential, Ann Arbor, Michigan

SQL BI (SSIS SSRS) Developer

Responsibilities:

• Project is designed in two phase's data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL.
• Designed a dashboard for the business user using tableau and SSRS.
• Worked on Medicaid and Medicare and creating drilldown and drill through reports, Created SQL server reports using SSRS 2008 for manager, customer support and that can deliver at client's station, Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports.
• Created reports based on Views, Base tables, stored procedures and commands. Modified existing reports based on the user requirement and created running totals, sub-totals and used crystal syntax to create complex formulas for the reports. Developed sub reports in order to display data from database of two different servers.
• Created Crystal Reports Repository objects (Reports template, commands)
• Creating different reports based on queries and stored procedure, where created or modify stored procedures for reports in Waterfall Environment.
• Involved in using Tortoise SVN to check in and check out SSRS reports and SSIS packages.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012, Oracle and IBM DB2.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Implemented medium level complexity tabular and graphical time series and graphical reports.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
• Extensively used views for complex joins queries involving multiple tables from different databases.
• Experience in publishing reports, workbooks, data sources and dashboards to Tableau server in different Formats. Created complex data views manually using multiple measures, also used sort, Filter, group, Create Set functionality.

Environment: SQL Server 2008R2, DB2, TSQL, PL-SQL, HTML, XML, XSL, Crystal Reports 2011, Tableau 9.0/10.3, MS Share Point, MS Dashboard, Waterfall methodology, SVN, GIT, Rally and Windows 2008 Server.

Confidential, Phoenix, AZ

SQL BI (SSAS SSIS SSRS) Developer

Responsibilities:

• Analyzing and Establishing security features in SQL Server Reporting 2016 Environment.
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
• Developing reports using SQL Server Reporting Services in SSRS 2016. Creating various value sections in Parameters list, designing cascading parameters, matrix dynamics and more features in Reporting Service.
• Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Worked on SQL Profiler, Tuning Advisor in SQL 2016 to increase the performance of the reports.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL
• Server Agent.
• Worked with report subscriptions in SSRS 2016 to send the weekly run automated reports to end users.
• Worked with Report Snapshots
• Develop complex MDX, Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Designed and developed OLAP using MS SQL Server Analysis.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Scheduling daily, weekly, monthly Reports in crystal Enterprise to run at a particular time. Creating users, groups and giving them required permission.
• Scheduling of some Reports based on event server.
• Distributing Reports by e-mail, FTP or via web access.
• Designed Web based Crystal Reports user interface, Security System Interface, Parameterized Reporting.
• Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Created Grouping, sorting columns and writing expressions per the business requirements.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using PowerPivot/Unpivot in T-SQL.
• Involved in developing Data Access Components to access the SQL Server Database using ADO.NET.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2014/2012/2008
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Created Data Warehouse Cubes in SQL Server Analysis Service (SSAS).
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),SQL Server Management Studio 2014, MS Visual Studio.NET# 2012/2015, TFS, GIT, SVN, Rally and Windows 2008 Server.

Confidential, Dallas, TX

SQL Server BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS) and Crystal Report.
• Developed various types of reports like Drill Down, Drill through, Crystal Report.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Created Databases, Tables, Cluster/Non-Cluster Index, and Unique/Check Constraints, Views, Stored Procedures, Triggers and functions.
• Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Data flow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL
• Implemented Event Handlers and Error Handling in SSIS packages.
• Worked on Azure SQL data warehouse and database development
• Worked on creating basic dashboards in Crystal Reports connected to Azure SQL database for client reporting.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Conducted data import and export operations using the DTS wizard.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.
• Developed T-SQL Queries and Stored Procedures, Triggers, Views and Adding/Changing Tables for data load and transformation, and data extraction for processing business logic in the database.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Maintain referential integrity, domain integrity and column integrity by using the available options.
• Reviewed many T-SQL issues using management studio for better performance.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.

Environment: MS SQL Server 2014/2012R2, MS Visual Studio 2012, MS Azure, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Crystal Reports 2008, XML, T SQL, SQL Profiler, XML, Erwin r7, DTS and TFS, Windows.

Confidential, Bloomington, IL

SQL BI Developer

Responsibilities:

• Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.
• Performance tuning of the stored procedures, User defined functions and long running queries.
• Automated the ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa using SSIS.
• Analyzed and designed business processes as per the business requirements with SSRS reports.
• Created various dynamic reports using SSRS and Crystal reports.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS) and used the SSAS as source for generating parameterized reports in SSRS.
• Used ROLAP tools to access the data in a relational database and generate SQL queries to calculate information at the appropriate level when an end user requests it.
• Created reports and Data access from MDX and OLAP.
• Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
• Performed administration tasks of Database Mirroring, database backups and restore servers in SQL Server 2008.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008 Integration Services (SSIS).
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Migrating SQL Server 2008 databases into SQL Server 2012.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Identified the dimension, fact tables and designed the data warehouse using star schema and created complex reports using IREPORTS tool.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).

Environment: MS SQL Server 2012/2008 R2/2005, T-SQL, SSRS, SSAS, ETL, ODBC, Erwin, ASP.Net, Ado.Net, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential

SQL Server Developer/SSRS

Responsibilities :

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Writing complex queries and generating reports.
• Extracting queries from multiple databases like Teradata and AS 400
• Optimized the performance of various SQL scripts , stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created Sub - Reports, Drilldown -Reports, Summary Reports, and Parameterized Reports in SSRS .
• Generated ad-hoc reports using MS Reporting services and Crystal reports .
• Debug and analyse VBA code/ SQL stored procedures.
• Develop and modify stored procedures/ VBA code.
• Experience with MS Office software (Excel, Access, and Word).
• Worked on Teradata insert, Update, modify and Dynamic SQL to transform and load Summary tables built on Core Data Warehouse.
• Extensively worked on Performance Tuning of Teradata SQL using explains plan and understanding Joins and Data distribution.
• Extensively worked on Maestro to schedule jobs as daily batch.
• Involved in writing Automation Testing scripts using Shell and Perl to schedule these scripts in DEV
• Build, test, and execute one-off procedures as needed to support business commitments. Answer business user questions. Investigate and resolve issues or problems that arise. On call for production troubles.
• Used SSRS to create reports , customized Reports , on-demand reports, ad-hoc reports and involved in analysing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Functionality includes CGI Advantage Finance & HCM integrated with Info Advantage Reporting, Neogov Recruiting & Applicant Management, and KRONOS Time & Leave.
• Create custom reports for a variety of functional areas in Info Advantage web intelligence software

Environment: MS SQL Server 2008, MS Reporting Services 2008, Info Advantage Reporting, MS-Excel, MS Access, MS Visio, Teradata, AS400, Visual Studio 2008, VBA, PERL, BTEQ.