SUMMARY:

• Hands on experience on T - SQL, PL SQL, SSIS, SSAS, SSRS, MDX, DAX, Power Pivot and Power View reports.
• Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse.
• Experience in Designing Business Intelligence Solutions with Microsoft SQL Server 2008 and 2012 using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Worked on SQL Server Analysis Services (SSAS) including in building cubes and writing MDX queries.
• Excellent skills in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase, excel sheets, Flat Files and MS Access.
• Experience in developing custom reports and creating various types of reports like On demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and Created analytical reports and visualizations with Microsoft Excel 2013 Power BI tools (Power View, Power pivot and Mapping) for exploratory analysis by data analysts.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Proficient in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Expert in planning, modeling, designing, developing, implementing, and maintaining Microsoft SQLServer and Microsoft Access databases.
• Have good Knowledge on writing MDX queries and the MDX datatypes.
• Hands on experience in installing, configuring, managing, upgrading and migrating Backup/Restore, monitoring and troubleshooting SQL Server 2008
• Experience in Designing and Building the Dimensions and cubes with star schema using SQLServer Analysis Services (SSAS).
• Experience in using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, DAX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP,Shell Scripting, Java, Oracle 12c, 11g, 10g

Databases: SSAS, SSIS, SSRS, BIDS, Informatica Power Center, OBIEE, Crystal Reports.

Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Operating Systems: Windows NT & Windows 9x, Windows Server 2008, MS-DOS, LINUX, UNIX

Microsoft Tools: MS Office Suite (Word, Excel, Power Point, Outlook), MS Share Point, MS Visio, MS AccesS

Data Modeling Tools: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

SQL Server/MSBI Developer

Responsibilities:

• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Created stored procedure and function to support efficient data storage and manipulation.
• Created VB.Net Script for Data Flow and Error Handling using Script component in MSBI (SSIS).
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server
• Created various MSBI (SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging and Development.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using MSBI (SSRS).
• Experienced in enhancing and deploying the SSIS Packages from development server to production server.
• Created source, stage and archive folders as per the requirements using expressions in file system task.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Proficient in creating different Package Configurations such as SQL Server, XML configuration and Parent mpackage variable.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQLServer
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from
• Client servers and through FTP.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Gained working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Optimized and Aggregated cubes with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Worked on deploying and scheduling Reports using SSRS and Tableau as well as triggers to generate all
• Daily, Weekly, Monthly and Quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: SQL Server 2008, SSIS, SSAS, SSRS, MS SQL Server 2012/2008/2005, Tableau 7.0/8.1 Server and Desktop, Eclipse, Windows Server/professional, Oracle 12c, C#, VISIO, ERWIN.

MSBI Developer

Responsibilities:

• Understood existing business model and customer requirements.
• Prepared business and technical understanding documents for the existing applications.
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Worked on migration to SSIS packages across instance; also tuning of SSIS packages and T-SQL queries.
• Implemented various SSIS Transformations like Slowly Changing Dimension- SCDs type 2, Data Conversion, Derived Column, Lookup, Fuzzy Group, Multicast, etc.
• Fields are updated on time basis like day, month, quarter, year using SSIS packages.
• Monitored performance and optimization of SSIS packages for maximum efficiency.
• Created cubes in SSAS using multi-dimensional model based on business requirements and also created additional measures.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using SSAS and produced ad-hoc, standard and super user reports using SSRS.
• Understood and modified the data according to the requirement using the Query Editor and Data view in Power BI desktop.
• Handled transformations on the data using Power Query in Power BI.
• Performed Analysis using Power Pivot in Excel and data taken from Power BI cloud.
• Created Role based Security levels to access data in Power BI and capable of using new features like Q & A.
• Experience with SQL Server Reporting Services (SSRS) and Power BI to author, manage and deliver paper based, Web-based reports and Interactive Dashboards.
• Migrated different kinds of records using Reporting Services Migration Tool by performing necessary steps to prevent loss of reports.
• Automated few of the daily routine tasks thereby reduced few man hours of effort.
• Involved in the preparation of the unit test case documents and unit testing of the enhanced macro codes, T-SQL queries.
• Prepared detailed document of the know issues for future reference.

Environment: Windows server 2012, SQL Server 2012, Microsoft BI Suite 2012, Microsoft Visio, Power BI.

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user-defined functions, triggers, and database Constraints to meet business requirements and policies.
• Created complex queries for database auditing purposes.
• Used DTS/SSIS for ETL processes, SSRS for reporting needs, and SSAS for analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various data transformations like conditional splitting, fuzzy lookup, multi-cast, column conversion, fuzzy grouping, script components, and error handling.
• Generated custom ETL scripts using SSIS 2005 and unit tested load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Gained understanding of OLAP processing for changing and maintaining warehousing optimizing dimensions and hierarchies and adding aggregations to cube.
• Involved in writing MDX queries and performance optimization of SSAS cubes for calculated members and measure groups.
• Created various complex reports and managed them using SSRS 2008/2005 according to ERLC.
• Involved in migration and conversion of reports from SSRS 2005 to 2008.
• Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, Adhoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
• Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, .NET 3.5, SQL BI Suite 2008 (SSAS, SSIS, SSRS), Enterprise Manager, PPS, XML, PowerPoint, Project, Access 2003, Windows Server 2003, Oracle, Crystal Reports, Cognos, Business Objects, SharePoint, MOSS 2007.

Confidential, DUBLIN, OH.

MSBI DEVELOPER

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.
• Installed and configured SQL Server 2008 successfully.
• Performance testing on stored procedures, Indexes.
• Maintained databases, performed software installations and monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Implemented automated backup and database maintenance / cleanup jobs. Generated Views for specific columns on a table to maintain privacy of a customer data.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Analyzed the existing data and performed the migration steps from SQL Server 2005 to SQL Server 2008.
• Used different tasks, transformations, containers and source/destination components to create SSIS packages.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.
• Extract data from access, excel, flat file, and different data base and load in SQL data base Using SSIS packages.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Verified different packages using Views using SQL Integration services 2008.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Involved in generating summary reports like Tabular, Matrix using SSRS.

Environment: Windows 2007 Server, IIS 6.0,Windows 2007, MS SQL Server 2005/2008, Office 2003, Visual Studio, Database Engine Tuning Advisor, SQL Server Management Studio, SQL Server Business