SUMMARY

• Proficient in preparing wide range of documents including, High Level and Low - Level documents (HLD/LLD), such as Business requirements document (BRD), Systems Requirements Specification (SRS), Use case Specification.
• Documenting requirements, meet with business and discuss the progress, uncovering areas for improvement, and developing and implementing solutions.
• Solid understanding of database management systems and working knowledge on SQL server 2008/Oracle 10g,11g,12g Microsoft Access databases, and Excel Spreadsheet with experience in data modeling using E-R Diagrams.
• Ability to establish and write documentation manuals for users.
• Experience in all phases of Testing (Unit Testing, Functional testing, Integration Testing & UAT).
• Skilled at Analysis, Design, Development, Support, and Performance tuning of applications using Oracle SQL, and PL/SQL.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, EXPDP/IMPDP.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Hands on experience on Tableau 8, 9, Oracle Business Intelligence Enterprise Edition 11g, 12c, Oracle Hyperion Financial Reporting 11.
• Expertise skills in using the tools TOAD for Data Point 4, Oracle SQL Developer 4, SQL Server Management Studio 2016.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.
• Having Good understanding and experience of Object Oriented Concepts.
• Experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Experience in Hierarchies, Filters, Quick filters, Calculated measures, and keys in the BMM layer.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created Customized and interactive dashboards using multiple data sources.
• Experience in creating aggregates, hierarchies, filters, quick filters, calculated measures.
• Willing to learn new advancements in the industry and implement them in the work accordingly.

TECHNICAL SKILLS

Data visualization/ Reporting tools: OBIEE 11g,12c/Public Microsoft SQL Server Reporting Services, Tableau 2019.3

Programming Languages: C, JAVA, SQL, PL/SQL, HTML, UML, Visual Basic.

Databases: Microsoft SQL Server 2008, MS Access 2003, Oracle 11g/10g.

Methodologies: Waterfall, SCRUM and Agile.

Operating System: Windows, Unix, Linux and Ubuntu.

Data Modeling: Power Designer, MS Visio, MS Power Point, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence/OBIEE Developer/ Tableau Developer

Responsibilities:

• Discuss with the business and document the requirements for the report built.
• Documenting the business requirements into technical requirements in the form of a wire frame.
• Design, plan and executing the report in agile methodology with test driven development.
• Identifying which tools is appropriate to deliver the requirements.
• Testing the product using unit test cases.
• Involved in creating complex tableau dashboards and complex analytical layouts for the reports.
• Developing formatted and tabular reports by using BI Publisher and reports in tableau server so the Business can receive them to their preferred location.
• Involved in administrative task suck as publishing workbooks and reports, setting up the security, providing access to users and adding them to one specific group.
• Able to quickly learn the concepts of Hyperion and the underlying development and try to replicate the same in the new technology while migrating the dashboards and SQR.
• Coding complex SQLs’ and stored procedures to fulfill ADHOC requests of Business both in Sybase and Oracle.
• Involved in migration over 250 reports from Hyperion reporting tool to OBIEE.
• Creating views and materialized views for data in the Oracle database so we can use them for our reporting purposes.
• Experience in developing stored procedures in Sybase to tackle the performance issues.
• Provide technical guidance and support for production issues and involve in analysis for finding the root cause.
• Migrating the SQRs on the Hyperion server to other technologies like OBIEE and Sybase stored procedures.
• Lead the team during the product deployment activities and coach them on the deployment automated process.
• Created workflows in informatica to schedule run the stored procedures which generates the output file for SQRs.

Environment: OBIEE 11g/12c, Oracle 11g, SQL Developer, TOAD, Windows, Hyperion reporting studio, Tableau, Sybase.

Confidential, Boston, MA

Business Intelligence/OBIEE Developer

Responsibilities:

• Involved in the discussions with the business users to gather reporting requirements.
• Build Repository at 3 layers physical Layer, Business model and Presentation Layer
• Performed Dimension modeling and identify fact tables and measures
• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships & Foreign Keys (Physical & Logical) between tables.
• Involved in the detailed design of the Analysis and Dashboards.
• Involved in creating Dashboards for the reports also using Condition in Dashboard.
• Implemented different views of report i.e. Pivot table, Titles, Graph etc.
• Implemented Prompts to provide dynamic filter condition to end users.

Environment: OBIEE 11g/12c, Oracle 11g, SQL Developer, TOAD, Windows, MS Office Suite

Confidential, Charlotte, NC

Oracle SQL Developer.

Responsibilities:

• Collected User Requirements by participating in meetings and studying existing System.
• Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using Oracle Designer.
• Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures, function, and packages, Cursor.
• Involved in analysis, design, coding and Testing.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Used BULK COLLECT and FORALL for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used PL/SQL to create Packages, Functions, and Procedure.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Involved in writing Technical Specification Documentation.

Environment: Oracle 11g, SQL Developer, PL/SQL, SQL, TOAD, MS office Suit.