SUMMARY:

• Over 6+ years of experience in implementation & administration of Tableau, Power BI, SSRS, and SSIS Business intelligence and Microsoft SQL Server 2016 in development, testing and production environment. Microsoft certified - Power BI, SQL Server, Azure Developer, Dynamics 365.
• Excellent working knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), Requirements gathering, Analysis, Design, Development, Implementation and Testing, Methods like Agile/Scrum, Waterfall, Business Process and Data Modeling with emphasis on Software Quality Assurance including Functional and Integration testing.
• Highly experienced in Designing, Developing and Deploying various reports like Tabular, Matrix, Chart, Drill down, List, Ad-hoc, Parameterized, Cascading and other reports using SSRS. Worked on Subscriptions, scheduling snapshots, managing snapshot history. Expert in managing the report manager and report server.
• Created Report Models for ad-hoc reporting and analysis using SSAS. Extensively involved in the design of SSAS & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube using SSAS.
• Experience in Angular 2, HTML, CSS, NodeJS, JavaScript, TypeScript.
• Thorough knowledge in data warehouse concepts, Relational Database Management Systems (RDBMS), Normalization, Data Modeling and Documentation. Involved in Data modeling by using Erwin tool.
• Extensive knowledge of addressing performing issues and involved in performance tuning, index tuning, Data Profiling and query optimization.
• Experience on publishing Power BI reports on dashboards in Power BI server. Designed and developed Power BI graphical and visualization solutions based on business requirement.
• Expert with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.
• Identified gaps in data collection, the data model, and metadata for future enhancements.
• Created simple to complex data, reporting, and business intelligence solutions by utilizing existing reporting, analytics and business intelligence platforms.
• Proficient in MySQL, SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Used MS SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data. Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models using SQL Server Reporting Services (SSRS) based on client requirement and ad-hoc reports in excel using pivot table/charts.
• Experienced in designing, creating, testing, and implementing complex reports using SSRS, Crystal Reports, Webi reports, and Business Objects Enterprise reporting tools.
• Self-motivated and possess the ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User-oriented with a desire to learn the client's business requirements.
• Strong understanding of big data platforms (HANA, Hadoop, Redshift, etc.) and both streaming & ETL processes, and familiarity with SQL/Python.
• A strong inclination for finishing the job before the project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Database Technologies: SQL Server 2016, Oracle 10g SQL, PLSQL, Oracle 11g/12c

Programming Languages: MySQL, SQL, T-SQL, HTML, HTML5, CSS, XML, C#, Python

Business Intelligence Tools: MSBI (SSIS, SSRS & SSAS), Metadata

IDEs /Tools: MS Visual Studio 2016, SSMS

Other Tools: MS Office Suite (Word, PowerPoint, Visio), OLAP, OLTP, TFS, JIRA. MS Dynamics 365, ERWIN, Informatica

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Tableau Prep, Power Qwery

Reporting Tools: SSRS 2016, Tableau, Power BI, Crystal Reporting, Webi Reporting, Microsoft Access, Excel.

Automation Tools: UiPath

PROFESSIONAL EXPERIENCE:

Confidential - Seattle, WA

Sr. Business Intelligence Developer

Responsibilities:

• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Used Microsoft Power BI to Build and maintain the reports and dashboards.
• Created SSIS packages to validate, extract, transform and load data-to-data warehouse databases and deployed with minimal changes using XML configuration file.
• Generated matrix reports, drill down, and drill through, sub reports.
• Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
• Worked on pull the data from the SSAS Cubes for the reporting purposes.
• Worked on Development and implementation of SSRS reports and ran them as per the requirement.
• Generated daily, weekly and monthly reports for the managers.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Confidential - San Francisco/Sacramento, CA

Sr. Business Intelligence Developer

Responsibilities:

• Effectively interacting with the end users for requirement gathering and defined requirement specifications document. Experience in the development of business, technical, and administrative requirements for a project.
• Developing business focused automated reports using tools such as SSRS and Power BI as well as building necessary SQL data objects used by reports.
• Using SSIS to create maintain and troubleshoot ETL packages to validate, extract, transform and load data to data warehouse databases. Performance tuning on existing ETL packages.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Power BI application.
• D esigned and developed loss and decline report using MS SQL Stored procedure and DAX functions in Power BI and Power Pivot.
• Provided users with time being excel reports and used it as process improvement for the final report in Power BI.
• Wrote calculated columns, measure queries in Power BI desktop to show good data analysis techniques. Designed and developed stored procedures & used Power BI desktop to render the report.

Environment: MS SQL Server 2016, Power BI, Salesforce, Google Analytics, SQL Server Reporting Services, SQL Server Integration Services (SSIS), SSRS, CTD, ESRI GIS, Salesforce.

Confidential - Sacramento, CA

Sr. Business Intelligence Developer

Responsibilities:

• Identified the required data objects in the database and created various T-SQL, PL/SQL, and OLAP data structures complex queries to pull data for reports.
• Analyze business requirements and data sources from Salesforce, Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Power BI Desktop. Fine-tuned SQL Queries for maximum efficiency and performance. Used SQL and Excel to cleanse and perform calculations against data.
• Coordinated collection of high-level business needs. Acted as a liaison between the business/operations and systems group to document analysis of business functionality. Converted high-level requirements to functional requirements and documented them in functional, navigational and page Use Cases. Prepared Functional Requirements documents using the existing templates. Documented business rules and functional requirements iteratively. Imported these use cases into Requisite pro; tagged and traced them
• Designed and developed Power BI graphical and visualization solutions based on business requirement. Also, created POCs by analyzing data and situations, identifying and solving problems, reason logically, draw valid conclusions, and develop effective solutions.
• Modified existing dashboards as per new requirements in Power BI. Recreated reports from MS Excel to Power BI. Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure.
• Installed and configured Enterprise gateway and Personal gateway in Power BI Service.
• Scheduled Automatic refresh and scheduling refresh in power bi service. Wrote calculated columns, measure queries in Power BI desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required. Developed various reports such as Yearly, Quarterly, Monthly, and Daily.
• Developed various types of transformations that are available in Power BI query editor
• Created stored procedures and SQL queries to pull data into PowerPivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed the informatica mappings and workflows. Developed shell scripts to start Informatica workflows.
• Involved in SQL queries tuning and improved the performance of Informatica session.
• Created informatica workflows and added the tasks like e-mail and Command.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Excel, and Power Pivot and Power Point.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Reports using Charts, Gauges, Tables, matrix. Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Developing business focused automated reports using tools such as SSRS and Power BI as well as building necessary SQL data objects used by reports.
• Working with Data Warehouse and related technologies such as Microsoft SSIS, SQL, ETL, and OLAP data structures.
• Designing and developing various complex reports using drill down, drill through, sub reports, cascade parametric, linked, and cross tabbed reports using SSRS.
• Responsible for ongoing maintenance and management of existing SSRS reports. Also to optimize report performance.
• Using Report manager to deploy reports, schedule reports and created groups and users in SSRS.
• Demonstrating experience creating, debugging, and modifying complex stored procedures and views, as well as querying and updating data using SQL.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Troubleshooting of the already existing SSIS packages.
• Performance testing on stored procedures, indexes, and triggers. Performed Smoke Testing, Functional Testing, Regression Testing, Integration Testing, UAT Testing, and Localization Testing. Experience working with UAT testers in UAT environment.

Environment: MS SQL Server 2016, Power BI, Tableau Desktop, Server, and Prep, Salesforce, Google Analytics, SQL Server Reporting Services, SQL Server Integration Services (SSIS), Dynamics 365, ETL, Business Objects XI 4.0/3.1, Crystal Reporting 2013/2008, Info View, CMC, Visual Studio, OLAP, JIRA, Linux.

Confidential - Boston, MA

Business Intelligence Developer/ Microsoft Full-Stack Developer

Responsibilities:

• Facilitated gathering and analyzing business requirements and translating the same into system / technical requirements.
• Analyze business requirements and data sources from Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Create views in Tableau Desktop that are published to internal team for review and further data analysis and customization using filters and actions.
• Designed Summary and Detailed reports using Data Blending and cascading feature in Tableau to provide dependency on objects through filters. Helped Tableau power users in optimizing their tableau reports with proper use of filter, optimized SQL queries etc.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Developed reports and dashboards for service center telephony data, interactive voice response (IVR), workforce management.
• Develop important key performance indicators (KPI) metrics for the service center using Tableau.
• Developed visual analytics reports and dashboards.
• Improved performance of the dashboard at report level, by reducing the scope of the visualization with respect to sheet and data sources, reducing number of filters in the view, creating efficient calculations.
• Performed Smoke Testing, Functional Testing, Regression Testing, Integration Testing, UAT Testing and Localization Testing. Experience working with UAT testers in UAT environment.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Environment: MS SQL Server 2014/2012, SQL Server Management Studio, MS Excel, SQL server Reporting Services (SSRS) 2012/2008, SQL Integration Services (SSIS)2012/2008, SQL Analysis services (SSAS)2012/2008, Microsoft Visual Studio 2010/2008, T-SQL, VB.Net, Java, Power BI.

Confidential - NYC, NY

Business Data Analyst

Responsibilities:

• Involved in Technical decisions for the Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Involved in creating clustered and Non-Clustered Indexes to improve the database transactions performance.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets, and hierarchies.
• Involved in database development using stored procedures, triggers, views, and cursors.
• Converted, loaded and integrated data from Access, Excel, text.csv files and internal database applications including the mainframe with data captured for security applications
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Developed an SSIS solution for developing a fully-fledged data warehouse solution.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files, and CSV files.
• Willingness to tackle complex projects to successful completion and to learn new technologies. Knowledge of Microsoft productivity tools such as Excel, PowerPoint, and Visio, as well as a willingness to learn the approved third-party solution
• Working both independently and in a team-oriented, collaborative environment is essential, as well as having strong interpersonal skills.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, SubReports.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.

Environment: SQL Server 2012 Enterprise Edition, Tableau, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), TSQL, C#, .Net framework.