We provide IT Staff Augmentation Services!

Lead - Data & Bi Analytics Resume

SUMMARY

  • A technology leader with more than 11 years of diversified and rich experience in Data & Business intelligence.
  • Proven record of delivery in a very dynamic globally distributed business environment operating at cross - functional levels.
  • Managed project plans, scope, resources, change requests, risks and issues.
  • Versatile professional with demonstrated expertise in domain, efficient Project management, and Top Management (CTO & COO level) reporting capabilities.
  • Hands on experience in analysis, design, development and implementation of Business intelligence applications.
  • Managed the large-scale BI projects and successful in driving the strategic initiatives to drive business growth and reduce cost.
  • Analyzed the Business Case to understand project needs. Allocate project resources and time constraint. Prepared and analyzed AS IS and TO BE in the existing architecture and performed GAP Analysis.
  • Highly experienced as Big Data Engineer with deep understanding of the Hadoop Distributed File System and Eco System (HDFS, Map Reduce, Hive, Sqoop, Oozie, Zookeeper, HBase, Flume, PIG, Apache Kafka) in a range of industries such as Retail and Communication sectors.
  • Good leadership qualities with experience in training teams/developers, advising technical groups on coding best practices and problem solving skills.
  • Expert in BI tools like MicroStrategy Client, MicroStrategy Mobile & Dossier, Qliksense, Qlikview, Tableau and SAP Business objects.
  • Certified in all formats of MicroStrategy and Qlik.
  • Implemented Centre of excellence for Data & Analytics.
  • Experience in overseeing, mentoring and managing a technical BI team (Onsite & Offshore).
  • Strong experience with databases like Oracle, Hive, Hadoop, Amazon redshift and Rest services.
  • Expertise in end to end MicroStrategy Architect & Admin, Web & Mobile Dashboards development, Qlik Sense and Qlikview development, administration, data modelling and architecture.
  • Effectively managed the stakeholders across geographies and history of unlocking the hidden insights.
  • Strong programming skills with querying languages: Python, R, SAS, etc.
  • Expert to optimize existing MicroStartegy Mobile & Web, Qliksense and Qlikview reports to improve business productivity.
  • Expertise in optimization of code and tuning queries for performance against Oracle and AWS Cloud. Used Partitioning, bucketing, CBO, etc. on Spark
  • Experience architecting, installing and maintaining the full infrastructure/ BI platforms including MicroStrategy, Qlikview, Qliksense and SAP BO.
  • Well experienced in pushing the boundaries of BI tools by using APIs and building the custom solutions to address the business needs and to get the most out of the BI tools.
  • A strategist with proven track records of exceeding expectations with high degree of drive & result orientation, backed with noteworthy collaboration people engagement and customer centricity.
  • Expert in integrating the data science and building the predictive analysis in business intelligence.
  • Strong experience in optimizing the dashboards.
  • Extensive experience in creation of QV and MSTR Dashboards and scorecards, which helps in better understanding of the Business trends.
  • Expert in building the highly scalable, reliable and efficient BI platforms.
  • Extensive experience collaborating with technical managers and business stakeholders to determine strategies, priorities, and approaches for effective information delivery.
  • Effective communicator across the organizational spectrum. Adept at providing research, analysis, and adaptation of business intelligence tools.
  • Supply decision support to all levels of the company, with daily interactions involving Team Leads, developers and TPMs to C-level management

TECHNICAL SKILLS

  • MicroStrategy 11.X, 10.X, 9.X, MicroStrategy Mobile, Qlik Sense Feb 2019,
  • 3.2x,3.1.3, Qlikview 12,11.2/ 10X/9X, Tableau, PowerBI, Looker, SAP BO,R
  • Oracle 12c 11g/10g/9i, Hive Spark, Amazon RedShift, SQL Server, IBM DB2, Sybase, MS Access 2000, AP BW.
  • Informatica Power Center 8.x/7.x
  • SQL, UNIX, Python, R, SAS, HTML, D3.

PROFESSIONAL EXPERIENCE

Confidential

Lead - Data & BI Analytics

