SUMMARY:

• Over 6 years of experience as MS SQL Server Developer involved in Analysis, Database Design & Development, Implementation, Debugging, and Testing of multiple versions on the database and Business Intelligence initiatives.
• Skilled in working with BI tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS), and Power BI.
• Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
• Experience with performing various SSIS data transformation tasks like Look - ups, Fuzzy Look -ups, Conditional Splits and Event Handlers, Error Handlers.
• Experienced in creating SSIS packages involving ETL process, extracting data from various sources (Flat files, Excel, Oracle, SAP, SQL) and loading for data warehousing.
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Strong experience in creating Ad Hoc Reports, parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SSRS.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.
• Performed Data Migration using tools like Data import/export, BULK INSERT and BCP between different Heterogeneous systems and SQL Server.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard for monitoring and tuning MS SQL Server performance.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SSRS and Power BI.
• Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps) and using the slicers available in Power BI for creating reports.
• Strong on tools such as Erwin Data Modeler, Visio, TFS and have full understanding of the Software Development Life Cycle.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 R2, MS Access, MySQL

Database Tools: SQL Server Enterprise Manager, SSIS, SSAS, SQL, T-SQL, DTS, IBM Data Stage, BIDS, SSMS.

Operating Systems: Windows, Linux, Unix

Reporting Tools: SSRS, Crystal Reports.

Version Control: Visual Source Safe (VSS), Team Foundation Server (TFS)

App Packages: MS Office, MS Outlook (Microsoft Office Suite)

Reporting Tools: SSRS, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

MSBI Developer

Responsibilities:

• Interacted with technical team and business users to perform analysis of business requirements & transformed them to technical requirements for ETL & reporting needs.
• Analyzed existing data and performed changes from SQL Server 2014 to 2016, following Normalization standards for data consistency and by performing data validation.
• Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data using SSIS.
• Engage in performance tuning of SQL queries and Stored Procedures and provide continuous improvements in BI services.
• Involved in Denormalization of existing tables for faster query retrieval.
• Created Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex Stored Procedures.
• Worked on different kinds of Transformations like Import Column, Export Column, SCD and Lookup in SSIS as per the client's Requirement.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts.
• Analyzed gaps, streamlined existing process, proposed and implemented new processes to build reporting platform moving away from citric reports using SSRS and Tableau.
• Created charts based on existing data to project AS IS TO BE capabilities of new proposals.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Briefly worked on various data loading strategies and performed various transformations for analyzing the datasets by using Horton works distribution for Hadoop ecosystem.
• Experienced in running query using Impala and used BI tools to run ad-hoc queries directly on Hadoop.
• Managed Databases on SQL Azure. Set up Connection Strings and connected SQL Server Azure Databases from locally installed SQL Server Management Studio.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Confidential, West Valley City, UT

MSBI Developer

Responsibilities:

• Involved in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Worked on ETL tasks to process data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Developed DTS packages from SQL Legendary tasks on SQL Server Management Studio to load the data from flat files and Source tables into SQL databases.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Enhanced and deployed SSIS Packages with new logics or enhancements and deployed them from Development server to UAT and Production server.
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Worked on performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations.
• Used For each loop container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Integrated new systems with existing data warehouse structure and refined system performance and functionality.
• Implemented Constraints & Triggers for data consistency and to preserve data integrity.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Generated periodic reports based on statistical analysis of the data from various time frame and division using PowerPivot, Power Query, Power View, and Power BI.
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
• Rendered reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly statements.

Confidential, Cincinnati, OH

SQL Server Developer

Responsibilities:

• Performed requirements gathering, logical & physical design of data augmentation processes, & coordinated implementation of requested enhancements for applications.
• Developed data warehouse and reporting solutions using the Microsoft Business Intelligence based tools, services and support (SSIS, SSAS and SSRS). used Control Flow Elements like For Each Loop, Sequence Container, Execute SQL Task, execute package Task, Script Task, File System Task, Send mail Task, process Task.
• Employed the Slowly Changing Dimension Transformation to establish Historical Data in the Data Warehouse.
• Created Stored Procedures which generated the necessary fact and Dimension Tables and functions that allowed performing necessary calculations depending upon the requirement.
• Created various Database Objects such as Tables, Indexes and Views for the generation of Star Schema.
• Defined Roles and Security Levels for different Information Users.
• Designed and developed SSIS packages in automating the process of processing the cubes as well as executing other tasks like running the Stored Procedures.
• Involved in the SSAS cube design, to create partitions, processing the cube using SSIS package and displaying the data using Excel source.
• Defined Report Layout including Report parameters and wrote queries in Creating Parameterized Reports, Drill Down, Reports and Drill through Report Using SSRS.
• Scheduled for Execution and generated daily, weekly and monthly reports for managers. Report history was also tracked using SSRS.
• Responsible for Performance Tuning of SQL commands & troubleshooting of technical problems in SQL Server using SQL Profiler and the Database Engine Tuning Advisor.
• Responsible for data management and conversion activities such as data assessment, cleansing, extracting, migrating and reconciliation of data using SSIS.
• Worked for Functional and Technical design to speed up the process and query optimization.

Confidential, Walnut Creek, CA

SSIS/SSAS/SSRS Developer

Responsibilities:

• Enhanced the old logical and physical database design to fit new business requirement and implemented new design into SQL Server 2012.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.
• Involved in Extract, Transform and Load (ETL) process framework.
• Convert all existing DTS package of MS SQL 2008 to 2012 by adding extra SSIS task.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Responsible for creating database objects like table, views, store procedure, triggers) to provide structure to store data and to maintain database efficiently.
• Developed SSIS packages using different types of Error Handling for various events.
• Experience with ER and Dimensional modeling.
• Involved in Performance tuning and Query Optimization.
• Created multiple views and queries for complex SSRS reports.
• Created Clustered index and Non-clustered for increasing performance.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.
• Involved in user interface design and developed scripts to support client business needs.
• Wrote standard & complex SQL Queries to perform data validation & graph validation to make sure test results matched the expected results based on business requirements.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Worked with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.