SUMMARY:

• Highly Motivated Business Intelligence Professional with 3+ Years of Experience in Microsoft Business Intelligence (MSBI), Report Development & Analysis along with Database Development. Leadership Abilities and team work skills ability to accomplish Tasks as individual Contributor.
• Experience in scratch business intelligence and database development Experienced in SQL Server Business intelligence tools like SQL Server Integration services, SSIS 2008 r2, SSIS 2012, SSIS 2014, SSRS, SQL Server Reporting Services 2012, MS SQL Server 2012,2014/2016 to deliver Business Intelligence and data warehouse solution.
• Experience on Enterprise Data Warehouse, SSIS, ETL, SQL, Dimensional Modeling, Database Design, Normalization, T - SQL, PL/SQL, Data Warehouse design, Data Modeling.
• Production support responsibilities include maximizing system availability, optimizing database and availability through ongoing maintenance, and ensure conformance to audit and operating standards
• Good familiarity with Developing tables, views, stored procedures, database functions as well as implementing indexes, Keys, SQL query Optimization.
• Experience in Data Modeling, Database design and well versed with SQL Server best practices and performance tuning.
• Extensively working “hands-on” with SSIS 2012 or above, in DW ETL Development
• Ability to work database architecture, design, integration, and/or data modeling. (Star flake/snow flake).
• Good applied statistics skills, such as distributions, statistical testing, regression, etc.
• Solid understanding of data structures, algorithms, object oriented design and patterns
• Extensive level database designing & re-engineering.
• Designing dashboards, reports, data cubes and provide technical training to the end user.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycles
• Experience in creating different types of reports Cascading reports, Drill down reports, Drill through reports, linked
• Possess strong communication skills and consistently received outstanding feedback from client and senior management for quality deliverables.
• Ability to work independently and collaboratively in multi-task in a fast-paced environment.

TECHNICAL SKILLS:

Programming Languages: C, SQL, PL/SQL

Business Intelligence tools: MSBI, Business Intelligence Development Studio SSIS/SSRS

MSBI Stack: SSAS, SSIS, SSRS

Data Base: SQL Server 2000/2005/2008/2008 R2/2012,2014,2016 MS Access, MS Access, Oracle

Operating Systems: Windows, Linux

SDLC Methodologies: Agile, waterfall

Project Repositories: SVN, CVS, GitHub

Reporting Tools: SSRS, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Orange, CA

MSBI Consultant

Responsibilities:

• Involved in reviewing the application and interacting with business users to understand the user requirements.
• Actively involved in migration of SQL Server 2012 to 2014.
• Installed and configured SQL server with SSDT and SSMS components and assisted developers.
• Created and Scheduled SQL agent Jobs with SSIS for data archival and data purge with SSIS Packages and Stored Procedures.
• Created data bases and data base objects (tables, views, stored procedures, functions, user defined types as and when demanded to meet internal/ external requirements)
• Extracted data from various OLTP data sources, such as MS Access, MS Excel, Flat files, CSV files into SQL Server 2014 databases.
• Worked on SSAS storages and partitions with aggregations for optimization of cube deployment
• Created MDX queries with aggregations and calculations for reporting and data mining models.
• Extensively worked with Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Bulk Insert, BCP and open row set.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.
• Optimized the performance of data bases by recreating indexes, views and modify the queries.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2014 and SQL code.
• Created data base backups and restored in several environments.
• Created data maintenance plan for backup and restore and update statistics and rebuild indexes.
• Granted access to the data base users by creating logins with appropriate role permission.
• Worked with Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Created TFD (technical functional documents) for accomplished projects and uploaded to share point team site.

Environment: SQL Server 2014/2012, T-SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, Agile, Visual Studio 2005/2008, XML, MS Visio, share point.

Confidential, Oakland, CA

MSBI Developer

Responsibilities:

• Configured and installed SQL Server 2012 on Windows Server and migrated databases from different databases to MS SQL Server 2012.
• Understand the functional requirement specifications and preparing design documentation.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Deployed packages to SQL Server and file system in 2008 and also used the new Project based Deployment introduced in 2012 SQL Server Data Tools (SSDT) to deploy the 2012 packages.
• Configured and deployed the SSIS 2012 projects to the new Integration Services Catalog. Set the Environment and managed configurations using the Package and Project variables.
• Maintained the SSIS projects and users accessing the Catalog and SSISDB.
• Scheduled and monitored the SQL Agent jobs to run these packages periodically.
• Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, Mainframe DB2, Oracle etc.
• Created cascade parameterized, adhoc, drillthrough, drilldown, Graph, Chart, KPIs, linked, snapshot, subreports, canned reports etc. using SSRS.
• Integrated SSRS and Crystal Reports with .net application automatically passing the report parameters from the application and defaulting to the desired output to a certain format if required.
• Created SQL Server Analysis Services (SSAS) cubes and migrated some of the existing cubes. Also created SSRS reports out of these cubes writing MDX queries to pull the data.
• Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.
• Implemented SQL Server SSIS packages for ETL methodologies involved in the migration from SQL Server.
• Used SQL Server Reporting Services (SSRS) to create reports, customized Reports, on-demand reports, Charts, KPIs, Drilldown Drillthrough and other canned reports and multi-dimensional reports from the cubes.
• Supported Style Sheets that contain drill down parameters and links to arbitrary URLs and embedded GIF images in report headings and footings.
• Involved in building and maintaining dimensional cubes with SQL Server Analysis Services ( SSAS) and used MDX script for querying the data.
• Deployed SSRS reports to Report Manager and made a call to those reports through a URL from .Net API (.aspx).
• Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from application.
• Performing Unit testing and internal QA for the developed application.
• Working closely with the users supporting the existing reports and creating new reports.

Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, SSAS, MS Access, SQL *Plus, ASP.NET, C#.NET, ADO.NET, Windows XP, .NET Framework, Visual Studio 2010, HTML, JavaScript, AJAX, LINQ.