Responsibilities:

  • Established the vision for and led the design and development of the dimensional data warehouse and business intelligence systems.
  • Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications
  • Hands on Experience in Creating MicroStrategy Dashboards, Scorecards, HyperCards, Qlikview, QlikSense and tableau dashboards and charts and performance optimization.
  • Managing the Globally diversified and high functional team of BI developers, administrators and analysts.
  • Developed spark applications using Scala for easy Hadoop transitions.
  • Conducted technical training session regarding Agile development methods.
  • Automated Data & BI Deployment, Integration and Testing, which reduced manual efforts by 90%. (CI/CD/CT)
  • Highly experienced as Big Data Engineer with deep understanding of the Hadoop Distributed File System and Eco System (HDFS, Map Reduce, Hive, Sqoop, Oozie, Zookeeper, HBase, Flume, PIG, Apache Kafka) in a range of industries such as Retail and Communication sectors.
  • Worked on migrating existing mainframe data and reporting feeds to Hadoop.
  • Established and continued to manage the Center of Excellence.
  • Estimated and prioritized BI platform changes and funding requirements to sustain BI solution health/capability/sustainability. Worked with client to gather requirements and prepared technical specifications Documents.
  • Upgraded the client and metadata from 10.4 to 2019 and 2019 to 2020
  • Involved in installation and configuration of Micro Strategy 2019 and 2020
  • Integrated Hadoop with MicroStrategy to provide end users analytical reports.
  • Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) needed to create the Micro Strategy objects necessary for the deliverable.
  • Designed the projects and created all the necessary schema, application and configuration objects. Creating advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies. Involved in creating Security filters to end users to access data Based on their privileges.
  • Accountable for the specification and review of the architecture, design, and content of new BI solutions proposed to participate on the shared EDW BI platform.
  • Led the team for BO to MSTR & Qlik migration. Migrated over eight projects in 4 months, which includes 700+ Dashboards & Reports. Got the strongest link award for this effort.
  • Trained over 1200 users on VI Analysis, and internal development teams on Project design and report development.
  • Analyzed the Business Case to understand project needs. Allocate project resources and time constraint. Prepared and analyzed AS IS and TO BE in the existing architecture and performed GAP Analysis.
  • Helped my team on Agile/ Scrum framework, deployed scrum practices and conducted scrum ceremonies.
  • Established the data dictionary, data repository and data stewardship of the data model for the BI platform.
  • Integrated Python with MicroStrategy and imported data for predictive analysis and complex calculations.
  • Used R for creating custom charts in MicroStrategy Dossier visualizations.
  • Managed the stakeholders across geographies and history of unlocking the hidden insights.
  • Responsible for end-to-end Data Analytics delivery including solution architecture.
  • Designing, installing and maintaining the full infrastructure/ BI platforms including MicroStrategy, Qlikview, Qliksense, Tableau and SAP BO.
  • Strong programming skills with querying languages: Python, R, SAS, etc.
  • Effectively engaged the End users to take advantage of self-service BI environment.
  • Implemented the governance controls for the BI workflow by adhering to enforced regulations.
  • Implemented BI projects to handle the highly sensitive data with no compromise on security.
  • Bridged the gaps between enterprise needs and BI tools by building the comprehensive solutions.
  • Built the governed self-service environment using the BI tools and custom solutions.
  • Built the dashboards by processing the large data sets and providing the good user experience.
  • Attribute based access control and role creation using security rules.
  • Implemented all levels of security including the row level, column level and dashboard level and sheet level.
  • Integrating the data science and built the predictive analysis
  • Developed reconciliation platform to test the data quality.
  • Established the scalability testing and performance-testing platform for BI dashboards.

Environment: MicroStrategy 10.x & 9.X, Qlik View, QlikSense, Desktop Reports, Web Reports, Architect, Administration, Dash Boards, Unix, R, Python, Toad, Excel, Oracle 12c, 11g r2,Exadata, Hive, Spark, PL/SQL, Oracle Warehouse Builder 10gr2, object manager, enterprise manager, integrity manager, command manager, etc.

Confidential, Quincy, MA

BI & Data Analytics Manager

Responsibilities:

  • Head up BI COE Team and manage overall BI and Data Analytics Delivery
  • Managed a team of BI Developers and Data Analysts
  • Work with business to prepare and fine tune requirements through iterative prototyping and Walkthroughs.
  • Co-ordinate with data modelers and ETL developers to enable reports speedy and functionally relevant reports.
  • Maintenance, enhancement and performance tuning of existing MSTR objects.
  • Kinds of reports created - canned reports, prompted reports, ad-hoc reports, freeform SQL Reports.
  • Interacted with the users extensively and gathered the requirements, and analyzed the needs of the end users.
  • Creation of document services.
  • Kinds of dashboards created - metric, dynamic content, dynamic visualization and Performance summary dashboards.
  • Configuring subscription, scheduling and delivery of reports and document objects using Narrowcast and now Distribution services.
  • Created advanced metrics, prompts, filters, custom groups, consolidations, drill maps.
  • Generated Key Performance Indicators (KPI) metrics and other metrics.
  • Developed Scorecards and Dossier using Micro Strategy best practices using selectors, Widgets and multi-panels.
  • Resolved many to many relationships in Micro Strategy using the relationship tables.
  • Implemented security for different users to view reports for their regions using security filters.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies.
  • Created Report Services Documents with various transformation metrics to report on Monthly, YTD and Trailing 12 month’s period.
  • Maintained SDLC artifacts and documentation in HP Quality Center.
  • Created a test plan, perform unit test and sent the test plan along with the files generated for QA.
  • Adept at complex SQL and PL SQL for data analysis.
  • Provided postproduction support to end users.
  • Worked in weekly release cycles.

Environment: Micro Strategy 9.2, Teradata, Report Services, Administrator, Object Manager, Enterprise Manager, Narrowcast Server, Datatel, Oracle, SQL Server.

Confidential, Ashburn, VA

Project Lead

Responsibilities:

  • Interacted with the users extensively and gathered the requirements, and analyzed the needs of the end users.
  • Involved with the data modelers for creating dimensional model based on the requirements.
  • Involved in analysis, design, and construction of the metadata.
  • Created schema objects like attributes, facts, hierarchies, transformations and public objects like metrics, prompts, consolidations, custom groups, drill maps, and templates.
  • Designed various kinds of reports like Dossier, Operational Reports, Business Reports, and Ad-hoc Reports.
  • Created various monthly Dynamic Dossier Documents with multiple panel stacks, selectors, and customized widgets.
  • Created advanced reports using Micro Strategy Desktop Designer.
  • Involved in the creation of Data mart Reports, Partition Mappings, and Aggregate tables to improve performance of Enterprise Reports.
  • Scheduled reports, reports services documents and dashboards using Schedule Manager.
  • Worked extensively on Narrowcast Server in creating various Narrowcast objects.
  • Distributed reports to different users and user groups using Narrowcast Server.
  • Developed complex SQL queries and involved in setting up VLDB properties for performance.
  • Developed Flash Dashboards using Widgets and Selectors for summary level reporting.
  • Created static and dynamic reports and subscriptions for Narrowcast delivery.
  • Developed Customized and Adhoc reports using Templates, Metrics and Filters for Business analysis. Performed administration tasks of Tuning, Caching, Governing, and Report Optimization.
  • Performed testing of all reports for QA and production deployment.

Environment: Micro Strategy 9.2 64 bit Architect, Report Services, Administrator, Object Manager, Enterprise Manager, Narrowcast Server, Datatel, Oracle, SQL Server, SSIS, Windows

Confidential, Wilmington, DE

BI Architect

Responsibilities:

  • Worked with client to gather requirements and prepared technical specifications Documents.
  • Involved in design of proto type of reports based on requirements.
  • Communicate offshore working team to explain client requirements and develop reports.
  • Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
  • Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
  • Responsible for keeping team members on track toward completing the terms of goals.
  • Involved in installation and configuration of Micro Strategy 8.1.1.
  • Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) needed to create the Micro Strategy objects necessary for the deliverable.
  • Architected the projects and created all the necessary schema, application and configuration objects. Creating advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies. Involved in creating Security filters to end users to access data Based on their privileges.
  • Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations. Involved in creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
  • Set-up the narrowcast environment and created services using subscription sets, schedules, Information objects.
  • Creating Dossier Reports to view personalized reports based on user requirements.
  • Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
  • Involved in Developing Reports by using Free Hand SQL Queries in Micro Strategy Desktop. Involved in customization of Grids and Graphs by using SDK.
  • Involved in migration of Schema Objects (facts, attributes, hierarchies, Transformations), Application Objects (filters, prompts, metrics, consolidation, custom groups), user groups from 8.0.2 to 8.1.1. Involved in partitioning the tables, indexes and management of the schema objects.
  • Involved in optimization of code and tuning queries for performance.
  • Involved in tuning the application Queries using Explain Plan. Create a test plan, perform unit test and send the test plan along with the files generated for QA.
  • Provided post production support to end-users.

Environment: Micro Strategy 9.0,Desktop Reports, Web Reports, Architect, Narrowcast Server, Administration, Dossier, Unix, Toad, VBA, SDK, Excel, Oracle 10g, Oracle10g r2, PL/SQL, Oracle Warehouse Builder 10gr2.

Hire Now