SUMMARY:

• Having 8 years of extensive IT experience in Business Analysis, Design, Testing, Migration, Production support and Implementation of Software applications.
• Having 4 years of versatile working experience on Business Intelligence/Business Analytics software also experience in Infrastructure services.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Deployed the reports and Scheduled Reports for the use of end users.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Experience in configuring reports from different data sources using data blending.
• Ability to architect a custom solution. Design, development, distribution of custom client-server and WEB solutions. Integrator of relational databases like SQL Server, ORACLE, Microsoft Access and Excel spreadsheets.
• Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Able to handle different projects concurrently and Lead experience.
• Technical support to the team, reviews of deliverables, communication with offshore team, track all the deliverables and to impart on job training to the team.
• Experience in performing System, Functionality, User Acceptance, Integration and Regression testing.
• Self-Motivated, energetic, self-starter with excellent analytical, organizational and creative skills.

TECHNICAL SKILLS:

BI/Reporting Tools: OBIEE 11g, Tableau Desktop 7, 8.1, 8.2 & 8.3.

Operating Systems: Unix/Linux, Windows XP.

Languages: SQL, PL/SQL.

RDBMS: Oracle 8i/9i/10g/11g and MS access, MS SQL Server 2005/2008R2

Database Tools: Toad, SQL *Loader, SQL *Plus, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Tableau Developer

Responsibilities:

• Experience with the design and development ofTableauvisualization solutions.
• Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, IPhones, and other smart mobile phones.
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 7.x/8.x (Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project.

Confidential, Franklin Lakes, NJ

Tableau Developer/Admin

Responsibilities:

• Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
• Communicated Project Requirements, Business issues, Solutions and made recommendation.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Extensively used SQL scripts for data mapping and querying.
• Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created Hyperlinks for each of the Metric to open a detail report using Open Documents
• Designed and developed a business intelligence dashboard using Tableau reporting solutions, allowing executive management to various trends in data related to Merchants and Merchant products.
• Developed and published reports and dashboards using Tableau Desktop/server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked collaboratively with a team of Teradata developers to build ETL process needed for reporting.
• Executed and tested required queries and reports before publishing.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues
• Provided 24/7 production support for Tableau users.

Environment: Oracle 11g, TOAD, SQL, Data Stage, Tableau 7.0/8.0, Autosys, SQL Server, Erwin.

Confidential, Chicago

BI Developer

Responsibilities:

• Analysis/understanding the requirements.
• Worked with ETL team for the table structures to implement GDS subject area.
• Involved in creation of Physical Layer. This involves importing required tables, creating physical and complex joins to implement Star schema.
• Involved in the development of BMM and carried out following tasks:
• Created logical dimension tables.
• Created logical fact tables by deriving from fact and its respective aggregated tables.
• Created Dimensional hierarchies to enable Drill-Down reports and to support aggregate navigation.
• Created Calculated and level based measures.
• Created IB/Variables to support the business model like Current Quarter etc…
• Created Presentation Catalog folders for GDS subject area, and grouped tables and columns based on the requirement.
• Involved in the implementation of Data Level security in repository level.
• Involved in the implementation of object level security both at Web and repository level.
• Involved in the development of OBIEE Reports/Dashboards based on the user requirements.
• Created Saved Filters for reuse purpose.
• Created iBots for some of the important reports.
• Prepared exhaustive test cases to comprehensively test the required output.
• Prepared all technical documents related to project.
• Co-Ordination with Onsite team

Environment: OBIEE 11g, DAC 10g, Oracle, Control-M, Microsoft Excel.

Confidential

System Analyst

Responsibilities:

• Responsible for troubleshooting various aspects of the client/server architecture in Oracle setting.
• Performance tuning of SQL queries used in extracting data from different source systems as well as in transformation of data using SQL and PL/SQL code.
• Installed and configured new databases as required.
• Responsible for providing 24x7 supports for all Production and Development Databases.
• Implanted hot standby database backups and Data Guard for production databases.
• Testing and implementation of database replication.
• Perform application testing of new portal applications and interface. Expert in infrastructure skills.
• Integrate Oracle and SQL database Content into portal.
• Manage, administer and upgrade Oracle database 9i and Oracle 10g database technologies.
• Implementing the data model required by the application.
• Creatingschema objectsand implementing rules fordata integrity.
• Writing server-sidePL/SQLor Java subprograms and client-side procedural code that useSQLstatements
• Creating the application interface with the chosen development tool
• Analyze and troubleshoot system issues in a timely manner.
• Identify and automate routine maintenance tasks.
• Coding and testing several utilities according to the requirements of client.
• Planning & Managing of Database Backups.
• Analyzing schema objects.
• Monitoring of alerts logs for the database performance.
• Managing tablespaces, tables, indexes and views.
• Multiplexing control files.
• Recreating the control files using the trace files.
• Logical backup using export, import & data pump.
• Worked on transportable table space.
• Using SQL *Loader, converted data from Unified system to Oracle Database.
• Create and maintain the physical & logical Backups.
• Troubleshooting Oracle Databases using SQL trace utilities.
• Monitoring the different memory status.
• Monitored and diagnosed database performance through monitoring of alert files and trace files.
• Used Explain plan statement and Oracle Optimizer hints to enhance performance of SQL statements.
• Configured memory & disk resources to Optimize sort operations.
• Used log miner to monitor log activity.

Environment: Oracle 11g and MS access, MS SQL Server 2005/2008R2, Toad, SQL *Loader, SQL *Plus.

Confidential

Support Engineer

Responsibilities:

• Front-line support of all the financials modules for SVU 24/7.
• Development and delivery of Periodic, Daily, Weekly and Monthly reports as per the business requirements based on the Oracle Financials Modules. i.e. AP,GL,PO,PA,FA etc
• Monitoring every day the 18-21 byte Program after completion of GL POST. Troubleshooting if there is any issue related to completion of the program or with the BEA Server.
• Handling issues related to Oracle Financials through Service Requests, Mails, Calls, and Oscar Tickets
• Providing the user with the resolution if the issue is resolvable within Level 1 activities else routing the requests to Level 2 Support workgroup or other issue related workgroup
• Resolving the issue as per the SLA norms and the severity of the issue. Level 1 Support Team has certain privileges’ in Oracle Financials Production as well as the other instances, which allows us to create, modify and alter access of the New Users as well as the existing users in Oracle Financials
• Developing SQL Scripts for troubleshooting in case the user access seems to be fine from the front end but with a problem at the back end. Working with the DBA’s for the execution of the script with the prior approval from the manager of the user
• Altering, creating the access of the existing and the new User on prior receiving the approval from the Super Users
• Deleting or End Dating the terminated Users or their accesses in bulk.
• Assisting the User’s with the errors received while accessing Oracle Financials
• Maintaining Audit trial and SOX compliance and provide service for audits.

Environment: Oracle 9i/10g and MS access, MS SQL Server 2005/2008R2, Toad, SQL *Loader, SQL *Plus, Oracle SQL Developer