Rekha Karuppiah

­­Rekha Karuppiah - Business IT Solutions Aligning information technology with business to create innovative solutions To pursue a career in the field of Information Systems design, application development, data analysis and research, with expertise achieved through educational background and experience. Skilled at translating business objectives into technological requirements. Core competencies include: ▪ Application Architecture ▪ Lifecycle Customer Value Management ▪ Analytics ▪ Business Analysis & IT Consulting ▪ Business Process Analysis & Re-Engineering ▪ Software Development Life Cycle resident status: us citizen Education Bachelor Degree in Computer Science & Eng. (B.S.) graduated 12/2001. Madras University, Tamil Nadu, India. Certifications Certified from CITI (Research), University of Miami. CITIZENSHIP status Citizen of United states Professional Training In-depth training in Java : Southwest Community College, Memphis, TN. Database extensions: National Institute of Technology (in Management Information systems) technology Skills C, C++, SAS, Sagent, Datawarehousing, Business Objects 3.1 and 4.0, Cognos reportnet, cognos query studio, Cognos data modeling (powerplay and framework manager), Erwin, BO XI– Business objects Designer, Web Intelligence, CMC, Java, HTML, XML, SQL(sql server, oracle, teradata), stored procedures, Crystal reports Salesforce, Oracle, Oracle Designer, Oracle Discoverer, OBIEE, TOAD, oracle form builder, oracle report builder, Imaging, Cerner, Visual Basic, Tableau Rekha Karuppiah – Résumé Professional Experience Mid South Literacy2017 - 2020 Database Mentor Resource for business analysis, project management, database design and report development. Worked on a project for Midsouth literacy and engaged by them on a need basis. Fedex Services2009 – 2014 Business Objects Administrator/Developer( Enterprise DataWarehouse) Development and Administration resource for the Enterprise Datawarehouse at Fedex’s World Technology Center. Completed Migration from 3.1 to 4.1 Trained Users and Developers in 4.1 Created reports using crystal reports and troubleshooted issues like reports with long execution time. Used 2008 and 2011 versions. Created Dashboards. Created queries using sql. Worked on setting up the Users/Groups, assigning the privileges to the Users and folder security using Central Management Console (CMC). Developed Universes by defining joins, cardinality between tables, creating prompts, applying contexts and alias to resolve loops/traps and checked the integrity of the Universe in Business Objects Universe Design. Data Modeling. Created Business Objects reports involving complex queries, sub queries, Unions, Intersections and Minus. Created Cross Tab, Master Detail reports. Scheduled the Reports using CMC. Worked on SAP vendor management Incident and Change Management requests. Used lifecycle manager to move BI resources from test to production. IT Consultant(Marketing and Customer Analytics) Support Insight Analytics group and provided infrastructure support using PL/SQL, SQL, SAS, BI and UNIX in oracle and teradata environment. Responsible for  integrating vendor platforms (like Visionary and Axiom) with Fedex enterprise Datawarehouse (EDW) to keep Fedex EDW in synch with vendor platform. Created high level design documents and reviewed source to target mappings and aggregations to make sure that it meets the needs of the analytic user base. Maintain and add updates to daily automated file feeds to pricing admin. Created process flow and data flow diagrams using Visio to reflect how the partner databases and call center system will interact with imarket Fedex database. Generated target customers for campaign execution through third party vendors used by fedex for direct mail, social, sales and alliances. Involved in email marketing support and provided interfacing for email contact loading processes for customer emails from axiom. Documented all upstream data points and downstream systems. Subject matter expert and go to person for providing clarification on business processes and data sources to business analysts and developers. Accountable for the data quality of the data fed into the Enterprise Datawarehouse from other Operational Facilities like Fedex Kinko’s and Fedex freight. Reviewed the extraction logic and transformations used for the loading process. Provide reporting, analytics and application development in the enterprise Datawarehouse. Design of processes to integrate Fedex Office(Fedex Kinko’s) and other partners such as AMEX and Delta airlines and support processes to assess profitability in partnership for Fedex. United Health Care, CT Ld (Technology and Analytics for Product Management) 2008 – 2009 Provide Reporting and Analytics support using data sources such as Galaxy, UCAP, Prime, ACIS, PAS, Rosetta, and CES using analytical tools like sagent. Involved in identifying all data sources like prime and acis that impacted installation of all UHG products across all regions. Used this information to drive unified reporting architecture and creation and of BI cubes. Developer resource for creating galaxy extracts. Active user of cognos reportnet in HPDM and liaison between Ingenix and UHC to resolve issues in the cubes and ETL data loads. Acted as a subject matter expert for UCAP, and provided business and technical clarification for open issues. Provided analytical support for galaxy tables that includes customer, member, product, provider, Claims(detail knowledge migrations from other platforms that are non unet), contracts, financial data such as membership and revenue that includes Net paid, revenue pmpm, gross margin. Create scorecards every month that get published to the CEO that includes gross sales and incremental growth components using cognos framework modeling. Redesign of PCID for product organization and monitoring accuracy. Involved in very detail data validation and testing processes for quality control to support data intregrity and serve customers with high quality data that drives business decisions. Created several market analyses for Lombardi projects using sales pipeline information. Experience with tuning reports to reduce galaxy costs. Very strong sql and programming skills to automate reports. Meet with senior management and supported reporting and analytics requests from requirements phase to development, unit testing, black box testing and user acceptance testing and add it to a scheduler so that it runs automatically every month. Fedex Services2006 – 2008 IT consultant Supported Customer Insight Analytics and provided infrastructure support using PL/SQL, SQL, UNIX, cognos and business objects. Wrote scripts to synchronize Marketview and vendor Platforms like Fame. Helped analysts use vendor platform involving Cognos 8 PowerPlay webviewer that used as sql server as backend. Reviewed the cubes on the webviewer and wrote test scripts. Reviewed denormalised data models. Created several reports and scheduled them for the user community. Supported List Matching and fedexnet processes. Involved in design of databases to integrate Fedex Office customer and revenue information with FedEx data. MEDCO - Accredo Health, Memphis, TN 2004 – 2006 Sr. Software developer Mapped conversion data from legacy systems to new controlled substance oracle database (ACBS). Validated that the new forms application code was pared properly to reflect healthcare business needs with respect to pharmacy, claims and invoicing. Facilitated meetings with department managers to coordinate the manual collection of data required for Conversion. Coordinated the manual collection of data and formatted the data to flat files for feed to ETL tool (Business Objects). Created reports from universes that fetched data from oracle middleware. Wrote Functionality Test Plan: Facilitated meetings to gather business requirements from department managers and also from end-users. (20+ end-users, representing 300+ end-users) Developed a project plan, gathered/analyzed business requirements, developed a data model and conducted meetings, presentations Reviewed RFP, evaluated vendor software solution and suggested changes. Involved in database design, data analysis, development, SQL performance tuning. Developed analytical reports using business intelligence tools. Developed stored packages, procedures, functions, triggers, views. Worked on FedEx interfaces for drug shipment tracking. Provided business intelligence reporting support. Worked on NCPDP projects for invoicing and claims management. Developed numerous business insight reports using Crystal Reports involving a reporting mechanism that fetched over $2 million savings per year. Also developed several adhoc and scheduled reports using sql, access, and Oracle Report builder. Some reports were imported into excel to generate pivot tables and graphs and some of the reports used the graphical functionalities of crystal reports to drill down and perform more user friendly operations. Provided remote support to the business units in Nashville (HHS) apart from the duties in Memphis. Coordinated major system redesign efforts for the unit in Nashville division. Strong programming and debugging skills in PL/SQL, SQL. Developed forms and reports for application. Experienced in production support and trouble shooting. Good understanding of web based J2EE Technologies. Excellent communication, quantitative, analytical skills and ability to work either individually or as a member of a team. Responsible for performing code reviews and mentoring junior team members. Worked in a Medical Claims Processing system for processing medical claims. The system had screens for entering medical claims, pre-authorizing medical services to be rendered, maintaining data on facilities, physicians, health plans, plan members, diagnosis and procedure codes and procedure fee schedules. It included a seamlessly integrated table-driven reporting system (using Seagate Crystal Reports automation objects). The entire system, including reporting, was designed for maximum scalability. Wrote Integration Test Plan and associated Test Scripts for how the new system interacts with the applications already in use. St. Jude Children’s Research Hospital, Memphis, TN Data Manager (Imaging) 2002 – 2004 Responsible for the overall day to day management of assigned protocols. Maintain working knowledge of all assigned protocols to ensure validity of clinical research data and also responsible for abstracting and organizing research data into database. Data retrievals and timely submission of Reports to Management and worked with techs. Involved in the development of Computer-aided detection of therapy-induced leukoencephalopathy in pediatric acute lymphoblastic leukemia with intravenous high-dose methotrexate. Performed analysis on data to help decision support and identify patterns.