SUMMARY

• Working last twelve plus year s data engineering and analytics life cycles at various level of confidence to meet the target goals
• Data management closely worked in the areas of relational, dimensional star and snowflake schemas in the areas of Data warehouse, data mart and operational data repositories using Kimball and Inman standards.
• Data engineer services designed, developed, tested, and maintained data ingestion principles including architecture target - scale data loading strategies, incorporating CDC and SCD business processing capabilities for various incoming data feeds not limited to xml, JSON, real time API interfaces and multiple delimited data file formats
• Data analytics services gathered business data use case stories, produced design aesthetic visuals, scorecards and dashboard to meet the final deliverables to decision and operative end users. Cleansed, massages, and organize quality data big and complex data sets. Performs descriptive statistics and analysis to develop insights, build the models, and solved business use cases
• Team work - highly proficient in communicating and gathering business use cases story telling for data ingestion, data analytics use cases. Proven documentation skills and socializing the requirements. Flexible to work in individual as well as team environment

TECHNICAL SKILLS

• Hands on SQL Server and Azure SQL, Oracle Schemas, PL/SQL, SQL, T-SQL
• XML, JSON, and Delimited Files Performance Tuning and Optimization
• SSIS - Split, Derived-Columns, Script Tasks, Lookup and Data Conversions, Merge, Multi Cast, Union All
• SQL, Materialized and Static Views, Stored Procedures, Functions and Triggers, Indexes, Partitioning and Package Designs, Aggregate and Analytical Functions

PROFESSIONAL EXPERIENCE

Confidential

BI Analyst

Responsibilities:

• Worked closely with the Business users, Product Team and Enterprise architect team to understand the necessary data points that needs to be incorporated into Data Lake.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic.
• Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
• Created database objects like tables, views, procedures, triggers and functions to provide definition, structure and to maintain data efficiently.
• Created complex stored procedures to perform index maintenance, data profiling and staging operations for loading into the staging area and as well as into the production area.
• Analyzed the requirements and their usage for different reporting purposes using Power BI.
• Used M-scripting language in Power BI to prepare the data and to transform the data as per the business requirements.
• Worked on developing M scripts to change the data source from Excel source systems to On-premise source systems without affecting the dashboard visuals.
• Used Time-Intelligence, Information, Logical, Math and statistical functions in Data Analysis Expressions (DAX) to generate visuals in a more astute fashion.
• Created solution driven Power BI dashboards by using different chart types like Time series charts, Heat Maps, ArcGIS Maps, Donut/pie Charts, Dual axis charts, Line/Area Charts, Scatter Plots, Stacked 100% bar charts, Chicklet slicer.
• Used advanced data visualization components in Power BI like actions (Highlights, URL), parameters, Filters (Local, Global) to quickly identify key themes, KPI’s within the data.
• Developed effective and interactive Dashboards using Parameters and Actions and provided Dynamic Row level Security to make sure the end user has restricted visibility using the user-security table in the on premise back-end environment.
• Installed Enterprise-level gateway and User-level gateway for end users to work on in Power BI online services to automate the Data refresh process. Also automated Power BI reports that are pointing to Azure database and SharePoint sources.
• Published the reports to Power BI service for navigating the developed dashboards in Power BI Online services.
• Developed an application that reads the data from the SQL Server database objects and has the capability to perform Data Edits using Power Apps tool
• Used collections in power apps and used those fields in the app by enabling or disabling fields, validated the data by showing error messages.
• Created Flow using Power Automate that connects the app with database by creating variable and restricts data by passing SQL query to last 14 days in the flow and later used the generated flow variable in power app user data entry interface.
• Provided security to the developed apps by creating a startup screen that points to the security view that has organizational Microsoft email accounts mapping with respective logged user email ID while using apps.
• Used Sentiment analysis feature in Power BI to understand the Customer comments that are generate from egov.com to predict amount of customer service that needs to be provided for a certain region
• Mentored business power users to create reports/dashboards using Power BI online services and assigning Row Level Security to the Business users.

Environment: Power BI (Premium Capacity), Power Apps, Power Automate, SVN, M- Scripting, DAX-scripting, Oracle SQL Developer Data Modeler, Excel, SharePoint, ServiceNow, Teams, Azure SQL Database, Azure Machine Learning, SQL Server 2016,SQL Server Integration Services (SSIS), SQL Server Management Studio, PLSQL, T-SQL, R-Programming.

Confidential

Sr BI Analyst

Responsibilities:

