PROFILE:

• Experienced application architect/analyst specializing in Oracle RDBMS, OBIEE and Tableau. Over 12.5 years of experience as a team lead, techno - functional consultant and analyst in complete Software Development Life Cycle in Client/Server, Database, Oracle Data Warehouse and Business Intelligence applications from initiation through design, development, deployment, post go-live and support.
• Well versed in the development methodologies for commercial products and bespoke applications.
• Implemented Oracle Business Intelligence (OBIEE 10g) for Oracle Corporation.
• Part of the bespoke application development team at Oracle for 3.5 years - designed and developed applications (including 2 bespoke BI applications) catering to specific needs of top management and/or internal business groups at Oracle (like Partners, and Sales).
• Extensive experience and expertise in OBIEE 11g and OBIEE 10g, which include designing, building and configuring repository, creating and managing OBIEE Intelligent Dashboards, Answers, and Delivers.
• Sound knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, reporting processes in developing Datamarts and Enterprise Data Warehouse.
• More recently, part of Procurement Analytics team at Confidential - designed iPad ready dashboards for Senior Leadership Team, and numerous other dashboards for business.
• Knowledge of Oracle and deploying business solutions using Oracle applications.
• Motivated and industrious, committed to excellence, with keen ability to learn seeking higher roles and responsibilities in a challenging and technology driven work environment.
• Areas of interest include data mining and data analysis.
• One of the two developers who built the OBI implementation of MyProducts from scratch; the MyProducts solution got Oracle Applications Divisional Award from Oracle Senior VP John Wookey (who was then reporting to Larry Ellison, CEO)
• Hands-on development and management of 4 bespoke applications simultaneously for more than 2 years when at Oracle.
• Analyzed big data for genomics using PERL scripts and R.
• Excellent verbal, analytical and written communication skills, 740/800 verbal (94th percentile), and 5.5/6 analytical writing (90th percentile)).

TECHNICAL PROFICIENCY:

Languages: PL/SQL (9+ years), SQL (9+ years), PERL (3+ years), R (3+ years), Java (3+ years), C (1 year), Pascal (2+ years), LISP (1 year), FORTRAN 77 (2 years)

Scripting languages: JSP (3+ years), UNIX Shell Scripting (2+ years)

RDBMS: Oracle 11g (2+ years), Oracle 10g (1.5+ years), Oracle 9i (5+ years), Oracle 8i (1.5+ years), MS-Access

Oracle Apps/Software: Oracle Forms 6.0 (1 year), Oracle Advanced Benefits (OAB) (1.5+ years), Oracle Discoverer (2+ years)

Bi Tools: Oracle Business Intelligence (3+ years), Tableau 8.x, BI Validator

Methodologies: SDLC, TDD, Agile

Operating Systems: UNIX, Windows 9x/2000/NT/XP/Vista/7, Mac OS X

Development Tools: TOAD (9+ years), Hyperion Intelligence Designer 8.3, SQL Navigator (3+ years), Amarta (1.5 years), Visual Basic 6.0

Web Related: JavaScript (1.5 years), HTML (5+ years)

Framework: Noetix Views, Struts (3+ years)

IDE: JDeveloper (3+ years)

Others: MS Office Suite, MS Project, MS Visio, Adobe Photoshop, Microsoft VSS, CVS

Quality Related: Defect Prevention, Group Review, Introduction to CMM requirements, Confidential Practitioners Guide

PROFESSIONAL EXPERIENCE:

Confidential

Obiee/Tableau Lead/Architect

Responsibilities:

• Analysis of data for Procurement Analytics team, including numerous ad-hoc requests and deep dives.
• Designed, developed and tested complex, yet intuitive visualization solutions for the iPad version of the in-house intelligence portal for Fidelity’s Senior Leadership Team, using Tableau 8.0. Analyzed requirements for the mobile intelligence portal from feature requests provided by managers and business.
• Worked across teams in discovery and technical understanding of new data sources.
• Modeled data for Travel and Expense, Travel bookings and Professional Services estimator as per the reporting requirements, and documented the design. Designed star schemas and ensured the solution has conformity with existing dimensions. Incorporated appropriate security into design of all dashboards. Used SQL and PL/SQL for ETL, and created ER diagrams.
• Presented Travel dashboard and Travel estimator at Tableau site owners’ forum, and received excellent feedback.
• Used predictive analytics and data mining to build the Travel opportunities dashboard that helped the firm identify five areas of focus where real dollar savings could be made.
• As Site administrator for Tableau on development, UAT and production servers; managed groups and data connections, and optimized workbooks for performance.
• Led development effort on Professional Services estimator, and enhancements on various OBI dashboards. Mentored offshore team.
• Designed OBIEE dashboards along with 200 reports for different groups of users according to security level, as specified by business.
• Modeled OBIEE 11g repository using best practices in modeling dimensions and facts in star and snowflake schemas.
• Monitored adoption by business, and also performance using OBIEE’s usage tracking. Improved performance by using aggregate navigation, indexes and roll-ups.
• Acted as the subject matter expert on Procurement Information Portal for creation of a new L&D training.
• Became the ‘go-to’ person for the team on R12 related matters.

