SUMMARY:

• Over 7 years of experience in requirement analysis, design, and development of projects with SQL Server 2008/2008R2/2012/2014 in various phases of Business Intelligence life cycle.
• Experienced in implementing Business Intelligence Solutions for Enterprise Decision support systems using Microsoft suite of products like SSIS, SSRS and SSAS and Power BI.
• Microsoft Certified in visualizing data in Power BI Desktop and deploying Dashboard in Power BI Cloud.
• Expert in creating different formats of reports for internal and external reporting purposes including drill down and drill through based on needs of granularity using SSRS 2005/2008/2012.
• Well acquainted in working with SSAS Tabular. Working knowledge of DAX expressions.
• Experienced in working as SSRS Admin in SharePoint Integrated Mode as well as Native Mode to collaborate, share reports and enforce security.
• Experienced in performance testing and query optimization for faster data access.
• Experience in Agent jobs, SQL Mail Agent, Alerts, and schedule DTS/SSIS Packages, Data Factory and Integration Runtime.
• Well versed with Kimball’s approach in OLAP development as per business needs.
• Skilled at solving challenges in a methodical manner and analyzing current issues to envision creative solutions. Demonstrate intellectual curiosity thus seamlessly learn new technology.
• Capable of handling responsibilities independently as well as a proactive team member. Strong Analytical skills and ability to work cross functionally.
• Experienced in working in Agile environments with Off Shore as well as Onsite staffs.
• Experienced in working with business communities to determine the needs, scope, and evaluation of project goals.
• Well versed in working cross - functionally with source SMEs, business teams, Integration specialists, Quality Assurance and Reporting teams.
• Detailed oriented, broad experience coupled with good communication skills to work in multiple BI roles.

SKILLSET:

Azure Data Warehouse, Azure Data Factory, Azure SQL Database, MS SQL Server 2012/2008R2/2008/2005, MS SQL Integration Services(SSIS), MSSQL Reporting Services(SSRS), MS Visio 2010/2012/2013 , IBM DB2, Oracle 8i-9i-11g, Amazon Red-shift, Adobe Omniture, Adobe Analytics, MS Office, Windows Server 2000/2003/2005/2008/2012/ 9 x/2000/ XP, Vista, SharePoint, Performance Point Services, Visual Studio 2005/2008/2010 , MS Access, T-SQL, PL/SQL, MS Outlook, SSRS 2016, Power BI Desktop, SSAS Tabular, Team Foundation Server, VSTS, R, Python, Atlassian Tools, IBM Digital Analytics

PROFESSIONAL EXPERIENCE:

Confidential, Boston, Massachusetts

BI Developer/Analyst

Responsibilities:

• Participated in requirements gathering sessions to analyze the old reports to be converted to New platform.
• Studied the old report code to identify ways to replicate this to the new data mart structure.
• Mapped old data elements to new data elements in the Reporting Mart structures in star/snowflake schema.
• Transformed the business requirement document into technical specification with tables, business rules and final attributes.
• Worked with the source systems SME to understand the data and properly structuring of data for Power BI reporting. Worked with Subject Matter experts to gain an understanding of the data to properly use relationship between tables and views.
• Created SSIS packages to load data from multiple sources to a SQL PaaS instance in an automated fashion.
• Created Wireframes for reports to mimic the final production version and enhance the final reporting value.
• Designed, developed, and tested the reports to correctly reflect the data points and ensure reporting requirements have been met.
• Created a security platform with Group workspace to collaborate and manage security. Laid out security platform for Development, QA, UAT and Prod Environment.
• Authored datasets and DAX measures to use in Power BI.
• Worked on a POC to move a portion of Datawarehouse to DataMart in an Azure SQL server environment using Azure Integration Runtime and Azure Data Factory.
• Worked with appropriate teams to triage issues/bugs in the system and assisted appropriate teams to resolve them.
• Assisted in Production support to help with user access and quality checks on the data.
• Authored SQL queries for ad-hoc data needs as necessary.

Environment: Azure SQL Database, Azure blob storage, Azure Data Warehouse, Azure Data factory, SSIS runtime, Visual Studio 2017, Power BI, SSRS, Redpoint Interaction, RedPoint Data Management, Jira, Confluence, SQL Server 2014

Confidential, NY, NY

Power BI Developer

