SUMMARY

• 5+ years of experience working as a BI/Data Analyst and Reporting Analyst by using various Analytics tools like OBIEE(Oracle Business Intelligence Enterprise Edition),OBIA, OASIS, Cognos, Tableau, Crystal Report, Power BI and Data warehousing applications, focusing mainly on Healthcare, Finance, Insurance and Retail Domains.
• Experience in creating dashboards in OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using page and dashboard prompts, Security Setup (groups, object and data level), External Tables, configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Proficient in creating rich visualizations using Tableau Desktop, Software Analysis, Design, and Development in the fields of Databases, Business Intelligence, Client Server Technologies and Web-based Applications Expert in Data Visualization development using Tableau to create complex, instinctive, and imaginative Dashboards.
• Strong experience in Tableau Desktop, Tableau Server, and Tableau reader in various version of Tableau 6/7/8.
• Good comprehension of ideas for example, Data Warehousing, Data Marts, ER Modeling,
• Dimensional Modeling, Fact & Dimensional Tables. Experience in design, analysis, development and implementation of various applications in Client/Server OLAP environment using BI Tools.
• Worked in various phases of software development life cycle (SDLC) including Analysis,
• Design, Development, Testing and Production.
• Able to handle distinctive tasks simultaneously and Lead experience and Good Working Knowledge in Agile and Kanban Project administration (Scrum process) Experience in Tableau, MySQL, Oracle, XML, SQL, MS ACCEES, MS SQL SERVER.
• Very good experience with advance Excel functions like VLOOKUP’s, Pivot tables etc.
• Strong analytical skills, ability to understand applications from a technical as well as business perspective.
• Experience in preparing Test Documentation, Test Plans, Test Scenarios, Test Cases and Software Requirement specifications, Integration Test Specifications and Test Scripts, decomposing Business Requirements and developing Test Scenarios to support quality deliverables.
• Sound knowledge of test management tool HP Quality Center, HP Application Lifecycle Management .
• Experience in creating the Responsibilities matrix document by talking to the Business users.
• Diligent worker, self-starter, consistent performer and adaptable to work both as a team member as well as independently.

TECHNICAL SKILLS

Programming Languages: TSQL, VBA, SQL, ASP.Net

Operating Systems: Windows, Mac OS

Database tools: MySQL, Oracle, Toad, SQL Server 2008/2012

Framework & Tools: OBIEE, Cyystal Reports, Tableau, SSRS, Aceyus, Cognos, SSIS, Microsoft Visio, Advanced Excel skills, MS (Word, PowerPoint, Outlook), UML, Shopatron KIBO, KWI, Google Analytics, OASIS, GhostDraft, Delphi, Workday.

Methodologies: Agile (Scrum), Waterfall, Kanban Certified

Bug Tracking Tool: HP ALM, HP/QC, JIRA

PROFESSIONAL EXPERIENCE

Confidential, PA

Forms/ Report Developer

Responsibilities:

• Worked as a Forms and report developer in the IT Department for the Insurance company.
• Assisted the Forms Application Developer with forms development tasks which mainly Focused on the development needed for 2018 and 2019 projects which included ImageRight Folder structure form updates, Modular policy forms development, Re-application updates, New Form filing updates.
• Coordinated with offshore team and the business Analyst to communicate regarding the business requirements and designed various insurance policies and Reports for different states via Ghostdraft tool.
• Analyzed and made changes in existing versions of the Reports in Crystal Reporting Tool and migrated them to GhostDraft.
• Created complex reports and charts that contained detailed information on various insurance policies for different state.
• Submitted the policies to the Underwriter team for proofing and made changes accordingly.
• Managed reports through the development life cycle in order to get them signed off and moved to production .
• Handled varieties of different insurance policies and forms of various states and tested those in the OASIS DELPHI tool.
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.
• Involved in Debugging, Troubleshooting Procedures, functions, and packages, customizing the existing ones.
• Performed manual testing of various forms and reports in OASIS to check whether they are generated in the correct format for particular states.
• Developed reports such as tables, matrix, Charts, parameter reports, cascading parameter reports using Crystal Reports and exported to EXCEL, CSV and PDF formats.
• Performed manual testing functionality of applications on Delphi 10 environment
• Maintained project status reports and technical documents

Confidential

BI/Data Analyst/ Report Developer

Responsibilities:

