SUMMARY

• Hands on experience with SQL Server and T - SQL, Designing and Normalization techniques on the database tables.
• Worked extensively on the Business Intelligence Development Studio (BIDS), that includes experience in design, development and implementation of complex data delivery systems using MS SQL Server and various data visualization tools.
• Experience in constructing Stored Procedures, Replication, Index, Functions, Triggers, Cursors, Tables, Views, Relational database Models, and Data integrity.
• Experience in Migration of databases and database applications from MS SQL Server 2008 to MS SQL Server 2012.
• Experience in Extracting, Transforming and Loading (ETL) data.
• Experience in Designing, developing and deploying SQL Server Integration Services (SSIS) packages.
• Familiar with implementation of SSIS (SQL Server Integration Services), Notification Services, Database Mirroring concepts.
• Developed Dashboard Reports using Performance Point Server on SharePoint, SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2012.
• Experience in writing Parameterized Queries for generating stylish Tabular reports, Drill down, Drill through, Cascading, Parameterized, Click through, Matrix, Chart, Snap shot reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Experienced in developing Ad-hoc reports using Data Flow Diagrams, Dimensional Data Models, Business Objects, Process Models, and ER diagrams, SDLC concepts.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Experienced in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in working with SSAS in creating data source views, named queries, dimensions and deploying of analysis services projects.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS.
• Experience in developing SSAS projects using MDX in MSSQL Server 2008.
• Extensive experience in writing MDX Scripting and MDX Queries
• Expertise noledge inMDXand Advance MDX, and DAX Language.
• Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages.
• Creating packages using SSIS, Import, Export Data, Bulk Insert and BCP Utilities.
• Experience in OLAP (Online Analytical Processing) programming like Measures, Cubes, Dimensions and MDX for Star Schema, Snowflake Schema.
• Excellent work ethics, self- motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2012/2008R2/2008/2005/2000/7.0), MS Access, MS Excel, Crystal Reports

Database: MS SQL Server 2012/2008/2005/2000, MS Access, Oracle 11g/10g/9i

Languages: T-SQL, PL-SQL, C, Objective C#

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems: Windows (95/98/2000/2003), Windows 2007 Server, Windows XP, Windows Vista, 8.1, 10, Mac 10.X

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Project), OLAP & OLTP, ERWIN

PROFESSIONAL EXPERIENCE

Confidential. Pleasanton, CA

MSBI, Developer

Responsibilities:

• Worked with Business Team to collect data for the conceptual design of the system and Interacted with Development Teams and Managers to Analyze Business needs and developed technical specifications.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement and using the TOP operator to limit the Select Statement in certain Queries.
• Created various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Created in Extracting and Transforming data (ETL) from Azure Database and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP Utilities.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions Tables.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Worked with SSIS packages which involved tasks like Execute SQL, FTP tasks, Dataflow, File System, Script and various Data Flow transformations like Lookup, Merge, Pivot, Row Count, and Sort.
• Debugging and troubleshooting the technical issues while implementing the applications.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Lead the whole development process of the reports and guide team members as and when needed.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Generated different types of Reports Tabular, Matrix using MS SQL Server Reporting Service (SSRS).
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Expertise in documenting the ETL process,Source to Target Mapping specifications, status reports and meeting minutes.
• Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and OLAP design (SSAS) for different cloud services and service items. Implemented OLAP cube and connecting using Excel Power Pivot.
• Used SSAS to create multi-dimensional cubes with the help of Cube Build Wizard for numerous dimensions.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created SSAS Tabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, Hierarchies, Measures groups and KPI’S to Analyze performance of Strategic Business Units as well as corporate centers.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Utilized Script Task and Script Component to create custom solution using Microsoft Visual Basic (VB) or Microsoft Visual C#.
• Conduct and lead noledge sharing sessions with technical team and business users to improve the overall process.

Environment: MS SQL Server 2012/2008, SQL Server Analysis Server (SSAS) 2012/2008, SQL Server Reporting Service (SSRS) 2012/2008, SQL Server Integration Service (SSIS) 2012/2008, T-SQL, PL/SQL, Excel, XML, C#.

Confidential, Alpharetta, GA

MS SQL Server (SSIS/SSRS/SSAS) Developer

Roles and Responsibilities:

• Created various database tables and procedures to update and clean the old data.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts. Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Responsible for creating dashboard and tabular reports using SSRS.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.
• Created Tabular Models using DAX queries in analysis services and deployed it.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Environment: MS SQL Server-2012/2008 R2/2005, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

Confidential, Plano, TX

MS SQL Server Developer

Roles and Responsibilities:

• Created Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency. Participated in maintaining and modifying tables and constraints for claims Database using SQL server.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Responsible for total ETL process.
• Performed ETL mappings using MS SQL Server IntegrationServices.
• Used DTS, SSIS and T-SQL store procedures to transfer data from OLTP databases to staging area and finally transfer data marts and performed action in XML.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files, Access, DB2 and Oracle.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse with different transformations in order to get the accurate data using SSIS 2008/2005 and deployed the SSIS packages to different environments by maintaining the configuration settings in the XML files and variables.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created Physical and Logical data modeling using ERWIN.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Extensively worked with the SQL Profiler, Database Tuning Wizard and query execution plans to identify the slow running queries and to test different application for performance.

Environment: SQL Server 2005/2008, SSIS 2005/2008, SSRS 2005/2008, T-SQL, SQL Profiler, Erwin, Oracle 10g, MS Share Point, Access and Excel.

Confidential

SQL Server Database Developer

Responsibilities:

• Created all administration tasks of SQL Server and designed database, tables and views.
• Used system stored procedures and DBCC commands.
• Experience in query optimization and performance tuning. Used Execution plan, Performance Monitor.
• Wrote complex SQL queries and procedures for retrieval of data.
• Upgraded old DTS packages to SSIS 2008 packages.
• Dropped and recreated the indexes on tables for performances improvements.
• Used multiple transformers in DTS to meet the business requirements by collecting data from various sources.
• Involved in managing Jobs and error logs.
• Constructed different user level groups, and assigned appropriate permission level to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the Organizational Hierarchy.

Environment: MS SQL SERVER 2000/2005/2008, Microsoft Business Intelligence Development Studio (BIDS), DTS, OLAP, OLTP.