SUMMARY

• Having 8+ years of experience as Business Intelligence Consultant with strong understanding in Data Warehousing, Data modeling of modern Client - Server based systems.
• Extensive experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Expertise in Confidential Business Intelligence Tools (SSIS, SSAS (Tabular Model), SSRS (Power View), ProClarity, SQLServer 2005/2008/2012 , Confidential Office SharePoint Server, Excel reporting and Power Pivots.
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Experience in using the Dimensional Modeling techniques such as Star Schema and Snowflake Schema.
• Experience in developing SSAS Cubes, Dimensions and data source views and Deploying and Processing SSAS objects.
• Expertise in Business Intelligence Reporting tools like SSRS, Business Objects and SAS.
• Developed Cubes using different types of storage modes like Multidimensional OLAP (MOLAP).
• Extensive experience in data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.
• Troubleshooting on datasets for Power BI Sites and creating snapshots of Power BI Reports.
• Worked on Power BI gateway to Schedule daily jobs to refresh the data.
• Experience in creating Power BI reports with Slicers and interactions for analysis and creating bookmarks for dashboards at Power BI Service.
• Experience in migrating SSRS reports to Power BI Dashboards (PPG Scorecard Dashboard).
• Experience in exploring data in variety of ways and across multiple visualizations using Power BI.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Strong Experience in User acceptance test, product support, version control and change management.
• Expertise in OLTP/OLAP/OOAD System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data warehousing concepts and Dimensional modeling Star schema and Snowflake schema.
• Expertise in Requirement Gathering, Peer reviews, Inter group coordination and Training Programs.
• Expertise in Production migration of New releases and Enhancements
• Extensive experience in resolving issues at all levels of project life cycle
• Experience in coordinating the work with offshore team
• Experience in handling Production support (24 X 7) for Business Intelligence applications.

TECHNICAL SKILLS

Languages: Visual Basic, Toad, SQL, PL/SQL, MDX, XML

Databases: Oracle8, SQLServer 2005/2008/2008 R 2/2012/2016.

MSBI/Power BI Tools: SSIS (SQL Server Integration Services), SSAS (Analysis Services) & Tabular Model, SSRS (Reporting Services) & Power View, Power Query, SharePoint 2010, Excel Power Pivot, Power BI Desktop.

BI Tools: Informatica, SAS Data Integration Studio, SAS OLAP Cube Studio, SAS Web Report Studio, AS Information Map Studio, Enterprise Guide, SAS Web OLAP Viewer for Java, Management Reporter

Others: Team Foundation Server (TFS).

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

IT Analyst (Power BI Developer)

Responsibilities:

• Understanding BRD documents.
• Developed SSIS packages & Modified existing packages based on change requests and prepared Technical Documents for SSIS packages.
• Optimized SSIS packages by tuning SQL scripts in sources, using non-blocking transformations and managing data flow buffer sizes.
• Created complex T-SQL statements using SQL joins, sub queries and common table expressions (CTE’s) including recursive CTE’s.
• Created data driven subscriptions to generate and send reports to users based on email list at scheduled time every day.
• Deployment done for one server to another using deployment utility.
• Used various data flow transformations like Union, Union All, Cache transform while developing the SSIS Packages.
• Developed SSIS packages with monitoring features, logging and execution results to load into designed error tables.
• Used several features in SSRS like Expressions, formatting, grouping, dynamic sorting, charts etc. to organize data and easy understanding to users.
• Used Report builder to make hot fixes/ cosmetic changes to reports deployed in Report manager.
• Created new shared data source connection strings in Report server for everyone in the team used to develop the reports.
• Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source Views.
• Generating periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS);
• Experience on Confidential Power BI Desktop by extracting data from different sources such as Oracle, SQL Server by writing queries according to business needs in query editor.
• Experience in creating Power BI reports with Slicers and interactions for analysis and creating bookmarks for dashboards at Confidential Power BI Service.
• Exhibit complete understanding of the module's functional and technical requirements
• Generated periodic reports based on the statistical analysis of the data using Confidential Power BI Visualizations.
• Understanding and modification of existing Infrastructure Planning and facilities SSRS reports.
• Utilized Power query in Power BI to pivot and Un-pivot the data model for data cleansing and data massaging.
• Created Power BI Reports with proper model making ETL changes at Power query with Parameter/ Merge queries/ combined files with custom and conditional formatting concepts.
• Proficient in creating Power BI Dashboard from scratch and handling workspaces, apps in Power BI Service.
• Implemented DAX functions and expressions for efficient data visualizations in Power BI.

Environment: Oracle 12C, SQL Server 2016, SSIS, SSAS, SSRS, Power BI, Power Query, Power View, Excel.

Confidential, CA

Sr. Business Intelligence Analyst

Responsibilities:

• Creating and managing SSIS packages. Creating Dimension Tables and Fact Tables as per the requirement.
• Exhibit complete understanding of the module's functional and technical requirements
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created SSIS packages with Logging and Event Handling with Text File/SQL Server Log Providers under predefined events such as OnError, OnPreExecute, OnTaskFailed and OnPostExecute.
• Detailed experiences in working with parameterized reports, drill down, drill through, sub report and dashboard reports using SSRS.
• Automated Cal medi connect reports like CA 1.11, CA 4.1, CA 4.3 and Part-C Organizational and Reconsideration (ODR) submission reports for CMS Audits.
• Created valuable reports to organization like PPG Score card, Error log and Universe Submission completeness reports in SSRS.
• Worked on Power BI Desktop by extracting data from different sources such as Oracle (ODW), SQL Server by writing queries according to business needs in query editor.
• Utilized Power query in Power BI to pivot and Un-pivot the data model for data cleansing and data massaging.
• Created Power BI Reports with proper model making ETL changes at Power query with Parameter/ Merge queries/ combined files with custom and conditional formatting concepts.
• Proficient in creating Power BI Dashboard from scratch and handling workspaces, apps in Power BI Service.
• Implemented DAX functions and expressions for efficient data visualizations in Power BI.
• Deployed and scheduled the reports in the Power BI Service.
• Utilizing/Demonstrating proficiency in usage of tools in a project environment Scheduler, Timesheets, Configuration Management, Defect tracking tools/Testing and Development /tools
• Involved in environment migration from SQL 2008 to 2016.
• Creating Excel reports & Performing Data validation activity.
• Involved in fixing the bugs and Writing the Power Shell Scripts.

