SUMMARY:

• Over 6 Years of IT Experience in the field of in Oracle 11g and Oracle 12c, on Windows, AIX, LINUX, SQL/PLSQL, Tableau
• Very good understanding of RDBMS concepts like tables, constraints and normalization.
• Planned, designed and implemented application database code objects, such as stored procedures, packages, triggers, cursors, tables, views, and joins using SQL/PLSQL
• Strong Knowledge in SQL, using sub - queries, joins, views etc.
• Having very good knowledge of DML, DDL, DCL and TCL commands.
• Ability to write simple, medium & complex SQL queries.
• Extensive Data Warehouse experience using Informatica Power Center / Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle Database.
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Developed a custom Star Schema within the Oracle BIDW Data Warehouse. Developed and tested custom Informatica mappings/workflows to populate the new Schema.
• Have basic knowledge on UNIX commands and Shell scripting.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Proven myself as a dedicated, worth full and energetic well-rounded Business Intelligence/DWH background professional in growth oriented reputed organizations that gives me scope to apply my knowledge and skills and be a member of a team that dynamically works towards success and growth of the organization.
• Strong management skills, reporting and analytical/problem solving skills with attention to detail.
• Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements. Versatile team player with excellent analytical and presentation skills.
• Ability to perfectly plan and execute the given job to perfection.

TECHNICAL SKILLS:

ETL Tools and other: Informatica 9x/10x, SSIS, Tableau Desktop, Salesforce, EXCEL

Database Products: Oracle 11g R2, DB2 V9.7, DB2 V10.1, DB2 V10.5

Operating Systems: UNIX, Linux, Z/Linux, Windows

BI Tools: Tableau BI Products (desktop, server, reader & online), Business Objects.

Scripting Languages: SQL, shell scripting

Reporting Tools: Tableau Desktop, Tableau server\site

PROFESSIONAL EXPERIENCE:

Confidential, Foster City CA

Informatica/Tableau Developer

Responsibilities:

• As an Informatica developer prepare the account related docs and send it to Sending GEO approval.
• Planned, designed and implemented application database code objects, such as stored procedures, Packages, triggers, cursors, tables, views, and joins using SQL/PLSQL.
• Have worked in SQL, using sub-queries, joins, views etc.
• Ability to write simple, medium & complex SQL queries.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Developed simple and complex mappings using Informatica to load dimension & fact Tables as per STAR schema techniques and worked with Designer, Workflow Manager and Monitor.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Designed and created custom OLAP data marts in a star schema with custom metadata for the ETL/ELT procedures.
• Designed, Developed, Tested and Maintained BI Publisher reports and supported all aspects of Oracle BIP report development in support of information sharing and application development initiatives.
• Worked with project managers, developers, and end users to ensure BI Publisher Reports and SQL design specifications meet the customer's business requirements support technical design activities related to data, databases.
• Modeled the data warehousing data marts in Star join schema.
• Tableau BI Program Implementation, client consulting project delivery and advisory.
• Data exploration, Visual and discovery analytics using tableau BI product stack tools.
• Working closely with various departmental stakeholders, directors, and VP’s.
• Designing and developing the analytics, dashboards and visualizations using tableau BI and other popular BI tools.
• Formulas, computations, rules and logic development.
• Single point of contact for data, analytics and reporting requirements.
• Effective use and best practices implementation of Tableau BI for the departmental reporting and analytics needs.
• Have extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Monitor the use of the database to identify opportunities for performance improvements.
• Worked on change management process.
• Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughput.
• Experience on Visualization of data and creating best report.
• Created Standard, Cross-tab, Sub reports and Turnaround Time reports.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (9.x) reports.

Environment: Oracle 11g, 12c, DB2 V10.1, DB2 V10.5 on LINUX, AIX, WINDOWS, SQL Developer, Toad

Informatica /Tableau Developer

Responsibilities:

