Summary:

• Over 14 years of diversified IT experience in software design,development and various Architectures and Domain like Insurance/Healthcare.
• Strong expertise in SDLC, Oracle ERP Financials ,QA and Compliance procedures.
• Worked on the Data Management, Vendor Management and Sourcing.
• Lead Major Projects and worked for Public listed companies in Asia Pacific and in the US.
• Extensive experience in Oracle database RDBMS, 9i/10g/11g-XDB , Marklogic NOSQLDB .
• Worked with the MSBI- SQLSEVER Oracle BI , Data warehouse design, Implementation, Intergation and Business Intelligence.
• Worked on XML and followed various standards like the ACORD standard.
• Hands-on in UNIX/LINUX/PERL, Shell Scripting,SSH, FTP and SFTP File transfers.
• Architect Solutions on Bigdata/Hadoop, used VMWARE for Cloudera

Oracle Systems Architect

Responsibilities

• Worked as An Architect engaging business and IT.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Worked Organizing all existing data models, data flows and data dictionaries into a MetaData Repository.
• Created physical /logical models of SQL/Oracle databases
• Worked on Complex SQL queries and created XML files XMLDB
• Worked on oracle ADF/OAF , Forms and Reports.
• Worked on the dunning letters, P L reports and Balance sheets
• Worked on Oracle upgrades from 10g to 11g.
• Developed QPS which is based on the interwoven Teamsite
• Worked on the TeamSite -SitePublisher for Content Management.
• Researched and compared Oracle Istream and Oracle Documaker
• Created the Content management Master document called the CMS and the corresponding cds files for Oracle Istream.
• Created XML file for the include instead of the direct include in to the batch processing
• Created data center operation jobs to monitor DWH,BACK-UP storage.
• Created to run the CLG files and include them as a part of the batch processing.
• Architect various document types like VOLLIFE, ADD , VSTD, LIFE, MULTILINE CONTRACTS, booklets , certificate of insurance and Policy of Insurance.
• Worked with Macros and page flows before and after pages with counts .
• Created Signature/Logo changes for the documents from a centralized point.
• Worked on Master Data Management/Meta Data Management.
• Data Analysis, data modeling, data quality, data integration, ETL and metadata mappings documentation.
• Worked on Java,ETL tools like Informatica and Altova Mapforce.
• Production support for publishing the documents/REPORTS and errors/exception encountered during publishing.

Environment Oracle 11g,PL/SQL.SQL,TOAD,UNIX,Informatica power center,meta data manager, Power exchange ,Oracle, map force, Fujistu Prime Power Sun Solaris 8.0, Oracle Discoverer, Business Objects, Crystal Reports TRUE COMP , Oracle Istream calligo

Senior Oracle

Responsibilities

• This is home grown project for integration of oracle HRMS to payroll.
• The Confidential data is on a Data warehousing Effort with oracle and working on this challenging project.
• Data Architect information flow between various Applications.
• Created a data dictionary for the Payroll interfaces and its tables .
• Created a corporate Metadata Repository.
• Part of Project Management group performed Resource management, Conflict resolution, Risk analysis ,Impact analysis and Task management
• Worked on the cross platform applications and operated as the Application Point of Contact.
• Developed Oracle objects written in PL/SQL develop new analytical methods and/or tools as and when required.
• Used ERWIN extensively for data modeling Used various integrators Oracle Web logic ODSI to pound data from Different Data stores.
• Worked on the Meta Data Management and Reviewed Coding standards
• Worked on Business Object and created Universes,Created Dash boards for the reporting using WEBI , crystal reports and Cognos
• Presented use-cases to the steering committee/stake holders via UML diagrams
• Created BI queries with SQL analytics functions RANK, DENSE RANK, and REPORT TO RATIO .
• Customized forms and reports for the HRMS payroll application.
• Worked on Oracle OAF and Oracle ADF Form Personalization and Customization
• Created Ceridian Interface for the Canadian Payroll
• Recommended solutions for new interfaces and web services.
• Architect the information flow between Oracle HRMS and Payroll
• Provided recommendations to the Kronos and Stores team on interfacing data.
• Supported on going interfaces and scheduling using the BMC scheduler
• Used Oracle Discoverer and XML publisher to create reports
• Used XDB for generating the calling the XML publisher.
• Integrated support for Pay slip application and help DBA for pay slip application Tuning
• Worked with Oracle Advance benefits team and create Payroll to Benefits center Interface.
• Used Oracle Alerts to create mail alerts for check reconciliation.
• Integrated the Canadian Payroll Data with Oracle APEX and created the underlying view and tables.
• Created ETL jobs for HRMS data using Oracle and Informatica
• Worked on Multi org, currency, Legal entity Worked on chart of Accounts.Accomplished complete SDLC along with Production support for the entire web based services and Database Used FND LOAD tools.
• Worked with Vendors like ADP and resolved the technical issues

