SUMMARY:

• Having over 11 years of experience as Business Intelligence Consultant with strong understanding of modern Client - Server based systems.
• Sound knowledge on financial Reporting Retail accounting (Weyerhaeuser, Microsoft Online Sales Division) and expertise in Insurance Domain.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experienced Microsoft Big data (COSMOS). Data load from COSMOS using Scope and SSIS.
• Expertise in Performance Point Server 2007, Microsoft Business Intelligence Tools (SSIS, SSAS (Tabular Model), SSRS, Power BI Desktop, Power View, Power Pivot, Power Maps, Power Query, ProClarity, SQLServer 2005/2008/2012 , Microsoft 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 Snow Flake Schema.
• Experience in developing SSAS Tabular & Multidimensional Cubes, Dimensions and data source views and Deploying and Processing SSAS objects.
• Experience on Tableau Desktop tool to create the reports and dashboards.
• Expertise in Business Intelligence Reporting tools like Cognos (E), Business Objects and SAS.
• Developed Cubes using different types of storage modes like Multidimensional OLAP (MOLAP).
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.
• Excellent in creating program specs and writing programs of high complexity
• 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
• Ability to work efficiently and effectively under stressful, high pressure and tight deadlines
• Extremely Dedicated, self-motivated Proactive and willing to assume responsibility
• Possess strong programming, problem solving and analytical skills
• Ability to quickly adapt to new ideas and technologies.
• Good team player with excellent inter-personal communication, leadership, training and multi-tasking skills.
• Using SCOPE scripts & SSIS to read and load data from COSMOS to SQL.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• ETL implementation using SQL Server Integration Services (SSIS).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).
• Experience in creating configuration files/batch (.bat) to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Expert in Extracting and transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import and Export Data.
• Environment migration.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services.
• Experience in Developing and Extending SSAS Tabular models, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Created Excel form for end users using SSAS write back functionality.
• Strong experience to create static, ad-hoc/dynamic reports and graphs
• Created reports using cube member properties
• Created ad-hoc reports using Power Pivots add-in
• Done proof of concepts using Power BI tools (Power Query/ Power View) for excel.
• Crated different type of reports using Tableau desktop like Bar, Line and Map (Geography)
• Crated Dashboards using Tableau desktop and then publish to Tableau Server for end user access.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, DrillDown, Drill-Through, Multi-valued parameters etc.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Worked with report manager for deploying the reports across all the environments.
• Created universe us universe designer tool
• Creating Standard Reports Using Business Objects universe.
• Extensively used calculations, Sorting, Rank, Drill down, Drill throe, Slice and Dice.
• Formatting, Changing Displays and Prompts for creating BO Reports.
• Created Reports in cross tab, master detail format and transformed them in 2-D, 3-D
• Created Catalog and make joins between tables.
• Created Reports Using Impromptu, Powerplay functionality like Slice and Dice, Drill Down, Cross tab, Master and Detail reports.
• Created Conditional Reports in Impromptu.
• Created Prompts based on client request (Type In, Pick List).
• Created IQD files for Powerplay report.
• Created cube’s (.mdb) for Power play reporting
• Strong experience in crate the forms using Performance Point Server for end users to enter the data
• Crated different kind of form like Forecast, Budget and Allocation.
• Good Knowledge on creating score cards and dash boards using MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.

TECHNICAL SKILLS:

Operating System: Windows 98/NT/XP/7/8UNIX

Programming Languages: C, C++, Shell Scripting, SQL, PL/SQL, SAS Basics, XML, MDX, DAX

Databases & Tools: SQL Server 2000/ 2005/2008/2012 Oracle 8, MS Access

TOAD for Data AnalystsETL Tools: SQL Server Integration Services (SSIS)

SCOPE: Attunity Replica,SSAS Data Integration Studio, Informatica

Planning Tools: Office Performance Point Server 2007,Flow Plan (Application), Excel