Software: Oracle 11g, OBIEE 11g, Tableau 8.0, Tableau 8.1, PL/SQL, SQL, Unix shell scripts

Confidential

Developer / Analyst

Responsibilities:

• Analysis of data for Procurement Analytics team, including numerous ad-hoc requests and deep dives.
• Created dashboards and custom reports for Procurement Information Portal, to answer business questions critical to the success of the firm, which helped several internal business groups move away from paper reporting.
• Was R12 point person from Procurement for the enterprise wide E-Business Suite upgrade to R12 phase I - inventoried Procurement’s reporting requirements, prepared requirements document, and worked closely with Development team in validation of R12 reports for history reporting as well as real-time reporting.
• Modeled OBIEE 11g repository using best practices in modeling dimensions and facts in star and snowflake schemas.
• Worked on deep dive analysis on Oracle E-Business Suite 11i data using Hyperion Intelligence Designer queries.
• Execution of best practices for the project - creation of Release notes and Frequently asked questions.

Software: Oracle 11g, OBIEE 11g, PL/SQL, SQL, Hyperion Intelligence Designer 8.3, Noetix Views Workbench

Confidential

Developer / Analyst

Responsibilities:

• Extracted sequence data from high throughput sequence runs and microarray data, after data cleansing.
• Transformed (unstructured) data after quality checks.
• Evaluated statistically enriched regions.
• Implemented algorithms for classification of data, anomaly detection, and factor analysis using curated annotations.
• Overcame challenges that involved performance-tuning code to process the humungous volume of data generated by 10000 instances of random permutation. And, determined the statistical significance of results.
• Participated in manuscript writing, and received authorship on 4 publications.
• Reviewed code written by team members.

Software: PERL, R, Unix shell scripts

Confidential

Development Lead, Developer

Responsibilities:

• Designed and developed Service Requests and Revenue (Non-CRMS) modules.
• Used multi user development environment (along with 3 way merge) to make changes in the RPD.
• Imported physical tables using OBIEE administration tool, and created joins in Physical and Business Model and Mapping (BMM) layers.
• Used implicit fact column in dimension only queries, and bridge tables to configure many to many relationship between dimension tables and fact table.
• Used initialization blocks and session variables to implement security.
• Created custom dimensional hierarchies.
• Exposed custom attributes in Presentation layer.
• Used SQL extensively for performing unit testing for the developed modules.
• Coordinated with data warehousing team to test the flow of data from source systems to data warehouse to reports. Compared data in reports against source systems.
• Used caching (with refresh) for performance enhancement.
• Worked on changes in Marketing, Sales, List and Segmentation (CRMS) subject areas for Real time reporting - modified logical definitions in Analytics Repository using OBIEE Administration Tool.
• Mentored junior developers technically.
• Implemented best practices in modeling dimensions and facts in star schema (each level of a dimension hierarchy had “Number of elements” set, and content levels were set for all logical tables).
• Coordinated with project management and QA on release cycles and release contents.

Software: Oracle 10g, Oracle Business Intelligence, PL/SQL, SQL

Confidential

Technical Coordinator / Development Lead, Developer

Responsibilities:

• Initial setup of multi user development environment for RPD modeling.
• Created web groups and assigned users permissions and privileges, using Catalog Manager.
• Designed and developed Service Requests presentation folder
• Imported physical tables using OBIEE administration tool, and created joins in Physical and BMM layers.
• Implemented best practices in modeling dimensions and facts in star schema.
• Create hierarchies, levels, and created level based measures in BMM layer.
• Exposed custom attributes in Presentation layer.
• Maintained separate code trees for the Maui upgrade.
• Used caching (with refresh) for performance enhancement.
• Validated data in the reports and dashboards against the data warehouse.

Software: Oracle 10g, Oracle Business Intelligence, PL/SQL, SQL