Environment: SQLServer 2016, 2008, 2008R2, SSIS, SSAS, SSRS, Confidential Power BI Desktop, T-SQL, MS Excel, Excel Power Pivot, Power Query, Power shell 4.0

Confidential, Chandler, AZ

Database Analyst

Responsibilities:

• Understand the current end reports and modification on existing reports.
• Exhibit complete understanding of the module's functional and technical requirements
• Worked on developing Tables, Indexes, Views, creating complex stored procedures, Triggers, Functions in SQL Server 2012/2008R2 using T-SQL.
• Created new SSIS packages to extract, transform and load data from one database to another and from OLTP to OLAP using various tasks like execute SQL task, data flow task, FTP task, Send mail task and file system task.
• Managed index statistic, Tables, Views and optimized queries by using execution plan for tuning database; Used SQL Profiler to collect the workload and updated clustered and non-clustered indexes.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in SQL Server 2012.
• Developed SSIS packages using transformations such as Conditional Split, Derived Column, Multicast to cleanse, Sort, filter source data and load the data into target tables.
• Created database objects like views, stored procedures, Triggers, Indexes, DML and DDL Changes.
• Extensive experience in delivering OLAP solutions by developing corporate dashboards like Agent Performance Dashboard (APD).
• Worked on control flow and data flow tasks like for loop, for each loop and sequence containers, Precedence constraints in SSIS.
• Creation of Jobs using SQL Server Agent and its Scheduling.
• Used TFS (Team Foundation Server) source control tool to check in all the codes in daily basis.
• Created different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Involved in fixing the bugs and handled the CR (Change Requests) & Interacted with client for the requirement for different CR’s.
• Provided Customer support

Environment: T-SQL, SQLServer2012, 2008, 2008R2, SSIS, SSAS/SSAS Tabular, SSRS, Excel, Excel Power Pivot

Confidential, Bellevue, WA

BI/SQL Developer

Responsibilities:

• Conduct Requirement and Impact Analysis
• Participate in / Conduct design reviews
• Develop project artifacts (e.g. standards & guidelines, program specifications, test strategy, test plans) as per the defined schedule and estimates
• Implemented error handling through Try-catch statements.
• Participate in defect triage and plan for defect fixes
• Creating and managing SSIS packages using Aggregate, Merge, data conversion, Pivot, UN Pivot and lookup transformations. Creating Dimension Tables and Fact Tables as per the requirement.
• Worked on configuring Check points, package logging, error logging and event handling to redirect error rows and fix error rows in SSIS.
• Used SSIS to implement the Change data capture (CDC), slowly changing Dimensions (SCD) to maintain historical data in Enterprise Data Warehouse.
• Experience in extracting, transforming and loading data using DTS/SSIS, Import Export wizard and Bulk insert.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Transformation of data from one server to other servers using tools like Bulk Copy program (BCP), data conversions from legacy systems to SQL Server in both development and production environments.
• Creation of custom staging tables to handle import data.
• Worked with ADO.Net for data retrieval using ODP.Net provider and native SQL Server data provider for MS SQL server 2008R2 and 2012.
• Worked on .Net application to build batch jobs using Power shell Scripting and scheduled in SQL Server Agent jobs.
• MDX queries to retrieve data from cubes using SSIS.
• Performed database transfers and queries tune-up, integrity verification, analysis and interpretation.
• Detailed experiences in working with parameterized reports involving cascading parameters in drill down, drill through, sub report and dashboard reports using SSRS.
• Handled the CR (Change Requests) & Interacted with client for the requirement for different CR’s.

Environment: SQLServer2012, 2008, 2008R2, SSIS, SSAS, SSRS, Excel, Excel Power Pivot, Power Shell

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Understanding BRD documents.
• Developed SSIS packages & Modified existing packages based on change requests and prepared Technical Documents for SSIS packages.
• Optimized SSIS packages by tuning SQL scripts in sources, using non-blocking transformations and managing data flow buffer sizes.
• Created complex T-SQL statements using SQL joins, sub queries and common table expressions (CTE’s) including recursive CTE’s.
• Created data driven subscriptions to generate and send reports to users based on email list at scheduled time every day.
• Deployment done for one server to another using deployment utility.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Used various data flow transformations like Union, Union All, Cache transform while developing the SSIS Packages.
• Developed SSIS packages with monitoring features, logging and execution results to load into designed error tables.
• Used several features in SSRS like Expressions, formatting, grouping, dynamic sorting, charts etc. to organize data and easy understanding to users.
• Used Report builder to make hot fixes/ cosmetic changes to reports deployed in Report manager.
• Created new shared data source connection strings in Report server for everyone in the team used to develop the reports.
• Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source Views.
• Developed dashboard using Performance Point server Dashboard Designer.
• Developed dashboard using ProClarity Dashboard Manager.

Environment: SQLServer2005, 2008, 2008R2, SSIS, SSAS, SSRS, PPS/OSD Plan