PROFESSIONAL SUMMARY:

• Over 4 years of experience in the field of Business/Data analysis, ETL/Report Development, Data Modeling, and Project Management.
• Experience in Working with different industrial clients like Financial Services, Health Care and Retail.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Migration Experience from Business Objects 3.1 to 4.0/4.1 and Business Objects 4.0 to 4.1.
• Experience in creating universe in IDT using Excel Data, MS Access, SQL Server, SQL Server Native Client and Oracle Database by creating ODBC Connection.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Experience in generating reports using SQL Server Reporting Services, Pentaho Reporting, Crystal Reports, WebI, Power Bi Desktop, Tableau Desktop, Birst and MS Excel Power View.
• Knowledge in What - If Analysis using Crystal Reports, WebI, Tableau Desktop, Birst and MS Excel Power View and Drill through Dashboards using Warehouses and OLTP Connections.
• Experience in Monitoring Data loads and rerunning the loads using shell scripting in Putty and checking errors using WinSCP.
• Experience in Analyzing and evaluating tools for customers/stake holders, creating a tool evaluation matrix with ranking abilities of different Tools.
• Experience in Giving Demos to customers on reporting tools that suit their requirement.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience in various phases of Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Experience in guiding the team to accomplish the goals set by management and play a vital role in supporting the team from front and yet at the same time work under a supervisor.
• Excellent communication skills in both written and oral along with ability to tell a story through data.

TECHNICAL SKILLS:

ETL Tools: Microsoft SQL Server Integrated Services (SSIS), Pentaho Spoon Data Integration.

Modeling Tools: MS Visio

Programming: SQL, UNIX Shell, HTML, C

Utilities: MS Office Suite, MS SharePoint, MS Project, MS FrontPage

Databases: MS SQL Server, Oracle 10g/11i, Teradata, MS Access, MS Excel

BI Tools: SAP Business Intelligence (Crystal Reporting, Web Intelligence, and Lumira), Tableau 8.x/9.x Desktop and Server, Power BI, Birst, Pentaho BI, Qlik view.

Platforms: Windows 8/2003/NT, Mac OS, UNIX, Linux

WORK EXPERIENCE:

Confidential, Perth Amboy, NJ

BI Analyst/Developer

Responsibilities:

• Remotely work with Finance, Health Care and Retail industry clients simultaneously to strategize, plan and deliver BI reporting solutions using Different BI Tools.
• Create and provide end to end Demos and Proof of Concepts (POC) to prospective clients on various BI Reporting tools like Birst, Power BI, Tableau Desktop 9.x, Web Intelligence 4.x, Crystal Report, Lumira and Pentaho BI, Qlikview.
• Support sales by developing, building and maintaining business relationships with decision makers and influencers.
• Team Lead Role: Assign tasks, create project plans, track project status, consolidate reports and communicate status to higher management and clients.
• Single point of Contact with the client working as a liaison for the development team
• Lead meetings to capture and finalize requirements, Create Business Requirement Documents (BRD) and Work Breakdown Structures (WBS).
• Create process maps, use cases, class diagrams and data flow diagrams for different project scenarios
• Develop metrics to determine inefficiencies and areas of improvement across the development and deployment process for different clients
• Developed/Introduced a web based customer support environment for tracking tickets and resolutions.
• Responsibly Provided support and communicated ticket status and updates with clients and the team.

Confidential, Morristown, NJ

BI Analyst

Responsibilities:

• Interacted with Business Users and developers to gather and document the Requirements and translate these to Technical specifications for designing Universes.
• Worked with the Confidential and Confidential team and Users to gather requirements and implement solutions.
• Wrote and maintained Business Requirements Documents (BRD) and Functional Requirements Document (FRD)
• Created a universe .unx in IDT 4.0 built on SQL Server with filters and security folders.
• Created a user interactive Dashboard in Web Intelligence with multiple variables at report level for calculating specific fields and with drill down functionality from one tab to another.
• Created Multi tab reports and applied different Webi functionality such as hiding and filtering tables based on specific prompt conditions. Also used Union, Intersection, minus, Master/Detail, cross tab and Charts using Webi functionalities.
• Tuning of Reports by validating SQL Query against database and troubleshoot reports that are not providing accurate data due to custom SQL codes.
• Created folder level security for users and user groups on who can view and edit the dashboard.
• Created As Built Document and Deployment document.
• Promoted universe, Security and dashboard from Dev environment to Test Environment and Test to Production Environment.
• Responsible for data validation and QA. Created Document for Case scenarios while manually validating Data using Excel Pivot Tables.
• Scheduled and Distributed reports to different users by using CMC, Info View and Publisher.
• Created repository, created users and groups, assigned rights to users and groups.
• Given to clients on how to Access and use the dashboard using an Open doc link.
• Provided support for Tickets raised by users.
• Responsible for working with the Confidential and Confidential team and gathering requirements for Ad Hoc Reporting.
• Importing Data from SAP BI Universe to Excel and creating Queries and Reports using Excel Add-ins (Power Query and Power Pivot)
• Creating custom variables/ expression and filters in IDT.
• Promoting the queries and reports created in Dev to Production environment.
• Trained business users to easily create their own queries and reports in emergency situations.
• Wrote articles and documents on the RAS - Confidential and Confidential support on Universe Conversions.

Environment: IDT 4.x, BI Launch Pad, Web Intelligence, MS Excel, Power Query, Power Pivot, MS Visio, MS Project, Office 365, Zoho Support.

Confidential, Syracuse, NY

BI Consultant

Responsibilities:

• Responsible for the design, development and deployment of HeC’s first implementation of Birst.
• Worked with HeC Analytics team and business users to gather requirements and implement the solutions.
• Implemented Birst Network bi practices to share the Birst data warehouse with multiple spaces for different purposes from internal and external sources outside the HeC network.
• Worked with the RAS Database Team to design staging data models used as sources to our Birst cloud warehouse.
• Monitored data loads in to Birst using Putty and WinSCP.
• Designed and Developed Birst spaces/Dashboards for the following subject areas:
• Clinical Patient Level space used for ad hoc reporting focusing on patient episode of care analysis and Quality metrics used to analyze population health.
• Operational Event and Audit Data spaces used for ad hoc and monthly reporting purposes.
• Created Operations Dashboards for internal teams to monitor event and audit data.
• Created Audit Dashboards for medical providers.
• HL7 Data Quality Channel space provides the ability to process incoming messages and analyze the data format for all messages by checking to see if the format confirms to the HeC specification.
• CRM space was created to use as a reporting tool sourced from a 3rd Party CRM application.
• QC dashboards used to streamline data and space validation.
• Created As Built Documents for each of the reports and documented custom expressions on the report.

Environment: Pentaho Spoon 5.4, WinSCP, Birst, Linux, Office 365, Zoho Support.

Confidential, Parsippany, NJ

BI Developer

Responsibilities:

• Maintained Business Requirements Documents (BRD)
• Created WebI Reports with multiple variables at report level and created User Defined Variables on report site upon user's requests.
• Created Multi tab reports using multiple data providers and applied different Webi functionality such as hiding and filtering tables based on specific prompt conditions. Also used cross tab and Charts visualization to make the data understandable to the user.
• Created a Detail Analysis Report for Auditing Purposes in Web Intelligence.
• Auditing Statistics were analyzed to check user interaction, login in specific time slot, How many reports were view and how many times are the reports viewed and by whom, report duration etc.
• Scheduled and Distributed reports to different users by using CMC, Info View and Publisher.
• Created repository, created users and groups, assigned rights to users and groups.

Environment: SAP BOBJ 4.x Web Intelligence, SAP BOBJ 4.x UDT, MS Word, MS Excel.

Confidential, New York, NY

BI Intern

Responsibilities:

• Gathered Business Requirements Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed donut charts for analyzing sales planning data.
• Created different KPI’s using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions).
• Worked extensively with Advance analytics like Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Ability to design and deploy rich Graphic visualizations using Tableau.
• Converted existing BO 5x reports into tableau dashboards.
• Published and shared views on Tableau server.
• Scheduled extract refresh and subscriptions.
• Also involved in administration tasks such as creating and managing Sites, Setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Ability to work effectively in team environment and interact with all levels of management.

Environment: Tableau 8.2/9.2, Teradata13, Oracle 11g, MS Excel, MS Access, UNIX