SUMMARY

• A total of 8 plus years of professional IT experience out of which:
• Over 6plus years of experience as MSBI Developer in Analysis, Design, Development and Testing of Data warehousing and Business Intelligence Applications.
• Close to 2 Years of experience in ITIS domain and was responsible for installing, troubleshooting and maintenance of Windows servers and UNIX servers.
• Experience and proficiency in Microsoft Business Intelligence Tools such as Power BI (Power Pivot, Power Query, Power View), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Excel Cube Analysis Services and ETL tools like SQL Server Integration Services (SSIS)
• Experience in creating dimensions, calculated measures and members, KPI’s, partitions, aggregations, OLAP cubes in SSAS, Full and incremental processing of cubes and dimensions, creating XMLA scripts, writing MDX queries and expressions in SSRS, SSAS and querying DMV’s for cube documentation.
• Experience in creating SSAS Tabular cubes, Power Pivot models and DAX measures using DAX queries and hosting Excel dashboards and Power View dashboards using Excel services on SharePoint 2010/2013.
• Experience in creating mini ETL transformations using Power Query, loading of data from various data sources, for eg: Sales force cloud and load into Excel Power Pivot model and build dashboards out of it.
• Experience in developing complex SSRS reports using dynamic SQL expressions and dynamic MDX expressions through BIDS and integrating with ASP.NET application and Report Server.
• Experience in design, development, maintenance and enhancement of SSIS packages and scheduling and configuration of SQL Agent jobs for daily ETL production loads.
• Have knowledge of CDC (Change Data Capture) transformations in SSIS and worked on data replication
• Strong Database Knowledge in SQL Server and Netezza and has experience in creating views, complex SQL queries and stored procedures.
• Have sound knowledge of Data Warehousing Concepts and well versed with Star/Snowflake Dimension Models and the SCDs (Slowly Changing Dimensions)
• Have knowledge on drill through from a Power Pivot dashboard to a SSRS detail report.
• Have sound knowledge of Healthcare and Life Sciences and Media business domains.
• Experience in Unit testing, Data testing and Functionality testing of BI solutions.
• Provided hands - on training on Power BI (Power Pivot, Power Query and Power View) to the various teams.
• Supported ETL Solution build through Informatica and handled CR’s for a period of 3 months.
• Have knowledge on various Global Distribution Systems (GDS) such as Sabre, Amadeus and Galileo
• Configuring and troubleshooting of Windows servers and Linux servers, Active Directory and Outlook issues and have knowledge of monitoring tools like Proactive Net and Zenoss.
• Sincere, Enthusiastic, Hardworking with good analytical, communication and interpersonal skills and appetite to learn new skills.

TECHNICAL SKILLS

ETL Tools: SSIS (SQL Server Integration Services) 2008 R2/2012,Power Query Informatica Power center 8.6.1.

Analysis Tools (OLAP): SSAS Multidimensional (Server Analysis Services) 2008 R2/2012 SSAS Tabular models and Excel Power Pivot models.

Reporting Tools: SSRS (SQL Server Reporting Services) 2008 R2/2012 Performance Point Services 2010 Power BI desktop, Power View and Excel Pivot..

Queries: SQL, PL/SQL, MDX, DAX..

Versioning Tools: TFS (Microsoft Team Foundation Server)

Other Tools: Microsoft Visual Studio 2008/2010/2013, SharePoint 2010/2013 Excel Services

Databases: SQL Server2008 R2/2012, Netezza and Oracle..

Operating Systems: Windows, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, California

Senior BI Developer

Environment: Salesforce, PowerQuery, Excel PowerPivot 2013and SharePoint 2013

Responsibilities:

• Gather the requirements with the help of business analysts and understanding of the same.
• Understand the Salesforce data and objects in the cloud.
• Designed and developed the PowerQuery queries to do transformations on data and load into PowerPivot model.
• Designed and developed Excel PowerPivot model using DAX queries
• Created Excel PowerPivot dashboards and PowerView dashboards and hosted on SharePoint 2013 in Excel services mode

Confidential, Long Beach, California

Senior BI Developer

Environment: SQL Server 2012, SSIS 2012, SSAS Tabular 2012, Excel PowerPivot 2013

Responsibilities:

• Gather the requirements with the help of business analysts and understanding of the same.
• Designed the Relational Database and developed the Database objects.
• Designed and developed the SSIS package to load the data from OLTP to DW staging environment
• Designed and developed SSAS Tabular model using DAX queries
• Created Excel PowerPivot dashboards and PowerView dashboards and hosted on SharePoint 2013 in Excel services mode
• Created and Published PowerBI desktop dashboards for the internal user reference.

Confidential, Long Beach, California

Senior BI Developer

Environment: SQL Server 2012, SSIS 2008 R2, SSAS 2012, Excel PowerPivot 2013 and PPS 2010

Responsibilities:

• Gather the requirements with the help of analysts and understanding of the same.
• Designed the Relational Database and developed the Database objects.
• Designed and developed the SSIS package to load the files to the staging environment
• Designed and developed SSAS Tabular model using DAX queries.
• Created Performance Point Services dashboards and deployed to SharePoint 2013 portal.
• Created Excel PowerPivot dashboards and PowerView dashboards and hosted on SharePoint 2013 in Excel services mode

