Business Intelligence Analysis
Resume:
Navatha Sudini
Cell:
Email: *************@*****.***
Sr. Business Intelligence Lead
Professional Summary:
Accomplished Sr.BI Lead/Manager with 16 years of experience in business analysis and reports/dashboards development. Specializes in partnering with stakeholders to methodically parse through business needs, perform detailed business analysis, and ultimately craft innovative and financially rewarding solutions. Impeccable consensus driven communication and analytical skills, coupled with development experience, ensure business requirements can be systematically translated into highly functional tools and deliver corporate level KPI reporting.
•Technical/functional expertise in complete software development life cycle process which includes Analysis, Design, Development, Testing and Implementation in the fields of Analytical tools (Tableau, Qlik View, Business Objects, MicroStrategy), SAP, Business Intelligence, ETL tools, Client Server Technologies and scripting languages(VB,C#,JAVA,R, Python etc.).
Experience in Tableau Administration for configuration, adding users, managing
Licenses, and data connections, scheduling tasks, embedding views by integrating with other platforms.
Deployment of Tableau Server in clustered environment and performing upgrades
Expertise in building business critical dashboards using advanced Tableau functionalities and played important role on fine tune data extractions by using Alteryx.
Worked on End-To-End implementation of Data warehousing with strong understanding of Data warehouse concepts of Star schema, Snowflake Schema and Multi-Dimensional Model in relation to query and analysis requirements.
Quantitative and qualitative market research, new ideas and good practice is shared
across the company to improve its capability and growth.
Strong functional Knowledge and Solution Architecture experience in financial, manufacturing, retail, pharmaceuticals and Immigration domains.
Experienced in Cloud technologies and performance tuning methods for different analytical tools.
Willing to learn new technologies/methodologies to provide efficient deliverables and help company growth.
Core Competencies
Business Intelligence
Business Objects / Crystal Reports/ Tableau / QlikView/MSBI/Power
Databases
Oracle / SQL Server / Teradata / SAP BW/SAP HANA/DB2/
Redshift / Big Data
SDLC
Project Management, Business Requirements, Business Requirements Analysis Business Process Improvement, Agile/Waterfall Methodologies, Lucidchart, Process Flow Diagrams
Programming
.NET (VB, C#, ASP), Java, PL/SQL, R, Python
Other
AWS, Azure, UNIX, LINUX, Windows, MS Access/MS Project/MS Visio, RFC, QTS, JIRA
Career Summary
Fragomen Oct’19 – Till Date
Business Intelligence Lead
Working as a BI solution Architect to implement/setup data warehousing environments and provide reporting solutions in Business Objects/Tableau/Crystal/SSRS environments.
•Managed End to End Reporting solutions in Data Modelling/ETL/Reporting which includes requirement gathering, creating functional/technical docs, design/develop/User support.
•Mentor and guide the offshore and onsite teams.
•Heavily involved on Reporting/data migration from Existing SAP environment to Tableau.
•Worked closely with product owners, Client Services Managers to understand the existing their current reporting structure, gaps, created consolidated flex field architecture.
•Heavily involved in re designing of DWH components, ETL Process, validation techniques and quality checks to make sure all the data base and reporting components are migrated correctly.
•Implemented in installation of Tableau Application Installation, configuration, SAML SSO setup, user Security across key business functions and version upgrades.
•Designed business process, database models using Lucidchart.
•Designed/Developed complex dashboards, fine-tuned performance, and data issues.
•Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.
•Created workflows to Pre-Process the data for reporting/dashboards using Alteryx and SSIS packages.
•Created custom ETL batch triggers for dashboards, user groups by using Python scripting on Tableau Server.
Environment: SAP BI 4.3, Tableau 2020/2023, Crystal Reports, Microsoft SQL Server 2016, SSRS/SSIS/SSAS 2012, Python
Siemens Financial Services Iselin NJ Jan’18 – Apr’19 Business Intelligence Manager
Working as a BI solution Architect to implement/setup Reporting environments in Business Objects/Tableau/AFO environments and ownership of reports/dashboards end-end implementation for Siemens Leasing business. (InfoLease – Cassiopae)
Analyzed exiting Application and Reports and Cleanup 60 % of the reports and consolidated new specifications by interacting with many departments (Asset Management, Risk, Portfolio, Accounting...)
Heavily involved on Database migration from Existing SQL environment to Oracle
by preparing consolidated unique field list from both Application and Reporting environments.
Designed and implemented strategies and roadmaps for BI and Analytics solutions.
Worked closely with Product Vendor to bridge the gap between Old and New Interfaces and played key role to do Filed mapping to setup Data Lake.
Implemented Site SAML authentication, Custom batch scripts using Rest API’s to achieve out of the box solutions in Tableau like Custom Security, Trigger based schedules, run the heavy data sources locally and publish back to server etc.
Improved ETL load process time by using Alteryx on heavy data extracts.
Worked on End to End Implementation of Reports/Dashboards design/development/UAT/Pre-Prod and created key business driven dashboards.
Worked on data extractions from Oracle to DDW/HANA/SAP BW environments.
Mentor the team in providing optimal solutions, overcome technical/strategical challenges and meet the GO LIVE CRITICAL deliverables deadlines in timely manner.
Environment: Tableau 2019.1/10.5, BI 4.2, Alteryx, AFO, SSRS/SSIS/SSAS 2012, Oracle 11i/12c, SAP BW, HANA, MS Visio, Info Lease, Cassiopae
Pfizer, Peapack NJ Nov’15 – Dec’2017
Business Intelligence Lead
Responsible for leveraging existing business intelligence and analytic assets to successfully integrate the company's BI operations cross all company departments.
Business Intelligence Lead
Responsibilities:
Interacted with Business Users/Stakeholders/MSBI team to understand the business requirements.
Developing strategies and roadmaps for BI and Analytics solutions.
Compiling & delivering business intelligence reports to end users on a regular basis and Rolling out BI solutions to end users.
Conveying technical information clearly, accurately and convincingly through speech and/or writing.
Created project plan/design for reports migration from SSRS to Business Objects and
Tableau.
Created Functional/Technical/UAT Signoff/Deployment / Process Flow documents by subject area.
Analyzed existing MSBI Cubes and reports and Re-Design/Develop new
Universes/Reports to replicate the reports in Tableau/BO environment.
Involved in installation and configuration of Business Objects/Tableau Software. Implemented permission rules to control access to specific content on a site
Created extracts, published data sources to tableau server, refreshed extract
in Tableau server from Tableau Desktop.
Developed Tableau data visualizations using cross tabs, Heat maps and different interactive dash boards.
Lead/Mentor the development team to complete the migration project as per the
Project plan.
Created business critical reports for US Trade Group/Greenstone/Injectable business
Areas.
Coordinated with business/dev/MSBI/Application Owners to resolve UAT issues, provided alternate solutions (in some cases) and completed UAT phase in the given timelines.
Worked with SAP team to check the feasibility of out of box solutions/Alternate solutions on BO Servers.
Environment: BI 4.1, Tableau 10.3, Alteryx, QlikView 11, SSRS/SSIS/SSAS 2012, Oracle 11i/12c, MS Visio, QTS.
Cognizant Technologies Aug’14 – Nov’15
Business Intelligence /Tableau Architect
Project 1: JPMC NY
Responsibilities:
Interacted with Business Users/Stakeholders to understand the business requirements.
Providing analysis and insights to senior management on metric development and variations.
Lead/Coordinated with Planning/BO administration/Stakeholders/Release Management teams and successfully migrated Business Objects/Crystal Reports in BI 4.1 environment.
Created Tableau dashboards related to Global Investments/Private Investments/Overdraft/Pipeline Reports to asset management group.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand, required information.
Trained users in Analytics/Traditional reporting tools.
Project 2:
Credit Suisse NY Responsibilities:
Interacted with Business Users/Operations team to understand the existing excel based and business objects reports.
Created FSD’s, POC’s, hand over documents for IDT based Universes and reports.
Played a key role in the project and coordinated with JAVA/DB/ETL teams to create “Manual Upload Tool”, improved performance of BO reports and automated manual efforts in various levels.
Consolidated different source systems information into business oriented KPI’s.
Used Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis.
Developing predictive statistical models using statistical analysis and other predictive
modeling techniques.
Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.
Prepared project plan, coordinated with onsite/offshore teams and provided deliverables
in a timely manner.
Created highly critical business reports related to trade volumes and fails using Tableau.
Created data request templates for different front office teams and captured the data into DWH.
Coordinated with DEV/QA/UAT teams and helped in resolving the defects.
Environment: Tableau 9.0, BI 4.1, Business Objects XI3.1, Crystal Reports, Informatica 8, Oracle 11g, JAVA, Tableau 8.0, MS Excel 2010, JIRA
Citi Group, Warren NJ Oct’11– Mar’14
Sr.Business Objects Developer
Citigroup business offers a wide array of investment and corporate banking services and products for corporations, governments, institutions and high-net-worth investors.
Responsibilities:
Implementing a business Intelligence strategy within a global network.
Ensuring that all BI projects successfully delivered on time to the required professional standards.
Working closely with key stakeholders to gain a real understanding of a company's
needs.
Created functional and technical documents.
Lead and coordinated with offshore team and provided deliverables in a timely manner.
Analyzed database tables and designed universes and reports.
Created high visible Qlik view dashboards for Asset Based Loans, Securities Based Lending, Stock Loans data and portfolio tracking systems.
Environment: Tableau 9.0, QlikView 10 SR3/11 SR1, Crystal Reports 2008. Business Objects XI3.1/XIR2, Oracle 10g/11g, SQL Server 2005/2012 Management Studio
Apple, Cupertino CA. Mar’10 – Sep’11
Sr. Business Intelligence Analyst
iTunes Reporting: iTunes Reporting is provide the reports to different business groups like Music, Movie, TV, iBook’s for different platforms iPhone, iPod, iPad, Windows, Mac.
Responsibilities:
Performed Business Analysis Requirements planning to determine the best techniques and methodologies to utilize on the project. Collaborated with project executives to identify project scope, deliverables, stakeholders and timeline, in order to clearly communicate Business Analyst commitments and establish a Business Analyst contract with IT and business stakeholders
Worked closely with the Data Architect Team to ensure the implementation of Business Logic/Rules in the ETL Process.
Developed use cases and screen mockups to be included in dashboards/reports design
document, which allowed stakeholders to provide more detailed input into the reports design and manage expectations.
Communicated with different business groups & provided required reports from
different source systems.
Environment: Business Objects XI3.1, Crystal Xcelsius, Tera data 12.00, SQL Work Bench Oracle 10g, Netezza, SAP-BW3.5, Omniture Reporting tool.
Stanford University, Palo Alto CA. Feb’09 – Feb’10 Sr. Reporting Analyst/Developer
Stanford Student Housing is a customer resource management system that will assign students and guests to housing locations; create contracts; process all housing, dining, and miscellaneous charges for residents; and perform related support functions for units within R&DE IT.
Responsibilities:
Interacted with Business Users to gather the requirements and Business logics/Rules.
Designed Functional Specification for report creation.
Worked with the StarRez (Third Party) to analyze the gaps (Gap Analysis) between the StarRez Customized product and the user requirements.
Extensively created hyperlinked reports with more than two levels.
Worked closely with the Data Architect Team to ensure the implementation of Business Logic/Rules in the ETL Process.
Analyzed business process workflows designed and developed ETL procedures for
moving data from source to target systems.
Analyzed the warehouse tables, SAP-BW warehouse to design Universes and reports.
Environment: Business Objects, StarRez V8, Oracle10g, Toad, SQL Server 2005, Performance Manager, Merant Version Manager (PVCS).
Genentech Pharmaceutical. SFO, CA. Oct’07 – Dec’08 Business Objects Developer.
Genentech is among the world’s leading biotech companies, with multiple products on the market for serious or life-threatening medical conditions. Using human genetic information to discover, develop, manufacture and commercialize bio therapeutics that addresses significant unmet medical needs.
Responsibilities:
Interacted with Business Users to gather the requirements and Business logics/Rules.
Designed Functional Specification for report creation.
Worked closely with the management to assist in the project status.
Designed architecture & set up for development, production & test repositories.
Designed Universe, Reports using SAP-BW as source System.
Updated and maintained Universes based on changing user requirements and data source changes.
Involved in the design and development of various mappings, mapplets to implement the business logic using different transformations like Aggregator, Connected and Unconnected Lookups, Update Strategy and Stored Procedure.
Environment: Business Objects XIR2/ 6.5, Oracle10g, Toad, Clear Case V7.0, and Citrix Server.
Certifications
Business Objects Enterprise XI Certified Professional.
Education
B. Tech from JNTU, Hyderabad, INDIA
Contact this candidate