Responsibilities:

• Participated in requirements gathering to gain an understanding of the project in hand.
• Performed technical analysis to identify options for providing functionality.
• Worked with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.
• Created Wireframes for reports to mimic the final production version and enhance the final reporting value.
• Worked with Subject Matter experts to gain an understanding of the data to properly use relationship between tables and views.
• Designed, developed, and tested the reports to correctly reflect the data points and ensure reporting requirements have been met.
• Created a security platform with Group workspace to collaborate and manage security.
• Assisted in Production support to help with user’s access and verification.

Environment: Azure SQL Database, Azure Data Lake, Azure Data Warehouse, Visual Studio 2017, Power BI, VSTS

Confidential, Allentown, PA

Financial Report Developer (SSRS, T SQL)

Responsibilities:

• Participated in requirements gathering to gain an understanding of the project in hand.
• Presented the strengths and weaknesses of various options, proposed an approach that best addresses requirements and constraints, and estimate effort to deliver.
• Created security layout/structure to properly support the security contexts for content managers and browsers.
• Worked with System Analysts and Business Analyst to gain an understanding of the data to properly use relationship between tables and views.
• Authored T-SQL queries to get the required raw data to feed the reporting platforms.
• Developed financial reports like Trended Balance Sheet, trended Income Sheet, Trial Balance, Aging reports as well as audit reports.
• Documented and performed unit tests to ensure reporting requirements have been met.
• Documented steps to configure and deploy data deliverables. Suggested industry accepted standards to have a good, robust, reliable, and versatile system.
• Successfully deployed the tested structure and reports into production system.
• Migrated Report rdls from 2005 environment to 2012 environment.

Environment: MS SQL Server 2012, SSRS 2005/2012, Visual Studio 2010 Shell, CODA by Unit4, Cognos Impromptu 7.6

Confidential, Ewing, NJ

Report Developer (SSRS, SSAS Tabular, Power BI)

Responsibilities:

• Participated in requirements gathering for data deliverables to ensure an understanding of their purpose and provide a technical perspective on requirements.
• Performed technical analysis to identify options for providing functionality. Presented the strengths and weaknesses of various options, propose an approach that best addresses requirements and constraints, and estimate effort to deliver.
• Created designs that clearly identify how standard issues will be addressed.
• Worked with other team members (Data Analysts, Data SMEs and Data Architects/Modelers) to understand the source of data required and details about the meaning and structure of the data necessary to properly use it.
• Developed data deliverables by creating queries (SQL, DAX) to retrieve data and using a designer to define a layout for end user consumption. Configured properties to achieve required behavior and results.
• Documented and performed unit tests to ensure requirements have been met.
• Documented steps to configure and deploy data deliverables. Worked with the Business Intelligence Development Lead and Configuration Management resources to ensure successful migration to each environment.
• Worked with ETL Team to set up daily Data Load requirements and package scheduling.
• Worked extensively with Guidewire Claim and Policy center to support business processes.
• Worked with Tabular Model infrastructure in SSAS and displayed interactive Dashboard in Power BI Desktop.

Environment: MS SQL Server 2005/2012, SSRS 2016, SSAS Tabular 2012, Microsoft Team Foundation Server, Visual Studio, Performance point server, Excel, Power BI Desktop, Tivoli, Google Analytics, DAX Studio, Guidewire Claim Center, Guidewire Policy Center,R

Confidential, New York, NY

MS SQL Server BI developer/Analyst

Responsibilities:

• Involved in requirement gathering for a new business unit to create and automate reports.
• Carried change management to SSIS packages to align BI solution to OLTP changes and changes in Business rules.
• Designed ETL packages to import data to SQL Server from various relational data sources as well as third party tools.
• Designed SSIS packages to call Web service API call in VB Script task.
• Designed complex ETL packages involving incremental load with various data conversion transformation to maintain uniformity while working with various relational data sources, Excel and Flat files.
• Automated packages using SQL Server Agent to load Data from staging tables to Data Warehouse.
• Designed and Deployed multidimensional OLAP cubes with hierarchies and calculated measures from Data warehouse for Reporting and Analysis.
• Designed, Developed, Deployed and Maintained parameterized, drill through, dropped-down tabular, matrix and sub reports.
• Maintained separate security measures for report Security for different business unit with Site, Folder as well as Report Settings.
• Created interactive Dashboards in Microsoft Excel from data from SSAS Cube.
• Designed, Deployed, and automated profile data for marketing campaigns.
• Designed deployed and maintained feeds to populate front end Sites.
• Created financial reports for finance team as well as created a daily report to track Web Traffic data.
• Managed subscriptions, snapshots in the report manager.
• Used power BI tools in Excel to spot favorable, unfavorable trends and outliers.
• Generated, enhanced, and maintained ad-hoc using Report Builder 3.0.
• Used various transformations like Merge, Merge join, Union all, lookup, Derived column, fuzzy lookup, multicast, conditional split transformations to maintain data consistency.

