PROFILE SUMMARY:

• 10 years of experience in Analytics stream of which more than 8 Years of Experience in SQL server, SSIS, SSAS (multidimensional & tabular models) & SSRS. Along with experience on Power BI, Cosmos, ADW, ADL & ADF.
• Cleansing & processing data using Excel/CSV, text, Access, scope and SQL.
• Experience in generating scorecards, dashboard, KPI's using SSRS, power pivot, power BI and Jasper reports.
• Gathered, analyzed and documented business requirements, clarifying business rules and data design requirements, functional requirements and data specifications for reporting requirements in different functional modules like Marketing, HR, Finance, Sales, Accounts Payable, Accounts receivables, Learning etc.
• Experienced in Designing and Developing Data Transformations and ETL Solutions, using SQL Server Integration Services and Integrating SSIS with different MS tools in providing Robust Solutions.
• Source Control Tools like TFS (Team Foundation Server) has been used extensively, also used to perform Project Management, Agile Planning and Reporting.
• Design BI architecture to integrate R algorithm with Azure SQL using SSIS and PowerShell.
• Build a strong and strategic data model using SSAS for major Microsoft learning portal feed, which is using to develop BISM and self - service reports.
• Experienced in SQL development like creating Tables, views, Stored Procedures, SSIS Packages, SQL Agent jobs to perform different type of data loads.
• Experience in querying and creating databases on cloud environment using SQL Azure and cosmos.
• Experienced in creating process chains, scheduling process chains and monitoring them to load data to various information providers.
• Experience in leading onsite-offshore and multiple.
• Excellent presentation and communication skills.

SKILLS:

Database(on-prem/cloud): SQL Azure, SQL Server, Access, Excel, ADW, ADL, ADF & cosmos.

Database Tools: SSDT/BIDS 2012/2008 R2/2008, Management Studio, Visual Studio, Query Analyzer, SQL Profiler, SSIS, SSAS(multidimensional & tabular models), Upgrade Wizard, Replication.

Programming languages: SQL, T-SQL, SCOPE, U-SQL, MDX, DAX, VB.NET, C#, R, Hive.

Operating systems: Windows 7/8/10, Linux.

Reporting Tools: SSRS, Report Builder, Power BI Desktop, Power Pivot/view/query and Jasper soft.

Other: Microsoft Office, Visio, Dream viewer, Team Foundation Server (TFS) and Hadoop, HDFS, As-Is Process Mapping, Requirements Gathering, Gap Analysis, Preparing Test Cases, Preparing High level design documents.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Power BI Developer, Ft Myers, FL

Technologies: SQL Server, Azure DW, stream analytics, SSAS (Tabular), DAX and Power BI.

Responsibilities:

• Created OLTP & OLAP systems (architected and built with full automation via SQL Azure).
• Create data integration and technical solutions for Azure SQL databases and Azure SQL Data Warehouse for providing analytics and reports for improving marketing strategies.
• Perform multiple data analysis projects that help to develop business strategy.
• Enable self-service reporting using Tabular model, Power BI reports.
• Lead development of various dashboards that are of critical import and highly visible by measuring the needs of “varied” customers against the capabilities of selected products, as well as the skill set of available resources.
• Direct end-to-end solution reviews, which resulted in better alignment to business strategy and ensured plan/strategy buy-in.
• Provided data modeling tools, forecasting tools, and pricing elasticity models for product managers.

Confidential

Sr. Analyst, Redmond, WA

Technologies: SSIS, T-SQL, MS SQL Server 2014, SSAS, MDX, SSRS, Azure and Power BI.

Responsibilities:

• Create SSIS Packages to pull data to on board data from different sources (web, file, SharePoint online, Azure & other databases).
• Create OLAP databases using SSAS, design Cubes that matches with client expectation
• Enable self-service reporting using PowerPivot, Tabular model, Power BI and Excel reports

Confidential

Sr Development Engineer

Technologies: SSIS, T-SQL, jasper soft.

Responsibilities:

• Created SSIS Packages to pull data to onboard data from warehouse to a data mart with dimension fact like structure.
• Create static, ad hoc reports, KPIs, dashboards and scorecards using jaspersoft.
• Design RLS and column level security for reports & Integrate them to web application.

Confidential

Sr Development Engineer

Technologies: SSIS, SSAS, SSRS & T- SQL

Responsibilities:

• Involved in developing complex ETL packages for loading data from different sources into the data warehouse, like CMATWSAT, WUE, PIDPlus etc.
• Automating excel reports using SSRS. Helping team during deployment & testing.
• Created a standard ETL template which can be used for all the sources.

Confidential

Sr Development Engineer

Technologies: SSIS, T-SQL, C#, MS SQL Server 2008, Business Intelligence Development Studio (BIDS), MS Excel, CSV,BCP, XML and Windows server 2008.

Responsibilities:

• Created SSIS Packages to pull data to onboard data from different sources (web, file & database).
• Improving the existing structure by modifying the ETL & reports when and where needed. (Code improvement and performance improvement).