About DMGData Management Group specializes in helping companies in the Finance industry manage, secure, and modernize their data. We work with CIOs, CTOs, COOs, Data Governance Leads, and more to ensure their data and analytics strategy is robust, forward-thinking, and value-generating.

Role: Team Member/Tech LeadTechnical Environment: Oracle 12c, PL/SQL, Talend 6.3, ODI and UNIX Shell ScriptingDescription: Yes Lifecycle Marketing brings to market a ground-breaking approach to technology and services that holistically aligns email and digital marketing services, data and database marketing services, with data, analysis, strategy, and creative to accommodate today’s multichannel marketer.Responsibilities: Implemented Digital Marketing database for Stage Stores (SS), a leading retail departmental store based in Houston, TX and West Marine, a leading boating supply and fishing retail stores based in Watsonville, CA. Design POC and create standards for ETL using Talend. Integrate PL/SQL Packages with Talend with proper user exists and error handling. Design table driven automation standards using Unix Scripting and PL/SQL. Design and develop Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance. Data Conversion and integrate historical SS data in the YLM database. Created various PL/SQL packages and Talend to leverage Analytical information to the end user. Interface with UNICA campaign to maintain campaign information as part of customer communication. Integrate Customer Communication it with various response interfaces to maintain OptiIn/OptOut information. Designed interfaces for generating Customer Data Hygiene and integrate it with DP and MCD process.

 Design and develop Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance. Interfacing with key Ika products like Medicare Gateway, Claims, Billing, Commission and CRM. Implement complex transformations using Oracle ODI. Customised Knowledge Modules for ETL. Integrated multiple source technologies like Oracle, SQL Server, XML and Flat Files using the appropriate topology. Used CDC and Journalised Data for incremental data load. Develop complex reports using multiple data providers, user defined objects, aggregate objects, charts, and synchronized queries using MS SRS Reporting Services. Train and manage developers, advising other groups in organization on Oracle development, data warehouse development, and ETL development best practices. Conduct code walkthroughs and review peer code and documentation. Build efficient Oracle packages for processing fact and dimension tables with complex transforms and type 1, type 2 and type 6 SCD. Created system for capturing, reporting, and correcting error data. Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production. Gather requirements and design of data warehouse and data mart entities. Designed in design of scalable, reusable, and low maintenance ETL templates. Overseeing unit and system tests and assisted users with acceptance testing.

Technical Environment: Oracle 10g, PL/SQL, Oracle Reports 10g, Sun Solaris Description: The project is being executed for the Pension Benefits Guarantee Corporation (PBGC). It entails re-engineering the existing Oracle Reports, build a Data Warehouse using Materialized Views and to provide PL/SQL support for the existing application. Responsibilities: Handling the conversion of existing JSP reports with Oracle 10g Reports; Release and Configuration Management of the application. Build a Data Warehouse using Materialized Views In both Fast and On Demand refresh mode . Providing PL/SQL support. Liaising with QA and DBA Teams for timely release of the project. Writing Shell Scripts and Oracle packages. Performance tuning of the application. Collaborating with Team Members to update them about project requirements, as well as to address project-related and technical issues.

Technical Environment: Oracle 10g, PL/SQL, Oracle Designer 10g, Oracle Reports 10g, HTML, JavaScript, Sun Solaris Description: The project is being executed for the Virginia Department of Health and Development for the Office of Emergency Medical Services. It entails re-engineering the existing Oracle Forms-based system by removing all the database redundancies and web enabling the application using Oracle Web Tool Kit. Oracle Designer has been extensively used in data modelling and generating Table API's. Responsibilities: Conducting gap analysis in a phased manner. Liaising with business users for gauging requirements. Preparing Requirement Specification Documents and obtaining sign offs from client. Creating new data model (using Oracle Designer). Generating web application using Oracle Web Tool Kit. Guiding Teams Members for creating test cases, handling code reviews and performing Unit Testing. Handling the conversion of existing SQL Batch reports with Oracle 10g Reports; Release and Configuration Management of the application. Liaising with QA and DBA Teams for timely release of the project. Writing Shell Scripts and Oracle packages. Creating application’s screens using Oracle Portal. Executing performance tuning of the application. Using Oracle built-in packages to manipulate BLOBS, and Materialized Views to generate aggregate reports. Collaborating with Team Members to update them about project requirements, as well as to address project-related and technical issues.

Technical Environment: Oracle 10g (database running on Sun Solaris OS), Oracle Forms 6i/ Reports 6i, PL/SQL, PVCS, AutoSys, Linux, Oracle 9iAS Application ServerScope: The ECS supports real-time claims payment processing & communication generation. It is linked with Policy Admin Systems and Payments System through EDI. The ECS is divided into multiple sub-systems including Death Claims (DC) System, Matured Endowments (ME) System and Periodic Payments (PP) System. Responsibilities: Carrying out detailed analysis of client requirements. Designing new job schedules using Appworx. Finalising High Level Design (HLD) documents & functional specifications. Writing UNIX Shell scripts for automating jobs. Designing and coding PL/SQL Programs Procedures, Functions, Packages and Triggers. Carrying out performance tuning of the application. Handling complete project management activities including creating project plan, quality plan, configuration management plan, work specifications, etc. Overseeing the verification, storage and maintenance of all software loaned to the company by the customer, throughout the project lifecycle. Providing techno-functional guidance to the team members. Maintaining coordination with Client & Onsite Coordinator at the project level including status reporting, query resolution, etc. Allocating projects tasks amongst team members; undertaking team building activities to upgrade their skills.

BreCon Geneva Development for British Telecom, Ipswich, UK Technical Environment: Oracle 9i, PL/SQL, Geneva for Billing, LinuxScope: The project entailed the use of Geneva, a comprehensive & generic billing tool for the customisation, design and preparation of billing plans & tariffs for existing as well as new telecom service products.Responsibilities: Conducting a detailed analysis of requirements put forth by the client and preparing Configuration Document.  Modifying/ developing Oracle PL/SQL Procedures, Functions and Packages. Handling the configuration of Geneva as per the required billing plan. Creating Unit Test Cases and facilitating Unit Testing as well as bug fixing of the application. Coordinating with the VV&T team for achieving successful final release of the Billing Solution.  Communicating on technical aspects with the client and the Onsite Coordinator.  Executing the creation of views, indexes and clusters. Developing SQL scripts for release management.

GAIC-Trucking for Great American Insurance Company, Cincinnati, OHRole: Team LeaderTechnical Environment: Oracle 9i, PL/SQL, Java Servlets, HTML, XMLScope: GAIC is a part of American Financial Group, chiefly engaged in property and casualty insurance businesses. The project involved the use of Renaissance, a proprietary software product of STGIL catering specifically to the Property and Casualty Insurance sectors. It handles various functionalities covered under Insurance like Underwriting, Rating, Billing and Claims through well defined parameters.Responsibilities: Leading the Claims Team and handling the preparation of the functional requirement documents. Working on the modification/ development of Oracle procedures, functions and packages for claims.  Creating Unit Test Cases and designing various interfaces to map with existing legacy systems.  Collaborating with the QA Team and conducting Unit Testing of the application. Maintaining communication with Client/ Onsite Coordinator to address technical aspects. Uploading data and generating reports using SQL* Loader.  Developing application/ database triggers to enforce integrity constraints & Triggers to update Audit Tables.