• Built the data engineering services from raw data extraction to transformation using MS SQL Server Integration Tool
• Worked in the multiple data mart environments which supports Star Schema with multiple reusable dimensions and facts
• Parsing high-level design specification to simple ETL coding along with mapping standards.
• Profiled and compiled multiple delimited, xml, and JSON format file data into SQL Database
• Extensively used different control flow tasks like Execute SQL Task, Execute Package Task, Web Service Task, SFTP, For Each Loop, Script task etc.
• Created web service methods using C# and configured web API in IIS and used in the SSIS package using web service task
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP SAP SS and MD databases
• Incorporated transformation logic using various SSIS tasks data conversion, conditional split, bulk insert, merge and union all
• Wrote the Field Validation scripts to check reference file error records and on -error, will attach error file through send mail task, along with error filename based on source to target mapping requirements
• Processed Key Value pair data, aggregated data at various time intervals and other dimensional capabilities
• Re-engineered PL/SQL procedural programs into T-SQL and SSIS Package Design and Development
• Developed Dashboards, Analytics, Canned and Drill-Down and Drill-Across reports
• Wrote the business use cases for migration and data visuals requirements
• Responsible for standardizing aesthetics of visual representation and dashboard story card telling process
• Converted all canned and operational business ad-hoc exploratory reports into Power BI visuals and dashboards
• Migrated SAP BI Business Objects interactive analysis 30 reports into Tableau visuals and dashboards
• Designed and developed reports using time intelligence calculations and functions to meet DTD, MTD, QTD, YTD metrics
• Performed designing, developing, debugging and testing of reports in multiple platforms (Tableau, Power BI and SAP BO)
• Constructed on-demand, summary and sub-reports, dynamic grouping, cross-tab data grids
• Created advanced chart types, visualizations and complex calculations to manipulate the data.
• Created measures, custom calculations, computed columns and computed tables in Power BI by using DAX functions
• Developed compelling, interactive reports and dashboards using different features like filters, parameter, actions, calculations and formatting the reports and dashboards by enabling the features like layout containers, annotations, mark labels installed and configured Enterprise Gateway and Personal Gateway in Power Bi Services to refresh data dynamically
• Acted as a point of contact in data interoperability, analytics and BI services at Production support environment
• Troubleshoot the poor response and performance dashboards and visuals and optimized underline data query patterns
• Supported automation process by incorporating admin tasks, publishing workbooks, setting permissions, managing ownerships, providing access to the end users. Implemented dynamic row level security in the visualization tools
• Trained and supported business users on tableau and Power BI self-service model for creating their own custom dashboards

Environment: Business Objects 6.5.1/ XI R2/XI R 3/ 4.0/ 4.1/4.2 (CMS, CCM, CMC, Dashboards, Crystal Reports, Web Intelligence XI R2/XIR3), BCA 6.5.1, SQLserver2005, Windows XP, MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Toad, Tableau 10.4,10.1/9.x/8.x, Power BI, QlikView.

Confidential

Sr BO/Crystal report Developer

Responsibilities:

• Developed Universes, Analytics, Canned and Drill-Down and Drill-Across reports
• Created functional requirement specifications through end-user meetings and analysis of business requirements. Involved in complete development lifecycle, including analysis, design, build, and test.
• Installed and configured the Reporting environments for development, Quality Analysis and production control.
• Designed client centric reports based on the request from the clients like Macys & Toyota, Etc. to show there MTD, QTD, YTD usage metrics in related to their rewards programs.
• Designed and implemented the Security model (Row/Object) on different reporting systems using Windows AD to hide certain objects and rows from certain users and user groups.
• Involved in Import, export of metadata to facilitate data exchange between different tools (openness). Designed and established a metadata-reporting environment
• Designed reports in a way using Business Objects Web Intelligence, Deski both to provide the self-service access to users on the information and data to turn business insights into effective decisions.
• Developed Finance Dashboard for capturing various Metrics, such as Sales, Product, inventory, performance. used goal management and scorecard to shows performance of metrics and KPI against given target and it included actual, variance, trend, and target value
• Developed and deployed data integration solutions for the contract information group by using SSRS reports with cubes utilization.
• Trained and supported business users on BO self-service model for creating their own custom Reports and scorecards

Environment: Business Objects 6.5.1/ XI R2 (CMS, CCM, CMC, Dashboards, Crystal Reports, Web Intelligence XI R2), BCA 6.5.1, SQLserver2005, Windows XP, MS SQL Server2005/ 2008, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Toad.