• Writing PLSQL. Case processing is providing solutions to customer specific cases through stored procedures, primarily to solve the disputes.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Have worked in SQL, using sub-queries, joins, views etc.
• Ability to write simple, medium & complex SQL queries.
• Having good working experience in DML, DDL, DCL, TCL commands.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers..
• SQL query tuning, query optimization, creating proper index to make use of better access plan.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time.
• Built star schema model in RPD at the Physical level by joining fact table with various dimension tables.
• Worked on building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers. Expert knowledge of report development execution in a complex environment.
• Developed complex BI Publisher reports and have good Oracle SQL
• Created Snowflakes and Star Schema to perform data modeling for proposed architecture.
• Produced pixel perfect reports using BI Publisher, building Complex Data Templates, data model, RTF / E-Text / Excel Templates, setting up bursting for ERISA Interim
• Modified existing forms, reports, and graphs as per the enhancement.
• Developed PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Moved data from one database to other database, Used SQL*Loader for data migration.
• Responsibilities included designing and developing complex mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks.
• Working with the Tableau desktop, and tableau Server\site for tableau BI reporting.
• Responsible for the end-to-end implementation of tableau BI Phases.
• Interacting with Product manager and Data quality analyst for gathering the business report requirements and various cross departmental users for the report requirements, clarifications and tableau end user report trainings.
• Designing the mock ups and proto types of the dashboards.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Building and publishing customized interactive reports and dashboards using Tableau server.
• Worked with action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Oracle 11g, 12c, DB2 V10.1, DB2 V10.5 on LINUX, AIX, Windows, Tableau, SQL Developer, Toad

Informatica/Tableau Developer

Responsibilities:

• Have worked in SQL, using sub-queries, joins, views etc.
• Understanding of the tableau dashboard business requirements of various source systems.
• Responsibility, ownership and accountable for the tableau desktop dashboards building and tableau server administration.
• Understanding of the entire system integration project including the 3 layers of the project such as source (applications), data (composite virtualization) and presentation layer (tableau visualization).
• Translation of business requirements to dashboard technical requirements.
• Creation of FSD for tableau dashboards with the help of BA.
• Creation of mock ups\proto types dashboards in PPT and Excel\Visio for business users.
• Design, development and publishment of various tableau visualization dashboards.
• Design and implementation of tableau dashboards layout.
• Publishing and authoring the dashboards from tableau desktop to tableau server.
• Ability to write simple, medium & complex SQL queries.
• Having good working experience in DML, DDL, DCL, TCL commands.
• Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughput.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time.
• Modified existing forms, reports, and graphs as per the enhancement.
• Developed PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Moved data from one database to other database, Used SQL*Loader for data migration.
• Using Tableau Desktop, created visualizations and dashboards.
• Developed Tableau workbooks from multiple data sources via Data Blending.

Environment: Oracle 11g, 12c, DB2 V9.7, DB2 V10.1, DB2 V10.5 on LNUX, UNIX, SQL, Tableau, PL/SQL.

Informatica /Tableau Developer

Responsibilities:

• Worked with IDQ to analyze the transactional data for the Products and create scorecards for the same.
• Understanding the data virtualization and pulling the data from source system and middle layer to the end presentation layer Tableau.
• Design, development and deployment of tableau reports.
• Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.
• Installation and configuration of Tableau server in dev. and production environment.
• Authenticating the tableau dashboards before publishing to tableau server.
• Publishing the developed reports to production Tableau server environment.
• Security implementation to tableau server reports based on user community.
• Performed the back up and restoration activity, server performance monitoring of Tableau server for environmental changes, change management, or for any software upgrades or patches.
• Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.
• Tableau extract incremental strategy execution, extract refreshment and tableau extract scheduling thru the tableau server.
• Maintenance of various published dashboard s to tableau server (live connection or extract or data source).
• Transformation of some of the clarity reporting to tableau dashboarding for the better look and feel and tableau user’s interactive visualizations.
• Developed various Informatica mappings & mapplets to read the data from various source systems, validate the data against the complex business rules and the load the data into the Global Ledger.
• Designed and developed the ETL logic to process multiple files for a single product using Indirect loading and generating multiple files for the same product using Transaction Control transformation.
• Created a complex view to look up the static data for the various feeds from the database table maintained by Business Users.
• Implemented concurrent workflow option to execute large number of multiple workflows concurrently.
• Fine-tuned various long-running feeds by implementing Informatica partitions, splitting the Look up cache, using Persistent caches and enabling SONG feature (Session on Grid)
• Designed and developed Unix Shell scripts to generate the run time parameters for the underlying ETL Informatica workflows from the DB Metadata entries.
• Perform unit testing and provide support to the users for the defects raised in the UAT environment
• Perform peer review of the code and preparation of the deployment plan after discussing with multiple stakeholders.
• Co-ordinated with Business users, DBA teams & other stakeholders for any issues identified in UAT and work on the resolution
• Developed Tableau reports to perform YoY, quarter over quarter, YTD, QTD and MTD type of analysis.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

Environment: Informatica Power Center 8.6, ETL, Oracle 10g/9i, DB2, PL/SQL, TOAD, Tableau, SQL*Loader.