Experience

VariQ

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Engineer / Data Warehouse SME

  • Sep 2015 - Present

  - Worked and collaborated with team to migrate OLAP oracle databases from data centres to AWS (Amazon Web Services) environment efficiently.- Helped team in migrating Oracle reports to Jasper reports under strict deadlines.- Worked with team to design and built data marts using Redshift and Big Data technologies.- Worked with customer to integrate SAS reporting with Redshift cluster to build and run adhoc reports. - Resolved several production issues and implemented performance tuning strategies on SQL queries and adhoc reports. - Communicated and presented team accomplishments biweekly to client executive briefings. - Performed meticulous analysis on data from multiple sources per client requests.- Provided strategies to enhance performance of Redshift Tables by choosing appropriate distribution and sort keys. - Delivered highly business critical and time sensitive reports and extracts to clients consistently in timely manner.



CSC

• United States
• Information Technology & Services
• 700 & Above Employee

• Data Warehouse SME / Database Specialist

  • Oct 2008 - Sep 2015

  - Interfaced with clients to gather requirements and presented solutions to their issues related to ADHOC reporting. - Collaborated with team and configured OBIEE environment and to build a prototype for clients to visualize OBIEE strengths in building dashboards and scorecards. - Wrote advanced and optimal SQL queries to retrieve data from complex and large databases.- Provided technical support in release deployments and tested ADHOC environments for impact and issues.- Crafted data extracts requested by clients using complex SQL scripts and stored procedures and stored data in text files.- Using Oracle Discoverer 10g/11g, Created new Business Areas in the End User Layer and made changes to existing structure to meet client’s needs and requirements. - Resolved various customer issues that involved server patching and tuning of other configuration parameters on the server.- Trained and wrote instructions for end users/developers on how to use Discoverer viewer/Plus. - Analyzed ETL mappings using Oracle Warehouse builder and helped the team debugging some ETL issues.- Worked on writing project plans to stand a Portal to host all the web applications and provide single staging place for all the applications.- Customized Discoverer Viewer header with client’s Logo and a search box and removes Oracle copyright and places client’s standard footer in Discoverer Viewer.- Enhanced Query performance in Discoverer reports using hints, indexes, explain plan and by setting appropriate Discoverer environment values such as records per fetch and etc.



Grant Thornton LLP (US)

• United States
• Accounting
• 700 & Above Employee

• Senior Consultant

  • Feb 2006 - Oct 2008

   Created and redesigned Informatica mappings and workflows to load data into data marts. Created Portal pages and Page Groups in Application Server Portal for these reports and to display these reports.  Created Users in Oracle Portal and managed controlled access of these users to all the pages in that application. Created EUL and populated EUL with various types of objects (folders, Item classes, hierarchies, summaries and etc). Exported/Imported EUL objects between different Application Server Instances(Dev, Pre-Prod and Production). Created complex Discoverer reports (Detail and Summary) involving complex logics and calculations with both Discoverer Desktop and PLUS.  Customized Discoverer Viewer header with client’s Logo and a search box and removes Oracle copyright and places client’s standard footer in Discoverer Viewer. Enhanced Query performance in Discoverer reports using hints, indexes, explain plan and by setting appropriate Discoverer environment values such as records per fetch and etc.  Designed and implemented appropriate Database Role level security and sharing of reports between users.



INFONETIC

• Information Technology & Services
• 1 - 100 Employee

• Senior Consultant

  • Nov 2006 - Feb 2008

   Using Discoverer Administrator, created, imported and exported End User Layers (EUL) and Business areas to meet the reporting environment requirements. Using Discoverer Administrator, set standards for scheduled workbooks and queries and registered objects in already defined EUL.  Assigned user specific privileges and assisted to rectify any issues with their accounts. Developed new reports and also maintained and enhanced existing discoverer reports. Developed application in Oracle APEX to develop data dictionary for the management to facilitate exploring table structures and updates on Data warehouse project.  Created Discoverer portlets and incorporated these portlets with Oracle Portal.  Designed and developed pages in Portal and displayed Discoverer reports on these pages.



Administration for Children and Families, DC

• System Developer

  • Sep 2004 - Apr 2005

   Supported efforts as lead resource and developed complete customized Web applications in Oracle APEX and provided training to end users.  Using 11i Application, designed a customized application OCS / MIS to fully meet the client’s specifications. Designed and developed Oracle Reports and Implemented Parameters to generate the required data set of the end user. Designed master-detailed Oracle Forms and applied these forms inside the skeleton of Oracle 11i APPS . Using Discoverer Administrator, created business areas and assign security and privileges to multiple discoverer users.  Designed Discoverer Reports and integrated these reports into the Application. Using TOAD , developed PL/SQL procedures for forms 6i and reports 6i and integrated these forms and reports into 11i APPS.  Designed web based applications using 9i DS HTP utility provided for PL/SQL integration with HTML to convert into procedures. Designed and developed extensive user friendly forms and generated reports to visualize and analyse the data.



Filnet Inc

• Web/Database Developer

  • 2004 - 2004

   Developing Stored Packages to validate and populated data to interface tables. Developed PL/SQL Packages, Functions, and triggers for various web applications. Developed and enhanced Discoverer reports and managed scheduling and sharing of these reports. Imported and Exported databases across different RDBMS such as Oracle, Mysql and Access using ODBC. Imported and Exported databases across different versions of Oracle such as 8i and 9i. Designed web pages in HTML / XHTML using Macromedia Homesite and Dreamweaver.  Wrote JavaScript to manage pop-ups and also to control the page flow. Environment: - Oracle version 8i(8.1.7.1.5) Windows 2000/NT 4.0(SP6). Oracle version 8i (8.1.7.0.1) Linux. Java, HTML, JavaScript , Oracle Developer 6i Tools, Discoverer 4.1.