Confidential

Developer

Responsibilities:

• MyProducts was one of the first bespoke applications to be moved to Analytics implementation and involved a lot of design/discovery to ensure that the approach was feasible.
• Designed and developed Support Customers and Service Requests presentation folders.
• Used the multi user development environment for RPD modeling.
• Created connection pools, imported physical tables (facts and dimensions) and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, keys and logical joins in the BMM layer.
• Implemented best practices in modeling dimensions and facts in star schema.
• Included changes to in corporate cubes (aggregate tables) for performance enhancement.
• Exposed custom attributes in Presentation layer.
• Developed ad-hoc reports with different Analytics views (drill-down/dynamic, cascading style sheets, pivot table, chart, column selector, table with global and local filters).
• Created dashboards with global prompts, column selectors, guided navigation (static and conditional links), automatic drill-down.
• Configured iBots to personalize alerts on intelligence dashboards.
• Created user level security for dashboards.
• Validated data in the reports and dashboards against the data warehouse.
• Used PL/SQL packages that utilized bulk collect to import subsets of data for testing.
• Planned and executed best Knowledge Management practices for the project - created User guides, data reconciliation documents.

Software: Oracle 10g, Oracle Business Intelligence, PL/SQL, SQL

Confidential

Development Lead, Developer

Responsibilities:

• Designed and developed partner lead module.
• Created reports using Oracle Discoverer.
• Set up users with access to EUL using Oracle Discover Administrator.
• Added code for usage tracking for management
• Used cursors, ref cursors, dynamic SQL, records and collections (nested tables and varrays) in PL/SQL packages.
• Coordinated with project management, business users and QA on release cycles and release contents.
• Performed impact analysis for the move to GSI.
• Reviewed code written by juniors and peers.
• Ensured compliance with SOX for bespoke application development process.

Software: Oracle 9i, Struts, OC4J, JSP, Java, PL/SQL, SQL, Oracle Discoverer 4i

Confidential

Development Lead, Developer

Responsibilities:

• Designed and developed OPN quarter end business critical changes.
• Implemented multilingual support for OPN’s standard and worldwide agreements, which involved more than 180 files in a single release, for combinations of different languages, regions, and agreement type, in a hassle-free fashion.
• Developed complex PL/SQL packages, procedures, functions that used complex queries and joins.
• Created unique and non-unique indexes on huge tables to improve performance.
• Performed impact analysis for the move to GSI.
• Mentored new team members.
• Reviewed code written by juniors and peers.
• Coordinated with project management, business users and QA on release cycles and release contents.

Software: Oracle 9i, JSP, Java, PL/SQL, SQL

Confidential

Development Lead, Developer

Responsibilities:

• Worked as development lead.
• Provided technical solutions to issues reported by customers.
• Worked on front-end enhancements.
• Coordinated with project management, business users and QA on release cycles and release contents.

Software: Oracle 9i, OC4J, JSP, Java, PL/SQL, SQL

Confidential

Development Lead, Developer

Responsibilities:

• Designed, built, and maintained Confidential application per business specifications.
• Added code for usage tracking for management.
• Used triggers and autonomous commit for logging transactions.
• Created functional indexes to improve performance.

Software: Oracle 9i, Mod PL/SQL, Oracle Discoverer

Confidential

Module Leader, Developer

Responsibilities:

• Solely responsible for the rollout of the Phase II of action items/certifications - EOI (suspended and interim coverages) on OAB. This involved extensive analysis over 6 months to accommodate new requirements, changes to batch processes and heavy coordination with business analysts.
• Participated as core team member in transition of day to day support processes from Fidelity onshore to offshore.
• Merged code for my fixes onto Oracle’s Family Pack - F code tree.
• Worked on Oracle Form fixes, EOI related issues, Element entry, Premiums, Imputed income and related issues.
• Resolved issues reported by customers by making changes to underlying OAB packages, and/or creating PL/SQL scripts to correct the data condition whenever it was an anomaly.
• Performance tuned SQL code after checking the execution plan.
• Interacted with patching team to send out resolutions to customer reported issues.
• Appointed the technical lead for a team of 5 members.
• Mentored junior members and helped them be productive.
• Reviewed code written by junior members.
• Planned technical and non-technical learning programs for team members.
• Estimated, scheduled and tracked all work related activities for one month as interim manager.
• Created BOK as part of best knowledge management practice for the project.

Software: Oracle 8i, PL/SQL, SQL, Unix shell scripts