SUMMARY

• Software professional with 7 years of Experience in Development,Designing, Analysis and Administration of Business Intelligence Reporting Tools and ETL Data Warehousing solutions.Excellent communication skills, adept at managing time and resources to meet strict deadlines.
• Extensive Experience in all the latest BI Reporting Tools like TABLEAU, BIRST, TIBCO SPOTFIRE, SAP BO.
• Experience in development of ETL solutions using INFORMATICA POWERCENTER(PwC) tool.Gathering process information, business model and requirements.Using Informatica Power Center for designing, developing, maintaining, and monitoring ETL processes
• Experience in TABLEAU reporting tool involving creation of metrics, attributes, filters, parameters,workbooks, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Experience in Developing Performance Dashboards, Scorecards, Metrics, What if analysis, Prompts, Drills,Reports/Dashboards for all the functional areas including Finance, Change Management, Domain Management, Google Analytics, Litigation Management, Quality, Inventory Warehouse Management using TABLEAU.
• Experience in BIRST reporting tool.Gathering requirements and creating High level technical design documents.Creating DB objects and importing the objects into BIRST for logical model creation.Worked on creating hierarchies,grains,opaque views,inherited sources.Delivered 10+ spaces with 200+ reports to customers.
• Experience working with TIBCO SPOTFIRE reporting and administration.Involved in creation of information links,embedded and linked reports.Good knowledge of scheduled updates,automation services.
• Experience working on AGILE Methodologies which include Scrum and Sprint process with bi - weekly Production migrations.
• Experience in industries such as Retail, Manufacturing, Corporate, Legal & Billing.
• Extensively worked on Oracle databases which involved design and development of Enterprise data warehouse with multiple data marts using dimensional modelling techniques like star and snowflake schemas.
• Expertise in writing SQL queries ( Standard and complex queries involving joins,subqueries,with clause,minus,unions etc) and PL/SQL.
• Involved in performance optimization of report level backend SQL queries by analysing the execution plan.Created indexes,synonyms and grants.Debugging report, ETL level SQLs and fixing data quality issues .
• Worked on creation and maintenance of views,materialized views,stored procedures,packages and user defined functions.

PROFESSIONAL EXPERIENCE

Confidential

Senior Technical Associate

Environment: TABLEAU DESKTOP V9.2, TABLEAU READER,TABLEAU SERVER,Oracle

Responsibilities:

• Worked on Google Analytics Connector in Tableau to represent live data on dashboard .In order to provide the users with historical data we created Google Analytics Data mart on Oracle DB ( Total of 20 tables ) using ETL processes ( Informatica).
• Imported the tables to Tableau Desktop and designed the data model using joins, referential integrity and joins culling.
• Created and published a workbook with multiple worksheets and dashboards.
• Worked on creating one time extracts from Tableau and scheduling incremental extracts for the oracle data using Date Created .
• Extract was automated to be saved in a shared folder and was accessed by end users using Tableau reader tool.

Confidential

Environment: TABLEAU DESKTOP V9.2, TABLEAU SERVER,Oracle

Responsibilities:

• Gathering requirements from Business users and understanding the business rules.Preparing functional and technical design document and reviewing the same with business.
• Developing the data model based out of source and depending on reporting requirements.
• Developing worksheets using parameters,calculated fields,groups and hierarchies.
• Developing worksheets using various visualizations like Barchart,pie chart,tree map etc.Including best practices in the reports in order to achieve best report performance.
• Implementing user level security and publishing the dashboards to Tableau server
• Perform complete testing and create deployment documents and prepare for production deployment.

Confidential

Environment: Informatica PwC,Informatica Server,Oracle,SQL Server,Flat Files

Responsibilities:

• Lead developer responsible for Gathering process information, business model and requirements.Developed multiple ETL workflows and mappings using Informatica Power center Tool.
• Using Informatica Power Center for designing, developing, maintaining, and monitoring ETL processes
• Expertise using Informatica Designer,Workflow manager,Workflow monitor and Repository manager tools.
• Worked on using sources like Flat Files,.csv files, Oracle relational tables etc.Loaded data into flat file and relational targets.
• In LMS Process created a workflow which will wait for the file to be placed in the source file location and automatically trigger the process based on a UNIX shell script.Used session level timer and filewatch events tasks.
• Monitoring events using Workflow monitor tool and debugging issues using session log and workflow logs.
• Audit capture process involved creating of multiple workflow variables, mapping variables and assigning values to them at runtime.Good knowledge of Unix commands
• Good working knowledge on all transformations like expression, filter, sorter, router, update strategy, source qualifier,joiner,Lookup etc.
• Identifying errors occurring during conversion and integration and providing prompt resolution for the same
• Testing, debugging and troubleshooting new database systems .Managing and updating database as per the business requirements
• Performed migrations to upper environments using Repository manager tool.
• Having basic working knowledge on Informatica Cloud mappings.

Confidential

Environment: BIRST, Oracle, INFORMATICA

Responsibilities:

• Working with analysts to gather business requirements for the BIRST space development.
• Developed advanced data analytic spaces and completely developed data models .Processing the data using multiple processing groups.
• Managing access using the ADMIN module, creating groups, report level access, folder level access.
• Scheduling reports for delivering to users on specific time schedules Row level security setup.
• Creating custom attributes measures and custom columns, Variables to be used in report level. Report creating using designer and visualizer modules.
• Good understanding of all chart types and Dashboard 1.0 and 2.0.Using prompts, filters, dashboard level filters, filtering mechanism. Created multiple reports based requirements.
• Sharing reports, Report bursting, scheduling the reports to be delivered to particular set of users.
• Loading data using BIRST connect tasks and using variable for incremental uploads.
• Experience in handling Live access spaces, data model creation and managing local sources. (Opaque Views and Inherited sources usage).

Confidential

Environment: SAP BO 3.1, Oracle

Responsibilities:

• Worked on Universe Designer Tool .Developed multiple universes based on star schema and snowflake schema data models and created classes, attributes, prompts, Derived Tables and LOVs ( List of Values).
• Involved in migrating objects to upper environments and testing.
• Have developed multiple WeB Intelligence reports