SUMMARY

• 8 years of experience in designing, developing, and delivering business intelligence solutions using PowerBI,SQLServer Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) and Data Transformation Services (DTS).
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Performance Tuning in SQL Server - Using SQL Profiler, DTA (Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk Loading Data(BCP), Indexed Views & Schema Binding, Clustered/Non-Clustered Indexes.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
• Experienced in creating complexSSISand DTS packages for ETL purposes. Implemented complicated Transformations to be used inSSISpackages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience working with Data Cleansing technique in ETL process.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Experience in generating reports for OLTP and OLAP databases.
• Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Created, Maintained & scheduled various reports in PowerBIlike Tabular Reports.
• Expertise in using PowerBIand prepared dashboard reports for internal team progress tracking.
• Experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQLServer 2005/2008/2012 Analysis Services (SSAS).
• Involved in Tabular Datawarehouse and DAX operations for SSAS 2012 and 2008 OLAP Database.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT.
• Expertise in UDM and Data Mining objects.
• Expert in Ralph Kimball Enterprise Data Warehouse Engineering Method, ETL process implementation, OLAP cube modeling and SSRS MDX and DAX Scripting.
• Well versed in Normalization/De-Normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence (SSIS, SSRS, SSAS, DTS)

Reporting Tools: SSRS, Excel, Power BI, Tableau

DataBase: MS SQL Server, Oracle 10g/9i/8i, MYSQL, MS-ACCESS

Data Modeling: Erwin

Programming: C, C#.Net, PL/SQL, TSQL, Java EE.

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, SSMS

Web Technologies: HTML, XML, CSS, JavaScript, jQuery.

Operating System: Windows 2000/NT 4.0, Windows 2003 Advanced Server/Windows 95/98/200/XP-pro, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. SQL Server BI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Expertise in using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Designed and developed variousSSISpackages (ETL) to extract and transform data and involved in SchedulingSSISPackages.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Employed SSIS Data Profiler Task to profile Target Source Systems and build ETL Solutions, which was helpful in designing the table structures and cleaning data for data consistency.
• Developed Linked, Drill Down, Drill Through, Parameterized and Sub Reports using SSRS.
• Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Experienced working on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Experienced in DevelopingPower BI Reports and Dashboards from multiple data sources using Data Blending.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Managed relationship between tables in Power BI using star schema.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
• Created Development and Production support documents.

Environment: SQLServer 2012,SSIS(2012/2008),SSRS(2012/2008),SSAS2012/2008, Visual Studio 2010/2013, MS Excel 2010, MS PowerBI, Cognos 8.2/3/4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection), Power Designer.

Confidential, Pittsburg, PA

SQL Server BI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SQL server Analysis Projects using MS SQL Server 2008.
• Created the Cubes and Dimensions.
• Created partitions and designed aggregations in Cubes.
• Defined relationships between Measure groups and Dimensions.
• Defined granularity with in a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• Created ETL package for data conversion using various transformations tasks.
• Created partitions (employed storage modes and usage based optimization), calculated members, KPI's and perspectives to enhance the cube's utilization. Also used MDX to query them.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created dash board to show the business performance.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports, Matrix Reports.
• Wrote hundreds of stored procedures and function on numerous SQL server to used in SSIS package and Power BI.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Environment: SQLServer 2012,SSIS(2012/2008),SSRS(2012/2008),SSAS2012/2008, Visual Studio 2010/2013, MS Excel 2010, MS PowerBI, Cognos 8.2/3/4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection), Power Designer.

Confidential, NewYork

SQL BI/Tableau Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Created SSRS report templates for ease of report development.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• ImplementingDashboardsandScore Cardsusing Microsoft Performance Point Server and integrated with share point.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Developed Star schema using SSAS cubes.
• Created parallel period, filter, ancestors and cross join MDX queries.
• Designed Dimensional Modeling using SSASpackages for End-User. Created Hierarchies in Dimensional Modeling.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Worked on generating various dashboards in Tableau Server using different data sources. Used Data Blending to merge data from different sources.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers and End Users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards were reflected with modified data.
• Created multiple dashboards with Drill Down capabilities using dashboard prompts, Local and Global Filters.
• Maintaining Tableau reports & analysis and work on enhancements to existing reports or creating new reports based on the business needs.

Environment: SQL Server 2012, SSIS (2012/2008), SSRS (2012/2008), Visual Studio 2010/2013, Tableau, MS Excel 2010, VB.Net, ASP.Net, C#, Python, Perl, TFS.

Confidential, Irving, Texas

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Migration ofDTSpackages toSSISpackages
• Tuned Stored Procedures and Queries for optimal Database performance.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with Star Schema.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
• Created roles using SSAS to restrict cube properties.
• Created bottom count, top count, cross join, non ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Database Performance of Index tuning with usingDatabase Engine Tuning Advisorto resolve Performance issues
• Developed and optimized database structures,stored procedures, Dynamic Management views, DDL triggersanduser-defined functions.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Create reports in PowerBIpreview portal utilizing theSSASTabular via Analysis connector.
• Developed web pages for embedding deployedSSRSreports using ASP.NET.

Environment: MSSQLServer 2008/2005,SSIS,SSRS, T-SQL, Crystal Reports 7/8, Windows 2008 Advance Server, VB.NET, MS Excel, and MS Office.

Confidential, Columbus, OH

MS SQL/BI Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures & Triggers
• Was involved in writing Triggers and Stored Procedures.
• Actively involved in Normalization & De-normalization of database.
• Was involved in performance tuning of the Database
• Used SQL Profiler and Data Base Engine Tuning Advisor to performance tune the Database.
• CreatedSSISpackages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• 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-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
• Managed Up gradation of DTS packages to SSIS packages.
• Upgraded Analysis Service 2005 to SSAS 2008.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2008.
• Worked with Exception handling with @@error and with Try/catch.
• Maintained Security Role and Database Users.

Environment: MS SQL Server 2008 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional, MS-Access, Oracle 9i.

Confidential

Jr. SQL BI Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2005, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Involved in usage of various SSIS components and features like For loop, For Each loop, Lookup Transformation, Variables, Error Handling and Package Configurations.
• Developed Query for generating drill down reports in SSRS 2005.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Implemented Exceptional Handling.
• Involved in performing database Backup and Recovery.

Environment: MS SQL Server 2008 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional, MS-Access, Oracle 9i.