Environment Oracle 11i,ERWIN,Data modeling, Rational rose UML , SQL, PL/SQL, SQL Plus, Forms 10g, Reports 10g, TOAD,SQL server, Informatica, SSRS, Fujistu Prime Power Sun Solaris 8.0, Oracle Discoverer, Business Objects, Crystal Reports, Oracle E-business Suite 12, 11.5.10, 11.5.7 Oracle ERP .

Independent Consultant

Responsibilities

• ETL, Oracle, Policy Printing, Health care Claims, Auto Insurance, Property and Causality
• Team lead, Interviewed candidates for the Position of Developer /Support and defined objectives of the roles and responsibilities
• Participated in the Project Kick off Meetings, Created Project Plans, Conflict resolutions and Resource management sheet.
• Managed of Policy related information using XDB and worked with Vendors like LEXUS NEXUS for Commercial Lines - Auto Insurance.
• Worked on T-SQL,SQL SERVER SSRS,SSAS , Oracle Application Servers
• Created Source and Target mapping using Informatica and performed ETL.
• Worked on Service Oriented Architectures.
• Architect solution for Policy Batch printing Caligo, I-stream, EMC XPression .
• Worked on the Data models, Meta data Gap Analysis, solution ROI and Integration.
• Created PAD document for storing the Architectural details and information/process flow.
• Created High Level design Documents and Low level Design Documents
• Created Technical specifications documents and provided walkthrough to the developers.
• Verified the IMPORT FILES/XML/Data sources supplied to the EMC XPression as input and verified the PDF Output from XPression after development.
• Prepared the Risk/issues document and maintained it in Share point.
• Prepared Impact analysis document and filled in the Go or NO-GO scope.
• Prepared release documents for the Build and worked with release engineering team on the issues with the build.
• Architect document printing for the xPression,xRevise,xDesign,xStudio,xAdmin,xPresso,Oracle Istream Caligo -author, assembler ..
• Used Business Intelligence tools such as Oracle Apex/Oracle Forms/Oracle Reports, Jasper reports, Business objects, ORACLE RTD Real-Time DECISION studio, JMX -Wells Fargo-CRM-Oracle Right Now leapfrog Worked on the OBIEE.
• Worked with Care centrix Facets Plan,Payor, Payable, Provider module and Health Claims,RDS Implemented Production support best practices following the ITIL Process , help-desk ticketing and Issue Prioritization.
• Performed Mark Logic Administration and Development phase support.
• Designed and developed XML and related technologies includes XPath/XQuery, XSD and XSLT.
• Created Web services SOAP, REST /Java API interactions with Mark Logic server.
• Worked on Shared Services for the file transfers to Hadoop HdFS
• Worked on XCC, Mark Logic Content Processing Framework.
• Gained Knowledge of confusion matrix and ROC area from the Data Analytics team.

Environment Oracle 10g/11g, TOAD, PERL, UNIX, Informatica, Dos Batch Script.

Systems Analyst

Responsibilities

• Data model GL interfaces with the Data warehouse team and implementation of various strategic initiatives around Meta Data Management, Master Data Management, Data Quality, Data Architecture Policies, Standards and Governance.
• Co-Lead the Effort of the Data warehouse, OLAP, Data Mart.
• Technical and Functional Expertise in various Domain of business comprising Oracle Financial Modules Payables, Receivables, GL, FA and Projects.
• Defined Chart of accounts, Currency and Calendar, Multi Language, Multi Reporting Currency, Multi Organization, Set of Books.
• Worked on Daily Rates setup for Foreign Exchange and multi currency Journals.
• Evaluation of the Accounts for Cash, Bank, Derivatives, Equities, Shares and set up the Posting.
• Involved with the Team for Budgeting and Tax Tax codes .
• Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, Receivables and Project Accounting.
• Used Oracle APEX for reports creations and fine tunes SQL sources.
• Interfaced Data from the Legacy systems to Oracle.
• Interfacing Point of Sales Front Office Sales with the Account Receivable Module.
• Worked on the Accrual of the Receipts interface that are not invoiced yet
• Worked on Reports/Forms customizations, Interface customization and enhancements RICE .
• Helped users to Run the Depreciation and Check the profit and Loss Reporting.
• Worked on Oracle ADF, and Oracle OAF Form personalization.
• Used advanced PL/SQL concepts including Global Temporary table, Collections Bulk Collect, Arrays, Nested Tables and PL/SQL Tables , Pipeline Table Functions for performance improvement of the application
• Used SQL Loader for loading data into main schema from different data sources.
• Worked on TCA MODULES, FND tools and JTF tools.
• Created Dunning Letters custom format for Bad Debts and worked on Credit Risk reports.
• Performed System Administration for the entire Financials and Oracle HRMS module. Created users, responsibilities, menu, functions, forms based on the user access matrix. .
• Worked on Oracle enterprise Bus SOA , pass inbound /outbound transactions.
• Wrote stored procedure, packages, Functions, triggers, shell scripting UNIX batch jobs for the automation and scheduling of jobs. At the application level to Register Concurrent program.
• Defined Request set and create the DFF, FLEX FIELDS.
• Architected Bank statement Loading and interfacing with Oracle GL, AP and CM.
• Defined exchange rates Daily , Bank statement mapping and GL reconciliations.
• Worked on the Void checks for AP as report and helped in the accounting period closing
• Loaded Patient information and Vendor information using SQL loader Request Set.
• Installed the budgeting software called as the SRC software, loaded budget Excel sheet, with accounts and amount.
• Created Monthly Quarterly, Annual reports, PL REPORTS using crystal reports and WEBI.
• Worked with Oracle Metalink Trained users to use tools like Discoverer, desktop ADI and web ADI.

Environment Oracle 11i, SQL, PL/SQL, SQL Plus, Forms 6i, Reports 6i, TOAD, Jujitsu Prime Power Sun Solaris 8.0, Oracle Discoverer, Business Objects, Crystal Reports, Oracle E-business Suite 12, 11.5.10, 11.5.7 Oracle ERP .

System Analyst

Responsibilities

• Worked with external customers like UOB bank worked on UOB Interface with connect direct for windows.
• Data modeled Bank interface files, transfers and loading the file into Oracle.
• Worked on oracle Library, PL/SQL, FUNCTIONS, PROCEDURE, triggers, package, and package body.
• Automation of Siebel jobs and DDL of the Siebel Tables Insert ,Purge ,update
• Created forms and reports to automate the PDF printing client/Agent policy letters using Acrobat PDF files from windows 2000 server generated by the oracle report server.
• Solve the production issues related to Agency management system, Agency web portal using Java, ASP. Write Batch Scripts in Dos, FTP.
• Created reports using Oracle APEX and Forms for Data entry
• Architected the C D connect process, worked with FiLE ZILA, SFTP for bank file transfers.
• Worked on SQLSERVER 2005, T-SQL and created reports SSRS and used Management Studio to create objects.
• Worked on the Data Extraction and interfacing with the SQLSERVER.

Environment Oracle 10g, SQL, PL/SQL, SQL Plus, Forms 6i, Reports 6i, TOAD, WIN 2000, COGNOS, Data Stage, ERWIN, PHP, PERL, Oracle ADF, Oracle OAF

Senior Oracle Applications Developer

Responsibilities

• Team led the effort for oracle financials AP, GL, CE, Project costing, and FA and software maintenance, support.
• Carried out Asia Pacific regional Role out
• Lead creative approaches to problem solving that Influence decisions across the enterprise related to meta data management and master Data management
• Worked closely with ORACLE-metal ink to resolve issues
• Worked on oracle products like SQL PLUS, SQL loader.
• Registered the new Concurrent programs, Defined Request Set using the FND tools.
• Provided solutions based on the problem INCIDENT Logging and trouble shoot issues in Production environment
• Extensively Coded in Oracle PL/SQL, wrote packages, functions, triggers, java stored procedures.
• Performance Tuned applications with Very Large Database. DBMS STAT .
• Created IMR, IQD files and generate cubes FOR COGNOS.
• Trained users to use tools like Oracle discoverer, ADI.
• Derived the message from the IBM MQ series to oracle DB.
• Participated in the Upgrade of oracle application version 11.5.10 and Data base from 8i to 10g.
• Worked with Auditors to give the extraction of masked data as the result of queries from the production environment. Work with banks and build interfaces for GIRO, Wire Payments and file transfers.
• Worked on DFF,KFF,OAF,ADF
• Worked closely with BI Team to Define the Data extraction, Transformation Load and publishing reports,APEX and wrote complex PL/SQL queries.
• Wrote Shell script for FTP, Oracle reports .RDF files to Server.

Environment Oracle 8i, SQL, PL/SQL, SQL Plus, Forms 6i, Reports 6i, TOAD, WIN 2000, COGNOS, Data Mart, Test Director, Mercator, Fujistu Prime Power Sun Solaris 8.0

Technical Consultant

Responsibilities

• Migrated data from one subsystem to another From SQL Server 2000 to Oracle Database 8i
• Wrote codes in JSP, JAVA BEANS, SERVLETS java swing, JDBC codes,ASP, VB Script, Java Script
• Mentored team of 10.Created oracle reports, oracle forms based on functional specification from BA.
• Wrote technical guidelines and technical specification for systems involved.

Environment Java, JSP, SQL Server 2000, Windows Server 2003, Java Web server, Apache Tomcat, Java beans, ASP, Oracle 8i.