BI Tools: SQL Server Analysis Services,SQL Server Analysis Tabular Model, SQL Server Reporting Services, Microsoft Power BI Desktop

Microsoft Power BI Tools: Power View,Power Pivot,Power Query, PerformancePoint Server2007,ProClarity,SharePoint 2010, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Map Studio, SAS Enterprise Guide,SAS Web OLAP Viewer for Java,SAS Management Reporter

Cognos BI Tools (Version EP7): Cognos Impromptu,Power play, Transformer, Business Objects BI Tools (Version 4),Universe Designer, Report Designer, Info-View, Version Controlling, Team Foundation Server (TFS), Visual SourceSafe (VSS)

WORK EXPERIENCE:

Confidential, Redmond, WA

BI Analyst

Operating Systems: Windows 8/10

Programming Languages: SQL, PL/SQL, MDX, DAX, Scope Scripts

Database: SQL Server 2008/2012

BI Tools: SSIS, SSAS, SSRS, Power BI Desktop, Scope Scripts, SSAS Tabular Model, SharePoint, Excel Pivot and Excel Reporting

Responsibilities:

• Understating Key Life Cycle business to provide solutions for complex systems.
• Created Tabular model for Key (Windows & Office) activation launch reporting, used Power BI Desktop, SSRS & Excel reporting.
• Writing complex SQL queries and working with data extracts joining multiple upstream sources.
• Identifying, analyzing and interpret data to find patterns and data irregularities.
• Monitoring data extracts for correctness, being able to identify abnormalities and investigate source to determine root cause.
• Creating SSIS packages for data extraction from different data sources like PAIntel, (SQL & COSMOS) and EDS, SharePoint & Excel.
• Using DDL (Dynamic Data Load) API & Power Shell script to load data from COSMOS.
• Created SSRS & Excel reports for Office Activations.
• And changes exiting SSIS packages for performance improvements.
• Creating Models and cube (SSAS/Tabular) and reporting using Power BI and SSRS reports
• Follows up on tasks assigned and provides updates.
• Handles Ambiguity- Involving a general business problem and work with customers to identify solutions
• Involving and implementing business logic across the other projects which is not in key life cycles stages.
• Involving end user support to support the applications.

Confidential, Federal Way, WA

BI Analyst

Operating Systems: Windows 7/8

Programming Languages: SQL, PL/SQL, C#, MDX, DAX

Database: SQL Server 2008/2012

BI Tools: Attunity Replication, SSIS, SSRS, SSAS Tabular Model, Tableau, SharePoint, Excel Power Pivot and Excel Reporting

Responsibilities:

• Understand the current SAP BW system and end reports
• Preparing the requirement documents
• Exhibit complete understanding of the module's functional and technical requirements
• Conduct Requirement and Impact Analysis
• And also played ETL Architect role Participate in / Conduct design reviews and also played as mentor
• Develop project artifacts (e.g. standards & guidelines, program specifications, test strategy, test plans) as per the defined schedule and estimates
• Created Database, Schemas and Tables for SAP Confidential .
• Providing access to respective group to access the database and tables
• Created SSIS packages to pull data and also created simple, complex procedures, cursers for apply business rules.
• Code, Test, Debug, review as per project standards
• Creating and managing SSAS Tabular models. Creating Dimension Tables and Fact Tables as per the requirement.
• Crated Sales, Product, Geography wise reports and dashboards using Tableau visualizer tool
• Crated Bar and Line reports for Product wise sales analysis
• Created Geography wise profit Tableau reports and Tableau dashboards
• Troubleshoot project issues by doing Confidential and Proof of Concept
• Contribute in tool usage in optimization to achieve performance and other non-Functional requirements
• Demonstrate proficiency in usage of tools in a project environment- Scheduler, Timesheets, Configuration Management
• Creating the fact and dimension data with required for models & calculated measures.
• Creation of Jobs and its Scheduling.
• Creating Excel reports & Performing Data validation activity between systems.
• Involved in fixing the bugs and handled the CR (Change Requests) & Interacted with client for the requirement for different CR’s.
• Provided Customer support
• Created folder and document and then published in SharePoint
• Created User and Security group and then providing access to access the SharePoint files, folder and Reports
• Maintaining CR’s information, documentation and Calendar using SharePoint

