Professional Summary
SKILLS O Business Intelligence Analyst offering experience delivering cost-effective, high-performance technology solutions to meet shifting organizational demands. Astute technology-business professional translates operational needs into technical solutions. Mastery of analytics and reporting tools to provide insights in product design, flows and user experiences using data-driven philosophy. Over 10 years of experience in software development and management experience. Over eight years of Information Technology experience as an Architect, Administrator and Developer with expertise on end-to-end Business Intelligence solutions, data scientist, data analytics, reports development and experience in client- side project management, business user interaction in the industry of finance and Insurance domains. Extensive experience with Tableau Desktop and Tableau Server in Tableau 8.x, 9.x and 10.x as a Consultant Expert in design and deploy rich Graphic visualizations with Drill Down feature and Parameter. Experience with Micro strategy 9.4/10.2 Implementation setup which is a separate reporting environment. Experience working with Micro strategy Architect, Micro strategy Developer, Object Manager, Integrity Manager and narrowcast server. Experience in SAP Business Objects Development through versions Business Objects XI 3.1(R3.1) / XIR2/R1/6.x/5.x/5i/4.x and Xcelsius 2008 / 4.5 Experience in development of Universes, modified existing universes, added new objects to existing Universes and working on the procedures for the development of reports. Experience in data Analytics on different datasets on Fraud data and Key Indicators data to perform time series model, logistics, and regression models. Solid knowledge of Data Modelling, Star Join Schema modeling, Snow-Flake modeling, FACT and Dimensions Tables, Physical and Logical data modeling. Developing Tableau interactive dashboards to monitor KPIs related to Overages, Shortages and Damages etc.Extensively used advance chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems. Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau. Expertise in databases to include Oracle 10g/9i/8i/7x, MS SQL 2005/2000/7/6.5, DB2, Teradata, and MS Access Tuning reports, Tuning SQL, Tuning Universe for better performance. Perform analytics using Python, Pandas, matplotlib, seaborn, RStudio, SAS, and SPSS, as part of Data Science doing EDA techniques and modeling data to derive meaningful outcomes. Extensively used Multiple Data Providers such as Universe, Free-hand SQL, Stored Procedures and Personal Data Files for generating reports. Applied security design features of Business Objects, MicroStrategy and Tableau like row level, report level & object level security in the universe so as to make the sensitive data secure by creating Users/Groups/Sub-groups & assigning the privileges. Implemented Micro strategy objects such as attributes, facts, hierarchies and complex metrics that conform to the dimensional and De-normalized data models. Worked closely with the business to Gather, Review, Validate and Document the Business Requirements. Proficiency in performance tuning using VLDB properties. Excellent experience in Micro strategy and Tableau Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery, and Alerts. Extensive experience on all types of Micro strategy and Tableau Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups. Extensive experience in data visualization and data validating/auditing, web-based/flash MicroStrategy widgets and visualizations design and development. Business Intelligence Analyst offering experience delivering cost-effective, high- performance technology solutions to meet shifting organizational demands. Astute technology-business professional translates operational needs into technical solutions. Mastery of analytics and reporting tools to provide insights in product design, flows and user experiences using data-driven philosophy. Python: Hands on using libraries like NumPy, Pandas, Seaborn, Matplotlib, Spicy and Sklearn. Data Analytics: Pivot Tables, Excel Dashboards, Charts, Data Connection, Data Validation, Power BI, Tableau Databases: SQL Server 2008/2005, Teradata, Tableau Desktop 2021.x, Tableau Prep, Alteryx. SAP Business Objects 4.1, XI 3.1, R1/R2 6.5.x, Crystal Report 9/10/XI/ 2008/2011, Xcelsius 4.5/2008, Info view, CMC, CCM, CMS, BEx Query, BEx Analyzer, Desktop Intelligence XI, Full Client, Oracle 10g, 9i/ 8i, Access, SQL, PL/SQL, SQL, HIVE, Impala, Bigdata, Snowflake Web Intelligence, Business View Manager, SAP ECC O/S: Windows (all flavors), Unix and Linux ETL Tools: BO Data Integrator (ETL), Data Services, Informatica, Data Stage. 6.0, SAP BI/BW 7.0, Live Office, Architect, Object Manager, Integrity Manager, - BI Tools: Narrowcast server, Tableau Desktop, Tableau