Bharath D
New York,NY
Summary
Experienced Data Analyst with 4+ Years in Software Design, Database Design, Development, Integration Implementation, and Maintenance of Business Intelligence
• Expertise in SQL 2017/ 2016/2014/2012 /2008 R2 with emphasis on design, development, automation, tuning, optimization, Performance, and Security.
• Experience in analyzing business user requirements, designing software solutions in Tableau Desktop, and converting Legacy Reports to Tableau dashboards.
• Proficient in SQL Server Integration Services like Package creation, Check Points Implementation, Dynamic Configuring of package, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, and Package encryption.
• Experience in creating reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in monitoring and tuning MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
• Expertise in creating complex SSIS packages, creating jobs, Alerts and scheduling SSIS Packages using SQL Agent, migrating data from different legacy systems to SQL.
• Hands-on in designing, maintaining and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS.
• Expertise in generating on demand and scheduled reports for business Analysis and Management decisions using SSRS 2016/2012/2008.
• Expertise in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS).
• Proficient in problem-solving and organizational abilities. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
4
4
years of professional experience
Work History
Data Analyst
FIS Global Business Solution Private
01.2018 - 06.2022
• Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping for advanced analytics initiatives.
• Created a Datawarehouse and integrated different systems data into the Wearhouse (Salesforce and SAP).
• Used Machine learning to convert different language text to English for analysis.
• Created various analytical dashboards using Power BI for quick insight of data.
• Converted Boulder Tables from Excel to Power BI for better graphs and visualizations.
• Collected Plants Data from different regions and combined them in Power BI.
• Conducted COPQ and DPPM analysis in Power BI.
• Translated data requirements to produce comprehensive, detailed data maps and canonicals.
• Identified supply chain problem areas and opportunities to improve service, reduce cost, and increase inventory turns.
• Performed ETL on multiple platforms such as SAP HANA and Teradata.
• Created and maintained Apps and Reports in Salesforce for Customer Issue Resolution and maintained different processes of CRM.
• Used BOXI (Business Objects) for creating reports for Legacy Systems.
• Mapped the data in different systems and documented them.
• Performed Queries, maintained and extracted Data from Teradata, cleaning and maintaining the Production Environment in Teradata for performance.
• Participated in daily scrum meetings to discuss challenges and development of the project.
• Extracted data for reporting from multiple data sources.
• Implemented Tableau for visualizations and views.
• Generated complex reports in Tableau using multiple functionalities.
• Created PowerPivot models and PowerPivot reports, published reports onto SharePoint, and deployed models into SQL Server SSAS instance.
• Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.
• Worked on Power BI reports using multiple types of visualizations.
• Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace.
Education
Master of Arts - Information Technology Management
Webster University
St. Louis, MO03.2024
Skills
- Business Intelligence Tools: Power BI Desktop, Power BI Service, Tableau, SSRS, SSIS, SSAS, QlikView, Salesforce Einstein Analytics Studio, Business Objects
- Data Warehousing & ETL: SQL Server 2016/2017, Teradata, SAP HANA, MDX, DAX, SSIS, BI Development Studio (BIDS)
- Database & Data Management: SQL, SQL Server, Microsoft Access, Data Analyzer, SAP Logon, XML
- Cloud & Data Integration: Microsoft Azure, Power BI Service Pro, Project Online, SharePoint, IBM Lotus Notes
- Programming & Scripting: Python, Visual Studio, TFS
- Reporting & Visualization: PowerPivot, Tableau, SSRS, Power BI, Custom Visualizations using R, Power Queries, Data Analysis Expressions (DAX)
- Operating Systems & Office Tools: Windows 10/7, Microsoft Office Suite (Word, PowerPoint, Excel)
- Agile & Collaboration Tools: Scrum/Agile methodology, TFS, SharePoint, MS Office
Timeline
Data Analyst
FIS Global Business Solution Private
01.2018 - 06.2022
Master of Arts - Information Technology Management
Webster University
Similar Profiles
Bhawna Bhawna null
Quality Supervisor at FIS Global Business Solution Private Ltd.Quality Supervisor at FIS Global Business Solution Private Ltd.
Vijayalatha ChandranVijayalatha Chandran
Senior Software Engineer at FIS Global Business Solution Private LimitedSenior Software Engineer at FIS Global Business Solution Private Limited
A Alaina TanaazA Alaina Tanaaz
Senior Product Support Engineer at FIS Global Business Solution PrivateSenior Product Support Engineer at FIS Global Business Solution Private