Confidential, Fenton, Missouri

Senior BI Developer

Environment: SQL Server 2014, SSIS 2013, PowerPivot 2013 and TFS

Responsibilities:

• Gather the requirements with the help of analysts and understanding of the same.
• Design the replication load using SSIS on top of the physical model.
• Developed SSIS Packages, Tables, Stored Procedures, Views and SQL Agent jobs for the replication load.
• Responsible for Unit testing and SIT data load.
• Monitoring and assigning the work for offshore team members.

Confidential, Fenton, Missouri

BI Developer

Environment: SQL Server 2008 R2, SSRS 2008, SSAS 2008 R2, PowerPivot 2013 and TFS

Responsibilities:

• Gather the SBRs generated by Confidential Analysts for all clients and generate a generic metric solution for the same. Build requirements with the help of analysts based on these SBRs.
• Design a generic PowerPivot model solution on top of the physical model that caters to the metric solution defined earlier.
• Developed Data Source Views, Dimensions and Metrics in PowerPivot model to cater to business user’s analysis.
• Scheduled refresh of PowerPivot models.
• Created calculated measures in PowerPivot model using DAX
• Developed Pivot table reports in Excel Reporting Services.
• Monitoring daily Production load through SQL Agent jobs, support and maintenance of SSIS packages.
• Stage and production deployments for the new Change requests and Quality Center Defects.

Confidential, Fenton, Missouri

BI Developer

Environment: SQL Server 2008 R2, SSRS 2008, SSAS 2008 R2, Excel services 2007 and TFS

Responsibilities:

• Gather the SBRs generated by Confidential Analysts for all clients and generate a generic metric solution for the same.Build requirements with the help of analysts based on these SBRs.
• Design a generic cube solution on top of the physical model that caters to the metric solution defined earlier.
• Developed Data Source Views, Dimensions, Measures in SSAS to cater to business user’s analysis.
• Developed appropriate partitions and storage modes for cubes. Scheduled refresh of SSAS cubes.
• Created calculated members in cubes using MDX and dimension hierarchies.
• Created cube perspectives to certain functional areas for easier end user analysis.
• Developed Pivot table reports in Excel Reporting Services.
• Monitoring daily Production load through SQL Agent jobs, support and maintenance of SSIS packages.
• Stage and production deployments for the new Change requests and Quality Center Defects.

Confidential, Fenton, Missouri

BI Developer

Environment: SQL Server 2008 R2, SSRS 2008, SSAS 2008 R2, Excel services 2007 and TFS

Responsibilities:

• Co-ordinated with client and Business Analyst for Requirements gathering of reports.
• Creatingvarious reporting solutions such as tabular reports, cross tab/matrix reports, drill down reports, reports with hyperlink actions using SQL Server Reporting Services.
• Querying from OLAP cubes(MDX queries) using SQL Server Analysis services for reporting use.
• Created various dashboard reports that use charts, gauges to for visualization of business KPIs.
• Developed reports in BIDS using version control tool Team Foundation server.
• Performed Unit Testing and Data and Functionality Testing as part of System Testing of all the reports before release.

Confidential, Indianapolis, Indiana

Junior BI Developer

Environment: Netezza, SSRS 2008 R2 and TFS

Responsibilities:

• Created various reporting solutions such as tabular reports, cross tab/matrix reports, drill down reports, reports with hyperlink actions using SQL Server Reporting Services.
• Designed user interactive reports that implements interactive sorting using SSRS.
• Created various dashboard reports that use charts, gauges to for visualization of business KPIs.
• Developed reports in BIDS using version control toolTeam Foundation server.
• Followed SDLC process.
• Performed Unit Testing and Data and Functionality Testing as part of System Testing of all the reports before release.

Confidential, Indianapolis, Indiana

Junior BI Developer

Environment: Windows XP, Informatica Power Center 8.6.1,Netezza

Responsibilities:

• Data Load monitoring
• Development and modifications of mappings according to the client requirements.
• Incident Management and Change management using Remedy.

Confidential

Junior BI Developer

Environment: SQL Server 2008, SSRS 2008, Visual Studio 2008 and Team Foundation Server (TFS).

Responsibilities:

• Designed new SSRS reports to meet changing business needs.
• Designed user interactive reports that implements interactive sorting using SSRS.
• Developed reports in BIDS using version control tool Team Foundation server.
• Configured SQL Server Report Manager.
• Performed Unit Testing and Data and Functionality Testing as part of System Testing of all the reports before release.

Confidential

Network Engineer

Responsibilities:

• Maintaining all servers without any downtime related to Linux and Windows
• Setting up and administering Outlook, domain Users, Groups and assigning policies.
• Installing and Configuring Antivirus, third party software’s, monitoring tools like Proactive Net and Zenoss
• Resolving memory and performance related issues.
• Configuring Internet Information Server (IIS)
• Maintaining and Scheduling Backup, Restore
• Knowledge on ticketing tools like BMC, Remedy