Om Shrestha

OM K SHRESTHA Phone No- SUMMARY:  Over 12 years of experience in Business Intelligence Platform specializing in complete Microsoft Business Intelligence Stack, Azure Cloud Solutions, SAP BusinessObjects Suite of Applications.  Expertise in critically evaluating and screening data, plus profiling to identify any issues.  Good knowledge of Business Intelligence to provide ongoing refinement of processes to improve operations.  Took initiative in evaluating various tools, analyzed pros and cons and made recommendations.  Lead a team by setting up all necessary access and environment needed for a project and provided necessary support to team members.  Hands-on experience leading developers, providing feedback and direction on design and code reviews and development best practices.  Good exposure with big data technologies like Spark, Hbase, Sqoop, Hive.  Good understanding of Data Science and Predictive models.  Worked in collaboratively environment with colleagues and data scientist.  Good exposure in gathering business requirements and converting them to Functional and Technical Specification documents.  Over 10 years of experience in building dashboards with Dashboard Design 4.0/Xcelsius 2008, Tableau and Microsoft PowerBI.  Technical hands-on experience in designing SSAS Cubes (Tabular & Multidimensional), SSIS Packages (ETL), Business Objects Universes (Information Design Tool), Web Intelligence Reports, Crystal Reports, SSRS Reports, SAS Reports, Python Notebooks, Zeppeline Notebooks.  Expertise in Optimizing, Debugging, Tuning and Testing SQL queries, MDX queries, views, materialized views and stored procedures in Oracle, DB2 and SQL Server.  Worked on End-To-End Data Warehouse Implementation projects and have strong Modeling concepts like Star Schema, Snowflake Schema and Multi-Dimensional Models (OLAP, ROLAP and MOLAP).  Worked as liaison between IT and end Customers and provided consultative services to departments at various client locations.  Extensive knowledge of all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation) as well as migration and production support.  Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new environment and tools. TECHNICAL SKILLS: Business Intelligence Tools: Microsoft Business Intelligence Stack ( SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) ,PowerPivot, Power Query, Power BI, SharePoint 2013, Visual Studio 2017), SAS 9.4,Tableau, SAP BusinessObjects 3.1/4.0 Stack Operating systems: Windows 2010, LINUX/UNIX Data Base: Oracle, SQL Server, Teradata, DB2, iSeries, Azure SQL Database Servers: Tomcat Apache, Web logic 8. Languages/scripting: Python, C, C++, C#, VB, PL/SQL, T-SQL,MDX (OLAP), DAX, HTML5, .Net, JavaScript, JQuery, CSS,HQL. ETL Tools: SQL Server Integration Services (SSIS), Data Integrator. Big Data Tools: Hortonworks stack (Hive, Sqoop, Spark, Hue,Ambari) Page 1 of 4 OM K SHRESTHA Phone No- PROFESSIONAL EXPERIENCE Mayo Clinic, Rochester, MN Apr 2012 –Present Business Intelligence Analyst Responsibilities:  Worked with Business Analyst and End Users in analyzing, clarifying, proposing various alternatives to meet the reporting needs, following agile methodology.  Worked with team in identifying problems and involved in brain storming sessions to come up with new ideas. Also, visualized problem solutions, gathered information, analyzed various alternatives and sorted out best problem solution considering tight deadline and estimated hours to resolve the problem.  Provided timely and accurate estimates for analysis, design, development, testing, and deployment tasks for a reporting project where old source system was going to be replaced by new source system.  Worked on Microsoft Azure Cloud technologies with azure services like Event Hubs, Streaming Analytics, Storage blob, Azure SQL database and processed data received though API Interface for real time data analytics using Azure functions.  Worked on Readmission and Claims denial predictive model and prepared datasets for those models.  Designed SSAS tabular cubes, SSIS Packages, PowerPivot Models, SSRS Reports, Performance Point Dashboards, WEBI reports, universes (.UNX) using Information Design Tool (IDT).  Designed, recommended, developed and deployed a reporting solution for conversion project from SAS to Microsoft following company standards and best practices. Used SSIS packages for ETL development and automated generation of formatted reports daily. Worked independently with minimal guidance.  Designed and deployed SharePoint aspx page framework using JavaScript, JQuery, CSS to host SSRS reports and dashboards in SharePoint and granted access to required persons.  Developed Scorecards, Key Performance Indicators (KPIs) and created Event Triggers to schedule reports and dashboards.  Involved in migration of universe, web Intelligence reports and dashboard from Development to Integration to Production environment.  Validated ETL mappings, designed SSIS packages with complex data flows and tuned them for better performance and implemented various Performance Tuning techniques.  Involved with the ETL team while designing Data marts.  Managed work load across multiple projects independently and prioritized urgent needs.  Supported and maintained reporting and dashboards solutions in production.  Attended various webinar and training sessions to keep up with current technologies and develop new skillsets.  Good exposure to Epic data models like OpTime, Hospital Billing, Professional Billing, Cadence. InterContinental Hotels Group, Atlanta, GA Sep 2010 –Jan 2011 Business Objects Developer Responsibilities:  Interacted with Business Users and Managers to gathering business requirements for universe, report and dashboards. Provided consultative services to various departments by helping team analyze and predict various effective promotional campaigns.  Designed report and dashboard Standards and Best Practices documents and gave presentation to a team. Also created Technical and Functional Specification documents following company standards.  Participated in status meetings and prepared status reports when necessary - highlighting issues and constraints that would impact timely delivery of work program items. Page 2 of 4     OM K SHRESTHA Phone No- Created sales and operation universe from scratch as a part of decision making system in Enterprise Data Warehouse environment. Worked with DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down size of the result set. Worked independently in architecting and developing Direct Mail Promotion Dashboard for Hurdle Campaign using What-If analysis and Gross Booking Dashboard that measured leads and contacts for different marketing channels. Provided end to end solution, starting from the Universe, to the Web Intelligence report to the Xcelsius Dashboard. True Value Company, Chicago IL May 2007- Dec 2007 Business Intelligence Analyst Responsibilities:  Worked with multidisciplinary team members for evaluating Business Intelligence tools. Installed and designed POC environment for developing BusinessObjects reports and dashboards.  Involved in designing migration road maps with team and presented migration strategy to upper management. Played active report in initial phase of the migration from BusinessObjects 6.5.1 to BusinessObjects XIR2.  Assisted and improved data gathering process by ensuring data quality is met. Created dashboards and reports to communicate data points allowing for action to be taken.  Successfully utilized the Report Bursting feature of Business Objects through publication for scheduled processing and distribution of web Intelligence and crystal reports to users based on their profiles.  Involved in production support and resolved issues as per SLA and ETA. Bank of the West, Des Moines, IA Oct 2005- Apr 2007 Business Intelligence Analyst Responsibilities:  Involved in planning, designing and estimating man-hour for putting together a reporting solution for a credit card sales department.  Involved in gathering, analyzing, and documenting business requirements, functional requirements and technical specifications for designing semantic layer as well as reports.  Designed and developed BusinessObjects Universes, considering needs for standard, analytical and adhoc report.  Worked on multiple projects at same time and managed time efficiently, prioritized tasks to meet deliverables deadline.  Designed reports and hooked those report with .Net framework to pass parameters to sub reports. Created Templates for standardizing look and feel of Enterprise level reports.  Worked with ETL team in extracting required data from source system implementing business rules as per the reporting requirements.  Worked closely with DBAs to create aggregate tables to support BuisessObjects Universes and dashboard and enhance the overall performance.  Worked in a team environment to design Data Model/Architecture Components based on the user requirement for creating Web Intelligence Report (Webi), Xcelsius Dashboard. Satyam Computer Services Ltd., INDIA Jan 2004-Sep 2005 Page 3 of 4 OM K SHRESTHA Phone No- Report Developer Responsibilities:  Worked extensively with the end client to understand their needs. Participated in the analysis and design of application components, contributing to the team with appropriate technology solutions for client requirements.  Communicated proactively on various priority matters with other team members and team leads.  Developed Crystal Reports and formatted the same with respect to the requirements.  Involved in creating Test plans and Test Scripts for reports testing and test run in Quality Center.  Exported and managed reports on the server. Schedule the reports in various formats in Info view for recurring reports. EDUCATION: Advanced Certificate in Project Management and Healthcare Management Dallas Baptist University, Dallas TX Dec 2012 MBA with Management Information System Dallas Baptist University, Dallas TX Dec 2009 Bachelors of Engineering (Electronics and Communication Engineering) Jan 2007 Visveswaraiah Technological University, Bangalore, India Page 4 of 4