• Extract, transform and load data from various data sources to our reporting server.
• Developed and maintained an on-line documentation web site that included object models, data models, and over 300 documents.
• Worked with marketing and sales to create a series of Crystal Reports. Instituted on-line reporting on the company intranet.
• Created sales and commission reports using Crystal Reporting tools for various stores all around the US.
• Created custom formulas and communicated progress to Project Manager
• Create dynamic dashboards and visualization with filters, parameters and sets using OBIEE 11G and Answer user inquiries regarding daily reports request/ investigation.
• Automate repeatable task where possible using VBA and Task Scheduler.
• Create and modify Ad hoc and crystal reports for internal and external Users.
• Design and implement Stored Procedure, tables, views and joins used across the business in daily reporting.
• Handled a large Volume of Phone calls, chats and emails.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements
• Working Daily with the KPI’s, KWI, Google Analytics, Power BI, Kibo Shopatron and Demandware to pull daily data for the daily reporting.
• Used excel sheet, flat files, CSV files to generate OBIEE adhoc reports.
• Scheduled extract refresh for weekly and monthly reports.
• Prepare daily status reports, Weekly status reports and Task completion report.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Confidential, Miami, FL

Data Analyst/Reporting Analyst

Responsibilities:

• Worked closely with clients to determine and articulate project scope and expectations.
• Built ETL Packages with SSIS and Collaborated with the Business Analysts to gather detailed requirements for enhancing reports and creating database solutions for Customers planning.
• Experienced in Extracting, Transforming and Loading data from various data sources like excel, flat file and Oracle to SQL Server databases using SSIS SQL Server Integration services.
• Created advanced T-SQL queries using DDL, DML, and Indexes, Views, Cursors, Triggers and Stored Procedure.
• Created reports on WTD, MTD, QTD and YTD basis for customer Experience.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints.
• Involved in performance tuning of queries for query efficiency.
• Worked on creating Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server agent.
• Worked with various data transformations like Merge, Merge Join, and Union all, Sort, Conditional Split and Multicast.
• Created complex calculations, Aggregations and actions on the cube as per end user requirements.
• Experienced in creating database objects such as tables, views, indexes, triggers etc. as needed.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.
• Prepared detailed documentation for development, Test cases, testing different scenarios and documenting the result.
• Excellent in data loading, performance issues, data compression activities, archiving and reporting related issues.
• Worked With the team in a deadline-driven environment with multiple tasks assigned throughout the day, completing them quickly, with attention to detail and quality

Confidential, Bloomfield, CT

BI Data Analyst/Reporting Analyst

Responsibilities:

• Interacted with the client and end user to collect the list of requirements.
• Understand project requirements and work towards design and development of the plan layout.
• Prepared a project layout and provide technical guidance to the development team.
• Involve in ETL applications, data validation, data cleansing, archiving and re-modeling.
• Develop enterprise dashboards and reports using OBIEE and tableau desktop tools.
• Prepare dashboards in both OBIEE AND Tableau Desktop using calculated fields, parameters, calculations, groups, sets and hierarchies.
• Involved in creating calculations like string manipulation, arithmetic calculations, custom aggregations and ratios, logic statements and quick table calculations
• Created dashboards used specifically for Tableau Mobile app. These dashboards were extensively used by executives and people on the field, who used mobile phones to access these dashboards
• Wrote Custom SQL to support business requirements.
• Identify critical issues and processing faults to optimize BI dashboards and reports
• Perform testing sessions for reports and dashboards and resolve process issues.
• Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.
• Create and execute test plans in HP ALM, and working closely with Developers to resolve issues
• Developed and implemented comprehensive test plans with the QA to ensure that systems and programs are tested and debugged.
• Prepare documentation and give project performance feedback to the clients and the senior management.

Confidential

SQL Developer/Test Analyst

Responsibilities:

• Worked in a dual role of SQL developer and Test analysts
• Well versed with the SDLC process. Wrote Test scripts and test cases to test the functional requirements of applications created by other team/developers
• Validated accuracy of data to ensure database integrity. Created and maintained SQL scripts
• Met with clients to determine and articulate requirements, expectations and scope
• Used HP QTP and ALM for automation of test scripts to reduce workload of the team
• Sourced data from various sources and created data marts, loaded data into the Oracle tables
• Worked closely with the business users to understand their data and application requirement

Confidential

Data Analyst

Responsibilities:

• Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.
• Studied the data warehouse architecture (star and snowflake schema), fact tables, measures, dimension tables and different kinds of dimensions.
• Developed an Online E-Learning system to provide easy learning environment to students and faculties, also created ASP.NET Web Forms, Web Services, Created Queries and joins on multiple tables, Functions and Triggers using SQL Server 2008 for inserting/updating/ deleting the data into the relational tables.
• Created various pages like Login, Product, Material, Test question and Test Master page for Admin, for Expert the pages were Login, video upload, Blogs, Test Result and FAQ’s.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Knowledge in writing TSQL queries, dynamic queries, sub queries and complex joins for generating stored procedures, user defined functions and triggers and views.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance.