SUMMARY

• 12+ years of experience in delivering solutions for reports and visualizations using BI Analytical tools and relational & data warehouse system databases and Hadoop infrastructure with front end integrations with portals and with good knowledge in overall Systems/ application landscape
• Facilitated successfully several end to end BI implementations and development during all the phases Full development life cycle (SDLC) of the project life cycle and product life cycle using Agile, Scrum, Waterfall methodologies for BI developments and implemented ITIL best practices and has a good understanding of PMP Concepts, TOGAF framework and other lean six sigma
• Accountable for client relationships and served as the primary point of contact for BI Analytics delivery needs collaborating with leadership to ensure project expectations were met or exceeded for initiative including solution implementations, services delivery, research
• Experience wearing multiple hats as a with hands on experience as a Tech lead, BI Architect, Project Manager, Business Analysis, Business Analytics leading cross functional team with dedicated resources, off shore team and prioritized, scope, high level estimates and managed teams using HP PPM, etc. as a team member and working independently.
• A self - motivated & self-directed person with Excellent Communication, Analytical, interpersonal & Collaboration skills along with proven ability to multi task & work under Tight Schedules

TECHNICAL SKILLS

• BI Development
• Administration installations
• Deployment
• Upgrade
• Migration
• Implementation
• Deployment
• Architecture
• Configurations
• Monitoring and Performance Tuning
• Troubleshoot
• Data Analysis
• Data Engg
• BI Assessment
• Strategy
• Service delivery infrastructure
• Operations
• Data Analysis
• Data Engineering cloud computing (SaaS, IaaS, PaaS)
• Big data
• Web servers load balancers and high availability
• Object Oriented Programming

PROFESSIONAL EXPERIENCE

Sr. BI Visualization / Analytics

Confidential, Nashville, TN

Responsibilities:

• As a Marketing BI App Lead, Owned and managed all changes to BI / EDW to support CRM / Customer Master Data, Loyalty programs and responsible for delivery of reporting solutions to aid in self-service reporting using BO, Tableau, Power BI
• Supported to plan the optimal way to report on KPI s, performance metrics and Modelled and supported universes using IDT and UDT, EDW. Integrated multiple data sources for Marketing, Finance, Omni Channel, Loyalty, Tax, e-commerce.
• Created & delivered complex dashboards, user stories, apps, sheets for Visualizations need using Tableau, Power BI, SAP Lumira
• Analyzed, Designed, Developed and tested ad-hoc and canned Summary & detail Webi & CR reports and dashboards.
• Administered all BI Systems and Upgraded BO & Tableau. Also, collaborated with various stakeholders for performance tuning and provided architectural and strategic direction for the use of BI tools & products
• Anticipated risks and issues, escalated to senior management & performed resolution, data analysis, data profiling, data massaging, data mining, GAP analysis, Support QC initiatives work with Cross-functional and offshore teams.
• Liaison between business & IT to solve complex challenges and gathered business and technical requirements.
• Trained Users and Interviewed candidates for recruiting and hiring needs. Led & Managed Offshore resources for BI needs
• Partnered with DWH, DI /ETL, Arch Governance/ Data science teams to aid in Planning & Implementation using new technologies such as Tableau, Power BI, Alteryx, Snowflake to support Enterprise BI Analytics needs in Cloud and integrating with SAP BOE.
• Improved process and efficiency, automated, identified problems & enhancement opportunities recommending best practices and defined strategy and road map, negotiate changes across business and IT.

Environment: Tableau, Power BI, Qliksense, IBM Cognos, SAP Business Objects Webi, Crystal, Lumira Discovery, Designer, Dashboard, R, Python, Google Analytics, Qlik, Data bricks, Snowflake, Alteryx, R, Python, IBM Watson Analytics, Big data, Analytics AWS, Azure Microsoft Office suite(Project/Visio), SQL Server, Netezza, Oracle, SAP HANA, ECC, ERP (SAP FI CO, MM, CRM Mongo DB, Databricks, Informatica/ SAP BW, BODS, Service Now, JIRA, Confluence, Project/Visio, Science Logic, Apache/Tomcat, SAP Net viewer portal, Azure, Aws Redshift, Windows, Unix

BI Visualization Consultant

Confidential, Washington, DC

Responsibilities:

• Elicited requirements, Represented BI in ceremonies & Advocated agile methodology Kanban/ Scrum
• Delivered Visualizations using Tableau & supported, integrated with BI & front end tools

Environment: Tableau, SAP BO, Lumira, Dashboard Design, Google Analytics, JIRA, SQL Server, Oracle, BW/HANA/ ECC

Visualization Consultant

Confidential

Responsibilities:

• Received Client Appreciation for POC s, introduced & integrated PBI to MSBI suite & SAP BOE by C level s.
• Responsible for delivering dashboards & administering with Power BI (Modelled, Published and managed Gateway connections) and Supported BI initiatives for Client s auto & retail product needs and recommending best practices.

Environment: Power BI, MSBI Suite (SSRS, SSIS, SSAS), Jasper reports, Qlik, Tableau, SQL Server, SSRS, SSIS, SSAS, Big Data, Azure, Windows

Enterprise BI Analyst/ Sr. BO Developer

Confidential, Union, IL

Responsibilities:

• Delivered & Supported end to end design and development of all enterprise reporting & analytics solutions in Full SDLC for various Business Groups Finance, Member Services & Ops such as for General ledger, Accounts payable, receivable, Debit cards.
• Communicated with internal business partnered independently to identify and scope out business requirements.
• Ensured integrity of reports and content, Performed data analysis. Interpreted data for trending and decision models.
• Worked with data services & DWH team for, Identification and extraction of data to manipulate/calculate/format into reports
• Anticipated risks & issues, escalated it to facilitate decision-making to balance business needs Vs tech constraints.

Environment: SAP BO, Tableau, BODS, BI Clever, Oracle, MS SQL Server, MS Office Suite, Windows

Senior BI/BO Lead Developer/Architect

Confidential, NJ

Responsibilities:

• Extensive experience in BI, BO, and Analytics in development, integration, and administration with BI, Analytical, Visualization tools using structured and unstructured data; also performed end-to-end implementation in full SDLC
• Led BI Applications and System-related activities & Manage the Business Objects Queue in ticketing system and responded to any user requests.
• This included work on promoting or migrating objects across environments and to production and post-production support.
• Responsible for leading and insight and strategy or guidance to the dev team.
• Performed BI product evaluations, estimated BI effort, and created project plans
• Elicited business, data, and systems requirements as well as created BRD, FRD, Technical specs, Architecture documents and shared with CIC, COE, and conducted workshops as well as JAD sessions.
• Performed POCs for Analytics Reports Presented technical and non-technical BI findings in various meetings actively for different users for SAP and non-SAP tools. Responsible for the creation and defense of business cases for information delivery implementations, working in partnership with the business sponsors.
• Designed and developed several reports for various Business Groups, including Finance, Sales, Procurement, and Supply Chain, FICO (Profitability and Costing)
• Used Webi Reports, Crystal Reports, and Universes IDT, UDT (OLTP& OLAP) & integrated Multiple sources
• Established connections to data sources for reports and Universes including Oracle, SQL Server, Microsoft Dynamics CRM, SAP BW, HANA, Google Analytics, MS Access, and MS Excel
• Created Visualizations, dashboards, Created apps, sheets & responsible for end-to-end implementation
• Created Tableau User stories, calculations using Level of Detail (LOD), data blending, Action filters, parameters, used sets and mapping and published (TBX) files.
• Used several power bi features, like time intelligence, intelli sense. Also, Developed Qlik Sense dashboards
• Updated & demo s using SAP Lumira, Design Studio and Dashboards, AOF utilizing CSS and JavaScript
• Used MS Excel extensively & knowledge of VBA, Macro s with Pivot Tables, VLOOKUP’s, SUMIF s, index, match functions, graphs, and DAX functions.
• Led data analysis, data mining & data modeling for BI/ data warehousing needs
• Explored data to identify patterns and relationships as well as forecast with good understanding of dimensional modelling
• Aided in the design of reporting mart using dimensional modeling within the BOBJ environment, BW, HANA, EDW, and staging area to support the universes and BEx queries, Query Designer, and Analyzer.
• Supported BODS and Informatica; worked with ETL team to assist with the population of the reporting mart and integrate Info view into a portal. Used BW HANA architecture and modelling experience with BW on HANA and BW 7.X.
• Planned and implemented BOBJ Landscape and collaborated with various stakeholders, such as architects with COE team; provided architectural and strategic direction for the use of Business Objects products suite.
• Responsible for leading Administration for Business Intelligence platform
• Creating logins, granting/denying permissions, and other security issues in Qlik Sense management console; also, responsible for creating and managing connections to different data sources.
• Configured, managed, and monitored the SAP Business Objects with BW/Hana, BODS, SAP BO Planning, Crystal Server, Qlik Sense, Tableau, and Info sol across different environments consisting of 25 servers.
• Installed Configuration Analytics tools, like BO 4.1 and BO 4.2 Product Suite, Qlik Sense, and Tableau, in DEV, QA, and Prod environment; responsible for design and development of visualizations and administration as well as provided prod support.
• Designed security and led re-design of security effort for users and user groups.
• Applied data level restrictions for report and universe objects for Oracle DWH and Bex queries.
• Managed BO/BW security design as well as set up roles, system/object/analytic privileges, application/packaged privileges, user management, and transports. Troubleshot authorization issues.
• Responsible for Authorizations, Privileges, Rights on Roles, Users, and Authentication SSO using Windows AD, and SAP SSO.
• Also used and implemented a 3rd party tool 360 suite.Configured report bursting, scheduling, and publications using 3rd party tool Info Sol/Info Burst platform and Business Objects CMC.
• Led and performed upgrade from Crystal Reports 2011 to Crystal Reports 2013 and BOBJ 4.0 to 4.1 and 4.2 clustered environment and responsible for platform architecture.
• Initiated, proposed, and led Implementation of DR Recovery services for BO Servers. Implemented high availability landscape for BO cluster.
• Designed fully clustered and redundant BI4.0/BI4.1 system to ensure high availability of BOE web applications.
• Troubleshot and resolved the issues faced by end users and application teams related to BO, Qlik, webservers, Load Balancer, DNS, and SSO using Site Minder.
• Experience in integration of Business Objects systems with SAP BW, HANA, Hadoop, and WebLogic Portal
• Trained and mentored team and users for new features and functionality. Establish training program for various users (both technical and non-technical language).

Environment: BOBJ 4.X, Power BI, Tableau, Qlik Sense, Crystal Reports Server, BO iPad, Mobile, Explorer, Design Studio, Lumira, Qliksense, Spot fire, MSBI(SSRS), BO Planning, BODS, IS, Aws redshift, Azure, BI 7.X, SAP HANA, BW on HANA, HANA Live, ECC, CRM, Supply Chain, SAP ERP, SAP FIORI, 360 Suite, Power Shell, Microsoft Dynamic CRM, Google Analytics Salesforce, Oracle, Infinium, HPALM, SDM 12.X, Info sol Info burst, APOS, Internet Information Services (IIS), WebLogic, Windows, UNIX

BI Lead Dev /Admin /Architect

Confidential, NY

Responsibilities:

• Managed multiple reporting applications to aid in Project Management/Applications Service Delivery tasks.
• Delivered several end-to-end solutions as well as generated canned, ad hoc, self-service visuals and data discovery
• Aided, developed, tested, and implemented dashboards as well as created user stories, views, apps, sheets, and dashboards for Visualization needs using Qlik Sense, Tableau, and Xcelsius according to full SDLC.
• Built several Business Objects Universes (Semantic layer) and created multiple custom hierarchies for several groups to provide drill across functionality using derive tables, views, and aggregate tables built in composite from multiple data sources for information management systems using UDT and IDT.
• Addressed chasm trap & Fan Trap using Multi Parse SQL & Resolved Loops using Aliases and Context.
• Worked extensively with (@functions (@select, @prompt, @where, and @ aggregate aware for performance optimization) in designer and created optional prompts; created objects using complex case functions.
• Delivered and developed Webi reports and Crystal Reports using Standard, Summary, and Cross Tabs and Grouping, conditional formatting, Sub reports, Parameters/Prompts, Formulas, Report Alerts, OLAP grids objects, Cross-Tab objects, OLE objects, Charts/Maps, Running Totals, and Linking Tables.
• Developed and tested various Business Objects Reports involving numerous prompts, filters, open doc functions, drill downs, drill by, charts, and custom formulas to calculate the percentages and summaries based on the group levels and formatted reports, using product functionalities (i.e., alerted, sorting, and ranking)
• Created HANA views and Composite model for reporting, data modeling connected to Big Data systems
• Developed and managed multiple information delivery projects and deliverables in parallel.
• Responsible for Business Intelligence deployment and tracked project progress, feasibility analysis. Managed a team of 5 team members; worked with offshore team to support BI Technology Stack for Decision Support
• Provided guidance, training, and mentoring as well as conducted knowledge transfer/transitions to client on BO Info View Reports, rich clients, and dash boarding tools.
• Responsible for the execution of projects and managed the work done by external vendors.
• Responsible for eliciting needs & Facilitated requirement gathering sessions using techniques, such as Facilitated Joint Application Development (JAD) / Joint Requirement Planning (JRP); performed gap analysis, workflow, process diagram and derived requirements for existing sys enhancements.
• Wrote business and specification documents BRD, FRD, use cases, scenarios, unit, system, Business Process Maps/Flows, including AS-IS (current) and TO-BE (future).
• Owned and Managed BI Systems consisting of 5000 users and 12 servers and
• Established Monitoring and Defined and documented operational control and security procedures, for backup and recovery; provided 24/7 Production Support monitoring and starting servers, processes, and connectivity
• Performed Administration/Web Clustering/Portal Integration/ Upgraded from BO 3.X to 4.X
• Collaborated with architects and application developers to address product bugs and deliver major and minor \ enhancements; worked with vendor support SAP to provide custom solutions.
• Established best practices and approaches as well as planned roadmap and strategy for infrastructure design and implementation tasks, Disaster Recovery for existing/new releases and Software updates for BO, Tableau, Qlik
• Contributed for data or content governance and standards and templates for reporting systems to ensure synchronization across various applications.
• Facilitated and collaborated to work with infrastructure personnel, 3rd party vendors, and SAP to aid in negotiating contracts to expedite project delivery.
• Successfully lead Migration of BI content across different environments. Implemented and redesigned security matrix in admin console; created access levels for users and applied restrictions on contents.
• Implemented Row level restriction for manager’s profiles using Designer.
• Scheduled and managed security, jobs, authentication (SSO, Windows AD, LDAP) and authorization in the CMC for more than 5,000 users. & Configured auditing, created audit reports for compliance, and used query builder to track the Business Objects system usage metrics and perform BI Content cleanup.
• Managed licenses as well as proposed and implemented Auditing policies for BI BO Reporting
• Responsible for Performance Tuning and Query Optimization of BI platform.
• Responsible for Architecture Assessment Analysis (Sizing Analysis), Scaling, and Performance Tuning Business Objects environment according to SAP Best practices. & Collaborated and provided architectural and strategic direction. Analyzed usage and recommended modifications for BI systems.
• Created and monitored monitor daily and weekly schedules, publications, and program jobs; worked with Enterprise scheduler.

Environment: Business Objects XI R 3.1/ 4.1, SAP Lumira, OBIEE, Oracle Suite, Tableau, Power BI, Solution Manager, SQL Server, Oracle, DB2, SAP HANA / BW, SAP ECC, Golden Gate, SharePoint, Rational Software Architecture, Erwin, SVN, CVS, IAM/OIM, HP Quality Center ALM, Informatica, CA ESP Enterprise scheduler, Informatica, Salesforce, WebLogic, Data Stage, BPM, Java, T-SQL, PL/ SQL, HTML, DHTML, CSS, Java Script JS, and PHP, Java / .Net framework, PPM, ITM Software Remedy, Big Data Hadoop, Map Reduce, HDFS, Hadoop Map R, Spark, Scala, pig, apache tika, weblech, Yarn, Sqoop, Zookeeper, hive, scoop, Unix / Solaris, Windows