Business Intelligence Analyst Resume
Tysons, VA
SUMMARY:
- Having 8 years of experience in the IT industry with in - depth knowledge of Requirement gathering, data analysis, technical and end user documentation, Software development life cycle and BI development.
- Over 6 years of experience in design, development maintenance and version update; specialized in Business Intelligence projects with Qlikview Desktop 10 / 11 / 12, Microsoft Power BI Desktop (1 Year).
- 2 years of experience in Qlikview Server administration, responsible for version migration, provide training for Qlikview developers through the HP internal process to publish a dashboard, train Qlikview developers and deploy dashboards in production, and train Qlikview server administrators.
- 2 years of experience developing universes in IDT, reports in Web Intelligence, migrating reports from 3.1 to 4.0, and optimizing old universes and reports which are part of SAP Business Objects 3 / 4 also used UDT for universe creation.
- 1 year of experience in SAP Business Objects Central Management Console (CMC) creating and administrating users and groups, profiles, connections, promoting jobs, report migration from 3.1 to 4.0, and job scheduling.
- Designed and implemented proof of concept for clients in financial, manufacturing and HR sectors with experience in high sensitive data (connecting to encrypted databases and encrypting QVD files).
- 1.5 years of experience in Microsoft power BI development creating the connections, data model, calculated fields and dashboards, created and administrated groups to share dashboards, installed and configured the gateway to schedule reports.
- 1 year of experience using SQL Server Integration Services (SSIS) for ETL purposes and SQL Server Reporting Services (SSRS).
- 2 months of experience using Tableau
- Ability to offer end-to-end solutions starting from requirements gathering, design, development and deployment of Business Intelligence applications.
- Expert Creating QVD's and Scheduled jobs for QVD extracts and report loads.
- Great Knowledge of Star and Snowflake Schemas and loading techniques which includes Incremental, Buffer and Binary loads.
- Expert in creating scripts to resolve circular loops, Synthetic keys and Modeling issues in QlikView.
- Experience analyzing the business to identify critical KPI’s that need to be tracked.
- Expert implementing Section Access to secure the data at a data level in the dashboard.
- Experience in Data Extraction, Transforming and Loading (ETL) using SSIS packages to handle data flow.
- Experience in Dashboard optimization to improve the response time of the queries from the end user reducing the calculation of data inflight, creating mappings.
- Experience in Data blending from different data sources (CSV, HTML, XML, XLSX, Databases, QVD)
- Experience installing and configuring Qlikview server, desktop and creating jobs.
- Experience in writing SQL queries, Functions, Views and Stored procedures.
- Able to meet deadlines and handle multiple tasks, decisive leadership qualities, flexible in work schedules.
- Experience with global teams for international companies, good Team Player and work independently.
- Worked in close association with customers for requirement gathering and effective analysis.
- Experienced with Agile Development Methodology in providing quick analysis and visualizations for business users.
- Expertise in problem-solving and trouble-shooting capabilities.
- Trained developers for QlikView, SAP Business Objects and Microsoft Power BI.
- Creation of technical guides and end user guides for dashboards.
- Experience in full life cycle project development, including design, coding, testing and implementation.
- Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
TECHNICAL SKILLS:
Business Intelligence Tools: QlikView 11.0/10.0/9.0, SAP Business Objects 4 /3.1, QlikSense, Microsoft Power BI, SQL Server Reporting Services (SSRS)
Databases: MS SQL Server 2012, 2008, Oracle 11g, Vertica
Languages: SQL, TSQL, Python 3.6
ETL Tools: SQL Server Integration Services (SSIS)
Others: Microsoft Visio 2010, SQL management studio, Toad Data point 3.4, SQL Server Data Tools, Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, MS Project, Information Design Tool (IDT), Universe Design Tool (UDT), Web Intelligence (Webi), VM VirtualBox, Qviewer, WinSCP
PROFESSIONAL EXPERIENCE:
Confidential, Tysons, VA
Business Intelligence Analyst
Responsibilities:
- Evaluate internal and external customers’ needs and abilities in order to provide appropriate solutions.
- Provide input to business requirements for the design of solutions.
- Present the requirements to the developers.
- Identify the source fields from applications in the database and provide them to the developers.
- Create User Stories in Agile Manager (AGM).
- Create User Stories in Team Foundation Server (TFS).
- Tools used to deliver are SAP Business Objects 4 and Qlikview.
- Provide support to planning Process for the sprint (agile methodology).
- User Story estimation in hours.
- Provide expertise for key BI core functions.
- ETL Developer using SSIS, create and maintain ETL Packages
- Data accuracy in the Database (SQL Server).
- Data Analysis of the Data warehouse (Queries in Oracle)
- Qlikview developer of 2 dashboards created and maintained by me, one of them with highly sensitive data which requires strong security.
Environment: s: QlikView Desktop 12, Microsoft SQL Server, SAP Business Objects 4, Agile Manager, Microsoft Team Foundation Server (TFS).
Confidential Tysons, VA
BI Developer Tech Lead - Global Delivery
Responsibilities:
- Requirement analysis.
- Create Mockups of BI dashboards.
- Train Developers in Qlikview
- Train Developers in SAP Business Objects.
- Responsible for data model design, UI design for dashboards, coding and testing BI dashboards.
- Handle complex tasks, assign tasks and provide direction to less experienced team members.
- Be compliant with Agile Methodology.
- Create and maintain end user guides and Technical guides.
- Collaborate with system architects, software architects, Business Analysts, and others to understand the business requirements and implement the best solution that satisfies all the needs.
- Ensure scalability, security, performance and reliability with the BI solution implemented.
- Requirement Gathering and define user stories using Agile Manager.
Environment: s: QlikView Desktop 12, Microsoft SQL Server, SAP Business Objects 4, Agile Manager.
Confidential, PALO ALTO, CA
BI Developer Tech Lead - Global Delivery
Responsibilities:
- Create Mockups of BI dashboards.
- Train Developers in Qlikview
- Train Developers in SAP Business Objects.
- Train Developers in Microsoft Power BI.
- Responsible for data model design, UI design for dashboards, coding and testing BI dashboards.
- Handle complex tasks, assign tasks and provide direction to less experienced team members.
- Be compliant with Agile Methodology.
- Creation and Maintenance of reports using SQL Server Reporting Services (SSRS).
- Create and maintain end user guides and Technical guides.
- Collaborate with system architects, software architects, Business Analysts, and others to understand the business requirements and implement the best solution that satisfies all the needs.
- Ensure scalability, security, performance and reliability with the BI solution implemented.
- Proofs of concept using Tableau.
- Administration of Qlikview platform (job scheduling, publishing, etc.)
- Administration of SAP Business Objects 4.1 CMC (security).
- Creation of reports and universes with SAP Business Objects.
- Create dashboards with Microsoft Power BI.
Environment: s: QlikView Desktop, QlikView Server/Publisher 11/12, Microsoft SQL Server, SAP Business Objects 4, Microsoft Power BI.
Confidential, PALO ALTO, CA
BI Developer Tech Lead
Responsibilities:
- Creation of reports and universes with SAP Business Objects.
- Qlikview document administrator (creating Jobs and scheduling, publishing dashbaords to UAT and Production after checking the complexity index of each dashboard).
- Administration of SAP Business Objects 4.1 CMC (security).
- Collaborate with system architects, software architects, Business Analysts, and others to understand the business requirements and implement the best solution that satisfies all the needs.
- Create Mockups of BI dashboards.
- Create and maintain end user guides and Technical guides.
- Responsible for data model design, UI design for dashboards, coding and testing BI dashboards.
Environment: s: QlikView Desktop, QlikView Server/Publisher 10/11, Microsoft SQL Server, SAP Business Objects 3/4 Web Intelligence and Central Management Console (CMC), Erwin.
Confidential
Business Intelligence Developer
Responsibilities:
- Create and maintain end user guides and Technical guides.
- Creation of reports and universes with SAP Business Objects.
- Create Mockups of BI dashboards with Qlikview and Business Objects.
- Data modeling for universes in Business objects and data modeling for dashboards in Qlikview.
- Qlikview dashboard and Business objects reports resting.
- Requirement gathering.
Environment: s: QlikView Desktop, QlikView Server/Publisher 10, Microsoft SQL Server, SAP Business Objects 3/4.
Confidential
Qlikview Consultant
Responsibilities:
- Pre sales Qlikview dashboards presentations
- Requirement gathering.
- Provide feedback regarding requirements and the business needs to ensure the solution provided will satisfy the company needs.
- Qlikview mockups design
- Implementation of the Qlikview solution (data modeling, user interface, security)
- Qlikview solution tests
- Training to non-technical business users
- Training to technical business users to maintain the Qlikview solution.
- Implement Qlikview security using Section Access.
Environment: s: QlikView Desktop, QlikView Server/Publisher 9/10, Microsoft SQL Server.
Confidential
Reporting Specialist
Responsibilities:
- Maintenance of reports using SQL server
- Creation of new reports
- Requirements gathering
- Creation of stored procedures in SQL server
- Creation and maintenance of views
Environment: s: Microsoft SQL Server.
