SUMMARY

• 8 years of extensive IT experience in Tableau, Oracle SQL, PL/SQL, Cognos and Data warehouse concepts.
• Expertise in Client - Server application development using Oracle11g/10g/9i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Hands-on experience in visualization tool Tableau 8.X and 9.X(Admin & Development), Dashboard and story.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Created PL/SQL stored procedures, functions and packages for moving the data.
• Strong skills on working with data from various sources.
• Experience with PL-SQL triggers, functions and tuning.
• Experience in working with BigQuery.
• Possess strong conceptual knowledge in Data warehouse concepts, ETL, OLAP/OLTP systems, dimensional models (Star Schema, Snowflake Schema)
• Hands on experience with basic Python scripting.
• Skills in debugging issues related to applications and various software related issues.
• Well versed with ITIL process (Incident management, Problem management and Change management) and Remedy tool
• Participated in all phases ofSoftware Development Life Cycle SDLC(RequirementAnalysis, Design, Development, Testing and Documentation).
• Strong organizational skills coupled with high work ethics. Flexible enough in learning new technologies and have exposure on working directly with client.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer and BI Consultant

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Experience in creating Metadata for the report.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• Used complex SQL, PL-SQL queries and store procedures to extract data from database.
• Developed SQL queries to generate report data from database for customer.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage
• Experience in troubleshooting and ticketing in Remedy

Confidential

Oracle, Tableau and BI developer

Responsibilities:

• Designed and developed many Tableau visualization reports and dashboards for different business requirement.
• Experience on connecting Tableau to various data sources -MS Excel, CSV, Text, Oracle, MS Access, SQL Server etc., both Live and Extracts.
• Generated server sidePL/SQL scriptsfordata manipulation, validation and materialized views for remote instances.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Ability to understand business Processes & Requirements in order to effectively develop
• Experience in troubleshooting and ticketing in Remedy
• Well versed with ITIL process and support operations.
• Experience working on business intelligence & analytical reporting platforms.
• Managed team of 10 in support activities and guided whenever required.

Confidential

Report and Database developer

Responsibilities:

• Created different types of reports likeList, Cross-tab, Chart, Conditional Blocks, Drill-ThruandMaster-Detail Reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization ofprompt parameters.
• Good understanding of dimensional modeling of Star Schema, Snow-Flake Schema Methodologies for building enterprise data warehouses.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• CreatedPackages, Procedures and indexes for the tables.
• Experience in Dynamic SQL, Collections and Exception handling.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Developed and used complex SQL queries and store procedures to extract data from database.
• Involved in ticketing with remedy and have good experience in troubleshooting issues related to the application.

Confidential

Cognos TM1 Developer Analyst

Responsibilities:

• Experience in TM1 report template creation and web publish.
• Experience in IBM Cognos TM1 9.4, 9.5 Architecture, installation, Configuration.
• Knowledgeable in enabling Single Sign On and TM1 performance tuning.
• Configure TM1 for WORKFLOW, Add Users and Groups to TM1 Security.
• Created dimensions and populated the dimensions with elements, manually and from external sources.
• Writing TI process for loading data from the source systems, flat files, cube- load etc.
• Creating Cubes to share data between cubes and adding Business Rules.
• Improving the cube performance by adding Feeders and skip check in Rules.
• Worked on Knowledge management

Confidential

System Analyst

Responsibilities:

• Created Tables, views and database instances for Webpage back-end data storage.
• Worked on developing web page contents in .Net
• Experience in working with Java script, PL-SQL and Store Procedures.
• Experience in hosting web pages for few web based applications.
• Supported and maintained the database and web based application.
• Experience in coordinating with different teams to get the work done.