Environment: MS SQL Server 2005/2012, SSRS, Microsoft Access, Visual Studio, Excel Power BI, Oracle 11g, Amazon Redshift, IBM DB2, Adobe Omniture, R

Confidential, Framingham, MA

MS SQL Server BI developer

Responsibilities:

• Involved in designing multidimensional OLAP cubes in SSAS from the existing data warehouse for various sales, marketing and buying divisions.
• Deployed SSAS cubes from fact and dimensions with Aggregations, KPI, Measures, hierarchies, and attributes.
• Deployed cubes and processed reports to SSRS in various formats which were further incorporated in the SharePoint with security measures.
• Created different financial statements reports to update on the management dashboard and 10K to update weekly and drilled down by year, quarters, and months.
• Managed subscriptions, snapshots, and security in the report manager.
• Worked on the team to build an executive dashboard with embedded filters, scorecard, charts and KPIs.
• Used power BI tools in Excel to spot favorable, unfavorable trends and outliers.
• Generated, enhanced, and maintained ad-hoc using Report Builder 3.0.
• Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
• Works closely with the Data Warehouse development staff to develop new databases to support reporting needs and to identify and resolve database performance problems.
• Created SSIS packages to import data from Excel, flat files and other OLEDB sources.
• Used Power BI tools such as Power pivot, Power Map, Power Pivot in Excel 2013 For Data Mining analytics to spot trends and patterns and creating ad-hoc reports for decision making.

Environment: MS SQL Server 2012, SSRS, SSAS, Microsoft Access, Visual Studio, Excel Power BI, SharePoint, Oracle 11g, Google Web Analytics

Confidential, Pittsburgh, PA

Jr. MS SQL Server /SSRS /SSIS Developer

Responsibilities:

• Participated in entire life cycle of data warehouse- planning, defining, and designing data warehouse to bring in data from various data sources based on business requirements and provided documentation. Participated in Conceptual, logical, and physical design of the model.
• Created star and snowflake schema model using fact and dimension tables based on data granularity requirements. Created additive, semi additive and non-additive facts with conformed and non-conformed dimensions, shared dimension, degenerated dimensions, and slowly changing dimensions.
• Created various Extraction Transformation and Loading (ETL) packages to cleanse the data to maintain uniformity and maintain coherent data as well as populate the data from various source systems feeds using SSIS 2008 R2.
• Used various transformations like Merge, Merge join, Union all, lookup, Derived column, fuzzy lookup, multicast, conditional split transformations to maintain data consistency.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Created mappings/workflows to extract and Transform data from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Debugged packages using Precedence constraints, Break Points, Check Points, and viewers. Migration and Metadata Management:
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database
• Expert in creating different formats of reports for internal and external reporting purposes as well as SharePoint.
• Experienced in creating and populating data warehouses OLTP data with various transformations, containers, variables, configurations, and schedules.

Environment: MS SQL SERVER 2012/2008 R2/2000, SQL Server 2012, SSIS, SSRS, Microsoft Visual Studio 2008, MS SQL Profiler, Microsoft Visio, MS Office 2010, Windows NT/2008, Erwin 4.0, MS Outlook, FTP, TSQL, Windows 2008

Confidential, Saint Louis, MO

Jr. BI Analyst/Developer

Responsibilities:

• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Querying SQL data warehouse to find data points for Ad-hoc reporting.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Extensively involved in carrying out the Unit testing of the applications and tuning of complex procedures.
• Wrote Stored Procedure, Tables, Views, and other T-SQL JOIN techniques.

Environment: SQL Server 2008, MS Outlook, TSQL, My SQL andDB2.