SUMMARY

• Expertise in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence Visualization, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Strong understanding of Data Management and identifying Key Performance Indicators defined by the Business & Stakeholders to ensure alignment with other business units.
• Worked on designing dashboard / reports to give them consistent and professional looks using Power BI/ Tableau/ Cognos/ SSRS/ Qlikview
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Excellent hands-on experience in groups, hierarchies, and measures, KPIs
• Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, for Analytical Projects and Data Visualization Community.
• Good Knowledge in Data Science Statistical Modelling with Python and R.
• Good Knowledge in AWS concepts and Amazon Redshift tools.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Blob, Azure Storage Explorer
• Published reports to Azure-based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.
• Experience with Data flow diagrams, Data dictionary, Data Governance Database normalization theory techniques, Entity relation modeling and design techniques.
• Developed and successfully deployed multiple initiatives with Executive Dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.
• Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services.
• Proficiency in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling.
• Good Working knowledge on ETL tools like Informatica, Informatica IDQ & Datastage.
• Worked closely with Business Analyst, Enterprise Data Management Team and Data warehouse architect to understand the source data and need of the Warehouse.
• Strong troubleshooting & production support skills and coordination abilities with end users.
• Exceptional ability to quickly master new concepts and technologies.

TECHNICAL SKILLS

Business Intelligence: Microsoft PowerBI, Tableau, Cognos 11, BOBJ, SAS, SSRS.

ETL Tool: Informatica, Datastage,SSIS.

Languages: SQL, PL/SQL, HTML, JSP, Java Script., Python, R.

Database: ORACLE 10g, 11g, 18c, DB2, MS SQL 2019,MSAccess, Azure

Data Modeling Tool: Erwin 4.1, Visio 2000, UML.

Database Tools: Toad, SQL Navigator,SPARK, Management Studio

Operating System: Microsoft 7/Vista/XP/2000/NT, UNIX, Sun Solaris 5, Linux

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)

PROFESSIONAL EXPERIENCE

Confidential

SR.Data Analyst

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.
• Involved in designing of star schema based data model with dimensions and facts.
• Design and Development of Data Analytics solution leveraging Tableau and Cognos.
• Design and Development of Data warehouse solution leveraging Oracle, Exadata and Informatica.
• Solution Design and Implementation of Business Intelligence reports and OLAP cubes using Cognos Reporting Services, Tableau and Power Pivot & Performance Test.
• Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Cognos.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop. Developed Tableau workbooks from multiple data sources using Data Blending.
• Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
• Document all mappings, mapplets, and rules in detail and hand over documentation to the customer.
• Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ.
• Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and other ETL tools.
• Worked extensively on EDW and Facets databases.

Environment: Tableau,PowerBI,Informatica IDQ, Oracle 18c, SQL Server 2008, DB2, Toad, Informatica, Windows 2008/ XP.

Confidential

Senior BI Developer

Responsibilities:

• Analyzing the specifications provided by the client and developing the specification document for the reports as per the client requirements.
• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Created Dashboard Reports using Power BI, Cognos and Tableau.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure Storage, and Azure Data Factory, SSIS, and PowerShell. Created processes to load data from Azure Storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.
• Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data.
• Worked on both live and import data to Power BI for creating reports.
• Worked with Power BI gateway to schedule daily job to refresh data
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server using Direct Query.
• Managed relationship between Power BI using Schemas such as Star & Snowflake.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
• Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
• Used Dimensional Modeling (DMR) and Relational Modeling and Snow Flake Schema modeling technique to develop models.
• Published reports to Azure-based Power BI services (Pro) and schedule subscription and Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.various sharing options (workspace, content pack, and Apps).
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
• Created cubes using Power play Transformer and implemented security into the cube model.
• Developed Unit Test Cases, documents for report validation and testing after interacting with the end users.
• Involved in writing Queries in SQL server. Trained end users effectively to use reporting tool, to build and customize their Ad-hoc reports.
• Worked with ETL team for developing various mappings and workflows in Informatica as required by the design specifications.
• Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Provided Production support and resolved maintenance issues. Performed Data Validations, Unit testing and prepared some Test cases.

Environment: Tableau, Power BI Desktop & Service, DAX, Azure, T-SQL, Azure Data factory, Informatica, Oracle 10i, SQL Server 2008, Toad, Teradata, MS Excel, Windows 2008/ XP, Visio.

Confidential, Datyon, OH

BI/Reporting Analyst

Responsibilities:

• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication techniques.
• Carried out report bursting for financial administrative services group to streamline report delivery process.
• Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, Page break, Master Detail, drill through, drill up, drill down and have extensively used the other features in Cognos 8.
• Created cubes using Power play Transformer and implemented security into the cube model.
• Developed Unit Test Cases, documents for report validation and testing after interacting with the end users.
• Involved in writing Queries in SQL server. Trained end users effectively to use reporting tool, to build and customize their Ad-hoc reports.
• Worked with ETL team for developing various mappings and workflows in Informatica as required by the design specifications.
• Perform both record-level and large-scale manual additions, adjustments and corrections to continuously ensure overall data quality and integrity.
• Experience in writing HTML/Java Script in Cognos Report Studio/Webfocus reports as per the requirements.
• Provided Production support and resolved maintenance issues. Performed Data Validations, Unit testing and prepared some Test cases.
• Designed and implemented various materialized views to support several views
• Performed Cognos administrative tasks including security, user accounts, software installations and deployments.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements.
• Worked on performance tuning of existing reports and models.

Environment: Cognos 8.4, DB2, Oracle 8, UML, Windows XP, UNIX, Informatica.

Confidential

Data Analyst

Responsibilities:

• Worked on both legacy data and new data mostly built around the user experience and grocery inventory available.
• Performed Data Analysis on target data after transfer to Data Warehouse.
• Developed and maintained sophisticated data warehousing systems by understanding overall business requirements, system architecture and data flow.
• Strong technical experience in using Oracle database design and development.
• Created design documents using Erwin Data modeler (ER diagrams) and MS Visio(Flowcharts).
• Created mappings to load data from source and target to staging, staging to reporting tables by applying business requirements using Informatica Power Center.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements.
• Created Multi-Dimensional cubes using Impromptu Query Definition (IQD) files in Power Play Transformer.
• Worked with ETL team for developing various mappings and workflows in Informatica as required by the design specifications.
• Created Projects, Models (layers, relations, cardinality, Query subjects, star schema and packages) and Published Packages using Framework manager.
• Developed unit test cases for the code developed using complex SQL queries.
• Displayed and explained results using Excel and Power point presentations.
• Involved in planning and execution of Unit testing and UAT. Involved in end client discussions to make sure UAT go through successfully.
• Documented all phases of project implementation for future reference and conducting KT sessions.

Environment: Informatica Power Center 9.1, Oracle 11g, Toad for Oracle, SQL, UNIX, Shell scripting, SQL developer, Erwin Data Modeler, Excel.