Karthick R. Email & Phone Number

Mclean, VA, US

• Participate in all phases of the software development lifecycle, from inception through post-implementation support, for all types of applications consistent with established specifications and business requirements to.
• Understand the customer requirements and translate it into appropriate technical solution.
• Responsible for serving as a data expert by translating business problems into design and to create the required aggregation and transformations.
• Collaborate with business partners to identify and scope new opportunities for analytics applications to evaluate business performance and to support business decisions.
• Work with a team of developers responsible for integrating data into the enterprise data warehouse by leveraging the Extract-Transform-Load (ETL) tool and business intelligence framework.
• Design the technical deliverable artifacts such as source-to-target mappings, implementation run books etc. needed for project implementation.

Atlanta, GA, US

• Participate in all phases of the software development lifecycle, from inception through post-implementation support, for all types of applications consistent with established specifications and business requirements to.
• Understand the customer requirements and translate it into appropriate technical solution.
• Understanding of data warehousing, reporting and data integration design concepts/skills to contribute to the design, development, testing and implementation of end-to-end integrated systems and support production.
• Responsible for serving as a data expert by translating business problems into design and to create the required aggregation and transformations.
• Architect solutions that drive enterprise business intelligence projects from design, development, and demonstration through full implementation using a combination of both ETL and business intelligence tools.
• Collaborate with business partners to identify and scope new opportunities for analytics applications to evaluate business performance and to support business decisions.

Zurich, CH

• Participate in all phases of the software development lifecycle with DevOps automation process in Cloud environment, from inception through post- implementation support, for all types of applications consistent with.
• Understand the customer requirements and translate it into appropriate technical solution.
• Analysis and understanding of data modeling and/or diagramming techniques, with the ability to create the process flow diagrams and understand the entity-relationship models.
• Understanding of data warehousing, reporting and data integration design concepts/skills to contribute to the design, development, testing and implementation of end-to-end integrated systems and support production.
• Responsible for serving as a data expert by translating business problems into design and to create the required aggregation and transformations.
• Architect solutions that drive enterprise business intelligence projects from design, development, and demonstration through full implementation using a combination of both ETL and business intelligence tools.

Charlotte, NC, US

• Hands on knowledge and experience in developing and designing code with ETL & Business intelligence framework.
• Involved in requirements gathering for BI projects by interacting with business users and upstream data producers.
• Involved in analysis of project requirements.
• Prepared the Data Warehouse strategy and development design approach using InfoSphere DataStage 11.5 / DB2 for various Data integration requirements.
• Created source to target mapping sheet to migrate the Medicaid eligibility and enrollment data to a new system.
• Used the Secure file transfer protocol (SFTP) to connect to external Servers to get the files or send the files to Master Data Management (MDM).

Cleveland, Ohio, US

• Partnering with the business users to understand the requirements and converting them into project level functional specification.
• Worked with business analysts to identify the appropriate sources and data elements.
• Conducted requirements gathering with various business teams to understand the data needs for the new chip cards.
• Co-ordinated with different source system teams to understand the changes in process required for processing chip cards.
• Analyze the existing data present in data marts and EDW to understand the impacts of process changes to the existing system.
• Involved in data profiling of the new chip information for data modeling and data quality monitors in EDW.

Minneapolis, MN, US

• Develop code that meets technical specifications and business requirements according to the established designs and framework.
• Automated reconciliation process is to identify the missing organization information between systems for CSR agents.
• Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimension (SCD).
• Download the XML from payment website once payment authorization is completed with using Curl command in Unix script and process the XML file into BI tables.
• Created ETL jobs to invoke SOAP web services with using WSDL for change the order status once payment is approved or rejected from XML file data.
• Used DataStage/Quality Stage Designer to import/export jobs, table definitions, Custom Routines and Custom Transformations.

New York, NY, US

• Partnered with business users in identifying, prioritizing & resolving numerous data issues create ETL Project Plans, design and development of the tables.
• Extracted the data from heterogeneous sources like SAP BW using Openhub connection, Mainframe tables, Flat files and IBM DB2.
• Designed and developed the parallel jobs for slowly changing dimensions (SCD Type1, Type 2 and Type 3) and fact tables loading and Type 2 to handling the historical data.
• Designed DataStage parallel jobs to process more than 40 million records in the weekly basis.
• Involved in monitoring history data migration in general ledger.
• Involved in monitoring the workflows and in optimizing the load times.