Confidential, Bellevue, WA

Specialist Developer

Operating Systems: Windows 7/8

Programming Languages: SQL, PL/SQL, C#, MDX

Database: SQL Server 2005/2008

BI Tools: SSIS, SSAS Multidimensional Model, SharePoint Excel Power Pivot and Excel Reporting

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
• Code, Test, Debug, review as per project standards
• Participate in defect triage and plan for defect fixes
• Creating and managing SSIS packages. Creating Dimension Tables and Fact Tables as per the requirement.
• Used C# code in SSIS Script task to find file expectancy
• Exhibit complete understanding of the module's functional and technical requirements
• Troubleshoot project issues by doing R&D and Proof of Concept
• Mentor developers on programming & design
• Contribute in tool usage in optimization to achieve performance and other non-Functional requirements
• Demonstrate proficiency in usage of tools in a project environment- Scheduler, Timesheets, Configuration Management, Defect tracking tools/Testing and Development /tools
• Creating SSAS cubes from the fact and dimension data with required calculated measures.
• Creation of Jobs and its Scheduling.
• Creating Excel reports & Performing Data validation activity.
• Involved in fixing the bugs and handled the CR (Change Requests) & Interacted with client for the requirement for different CR’s.
• Bug fixing after client site testing.
• Maintaining Project plan and Time sheet.
• Provided Customer support
• Created folder and document and then published in SharePoint
• Created User and Security group and then providing access to access the SharePoint files, folder and Reports
• Maintaining CR’s information, documentation and Calendar using SharePoint

Confidential, Federal Way, WA

Software Specialist

Operating Systems: Windows 7/8

Programming Languages: SQL, PL/SQL, C#, MDX

Database: SQL Server 2005

BI Tools: Office Performance Point Server (Planning), SSIS,SSRS, Flow Plan (Internal Product), SharePoint Excel Power Pivot and Excel Reporting

Responsibilities:

• Understanding BRD documents.
• PPS installation is done on client and server.
• ProClarity installation is done on client and server.
• Developed application using PerformancePoint Server.
• Developed member set based on change request.
• Developed rules in business modular.
• Developed forms though excel.
• Developed SSIS packages & Modified existing packages based on change requests.
• Prepared Technical Documents for SSIS packages.
• Used C# code in SSIS Script task to find file expectancy
• Unit test case preparation.
• Deployment done for one server to another using deployment utility.
• Developed reports using SSRS and ProClarity.
• Developed dashboard using Performance Point server Dashboard Designer.
• Developed dashboard using ProClarity Dashboard Manager
• Created folder and document and then published in SharePoint
• Created User and Security group and then providing access to access the SharePoint files, folder and Reports
• Maintaining CR’s information, documentation and Calendar using SharePoint.

Confidential

Software Developer

Operating Systems: Windows xp

Programming Languages: SQL, PL/SQL, C#, MDX

Database: Oracle 8

BI Tools: SAS Integration Services, SAS OLAP, SAS Reporing

Responsibilities:

• Acted as a member of the Quality Assurance team, identifying source to target mapping and requirements defects, and documenting recommended solutions.
• Developed ETL jobs using SAS OLAP tools for system testing, and executed system test scenarios.
• Resolved primary and natural key discrepancies on database tables, documented causes of duplicate, missing, and incorrect data, and identified and corrected SAS OLAP coding errors.
• Developed and enhanced the programs as per the new business Requirements.
• Creating cubes using SAS OLAP Studio.
• Creating calculated measure for cube and reports.
• Creating information map for reporting.
• Creating reports using conditions and portal using SAS Web Report Studio & OLAP Viewer.
• Working with jobs for data population & creating package file for deployment.
• Preparing documentation for user manuals, source and target data