Karthikeyan Kumar

Experience

• 

  CSC

  Jul 2010 - Feb 2013

  Consultant – Enterprise Package Solutions

  Worked for American Multinational Investment and Finance companyRole:Consultant – Enterprise Package SolutionsProject:Development and Support of PeopleSoft HRMS 8.8, Tools 8.48Responsibilities:• Involved in requirements gathering, Initial Analysis and Impact Analysis• Involved in Plan, build, test and deployment of New and Enhancement of existing systems. • Involved in System Testing of New and Enhancement of existing systems. • Maintenance and Production support for existing Systems• Extensively used Application Engine, Component Interface and File Layouts for inbound and outbound interfaces • Worked on tuning of Audit Archival Application Engine program and successfully reduced the run time from 4 hours to 20 minutes.• Automated the statistics sheet used for batch monitoring using UNIX script.• Worked on modification of security program to implement the parallel processing. It reduced the processing time from 8 hours to 3 hours.• Created a Mass Upload Tool to process Mass JDC transaction done by the operations team. When a large group change occurs, a high volume of employees may need to have Compensation changes, Job Code changes, or other Job Data related changes and also it involves propagation logic when row is inserted at middle of the stack. So we built a tool to upload the data given in the EXCEL sheet into the PS tables. Coding completely done by the dynamic way so that minimal coding is required in future. Used complex propagation logic to move forwards the rows if any changes were made in middle of the stack row• Developed number of interface reports using Application Engine to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.Environment: PeopleSoft 8.8 (Core HR), People Tools 8.48, People Code, Application Engine, Component Interface, Application Package, IB) Show less

• 

  Accenture

  Feb 2013 - now

  Visualization Tool: Tableau• Worked on Tableau Requirement gathering, design, development, Quality testing, User Acceptance testing and process documentation to produce required reporting, analytics, and visualization deliverables.• Worked with clients to develop and translate a business requirement into an effective and insightful interactive analytical dashboard.• Strong understanding of project life cycle and Software Development Life Cycle (SDLC) methodologies including Waterfall and Agile/Scrum• Have an experience working in Scrum project and leading scrum calls during scrum master absence. Lead multiple 4-week sprints by working through the requirements from backlogs.• Experience working with large quantities of data while creating Tableau Dashboard.• Ability to perform data analysis and troubleshoot data integrity issues.• Developed various workbooks in Tableau from multiple data sources.• Created dashboards and visualizations using Tableau desktop.• Used various reporting objects like Hierarchies, Action Filters, Calculated Fields, Parameters, Sets, Groups, Data blending, Union, Joins etc.• Used Tableau to create the dashboard using different visual elements like charts, maps, graphs, donuts.• Performed time series analysis using Tableau.• Strong understanding of SQL, relational database management system, data modeling, and normalization• Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases• Has extensive knowledge on data warehouse concepts and worked on an ETL tool Qlik Compose and Replicate to prepare the data to be consumed in Tableau and OBIEE Show less Data Warehouse Tool:• Design/Build/Implement Conceptual, Logical, Physical Data model for HCM, CRM and Financial OLAP/BI Applications using Enterprise Data warehouse tool called Attunity replicate and Attunity compose.• Extensive experience in end-to-end DWH solution which includes Data Quality Rules, Data Profiling/Cleaning, and Data Governance.• Extensive experience with the Integration of DWH, R and Tableau Dashboard.• Extensive experience in Reference Data/Master Data/Transactional Data and Metadata for HCM applications.• Designed/Implement Different DWH models which includes Relational Model, Dimensional Data modeling, Star Schema, Snowflakes, Data Mart.• Extensive experience in Tuning SQL queries, Data massaging.• Designed/Implement workflow jobs for Change Data Capture (SCD1/SCD2).• Designed ETL Source/Target mappings, Various Transformations.• Have extensive exposure in handling complex logic in sql queries.• Good experience in gathering business requirements, preparing High level and low level functional and technical documentation.• Have extensive experience in agile methodology.• Proficient in preparing data dictionary/data catalog/data mapping and various use case documents for data solutions.Tools Used:1. Oracle 12c2. Attunity Replicate3. ETL - Attunity Compose4. Agile Rally5. R Programming6. Tableau Desktop and Server Show less Project - New York state local retirement systemRole - Application LeadResponsibilities -• Involved in Development and technical design preparation for the work request received• Involved in end to end implementation of Loans Module which include self service loan payments, application and loan processing• Involved in integrating CRM(Case Management) with HCM(Loans Module)• Worked as a Data Modeler for Peoplesoft and Business Intelligence team• Lead a team of 5 for end to end implementation of Loans Module• Lead PeopleSoft tools upgrade from 8.55 to 8.57• Involved in end to end process for tools upgrade from analysis , estimation and implementation• Worked as a Performance tuner to tune the long running program and components.• Tuned most of the PeopleSoft pages in NYSLRS within in the SLA level of 3 seconds• Worked on tuning the Loans batch program which process the Interest, Insurance and Loan payments and reduced the run time from 3 hours to 30 minutes Show less Machine Learning:• Worked on Designing and development of technical architecture, requirements and statistical models.• Coordinated with end users for designing and implementation of analytics solutions as per project proposals.• Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming language.• Worked on integrating of R programming plans with data sources (Data warehouse - Attunity) and delivery systems (Tableau).• Provided technical assistance for development and execution of test plans and cases as per client requirements.• Creation and Maintanence of R Program Scripts for Predictive analytics, Supervised Learning and Unsupervised Learning• Created complex SQL statement to analyze the data from ETL tool to feed to the ‘Risk and Compliance’ Dashboard in tableau.• Predictive Analytics is used in Case dashboard to predict the volume of cases which will be created in the CRM• Utilized R to apply machine learning regression and classification methods (such as Random Forest) to predict the volume of cases created in CRM• Completed the R certification from datacamp• The data from the Attunity (ETL tool) is used in R program to predict the volume and the o/p from R is consumed by Tableau for visualization Show less Working for Largest Non Profit Healthcare organization.Development and Support People Soft 9.1 and 9.2 UpgradeResponsibilities:• Involved in Development and technical design preparation for the work request received• Involved in suggesting technical solutions to offshore team for the complex design.• Worked on Analysis, retrofits and fixing issues in 9.2 Upgrade. It includes compare projects prepare test plan and test all impacted objects.• Analyzed Upgrade Compare reports and made required changes as per the business process.• Retrofitted People Code, SQR to accommodate customization to meet the business requirements.• Attended Oracle Session on PeopleSoft Fluid Pages in People tools 8.55• Created Work Center Dashboard with Related actions for LCE team to make the day to day activities easier.• Assisted Payroll, Finance and Supply Chain Team to create work centers in their respective areas.• Implemented following Mass Upload Tools for the processes which is frequently used by business.o Position Data Creationo Position Data Modificationo Personal Phone Updateo Position Transfero Job Union and Non Union CompensationJob union and Nonunion compensation Mass upload tools are bit complex as it involves cascading of compensation rows to the top of the stack when the data is inserted in middle of the stack.• Have used both STAT and PHIRE tool for migration.• Worked on LCE Standardization project to convert approximately 280K records into new format.• Created a Mass Upload Tool for Profile Management which does the following o Create Content Items for any Content Typeo Create Shell Person and Non Person Profileo Add/Delete/Update Content items in the Person/Non person ProfileThe initial requirement was to create a program to load License information into Person and Non Person profile. I suggested and created a Mass Upload program in which the business can load any content items for any content type into the person and non-person profile Show less Worked for Texas Based company involved in Banking, Investing and InsuranceProject:PeopleSoft HCM 9.1 Development, Level 3 Production Support , Patches and Updates for Maintenance PacksResponsibilities• Involved in Requirements gathering, preparation of functional design and technical design for the work requests received.• Involved in functional design walk through for the small mod and the estimation of the work requests with the business.• Involved in Providing the technical solutions and possible work around for the defects reported to continuation of the business process.• Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements• Worked on Pay Equity Project (Out of cycle salary adjustment process) in which we integrated the Transfer and salary change process. Requirement was to Integrate salary change and the transfer process into a single module with multiple level of approvals and the approvals based on the salary percentageImplemented it in the best possible way. Apart from what is mentioned in the requirements, introduced a graphical representation of• An employee's salary range for his job comparing with the market rate• An employee's rating in last 3 performance cycles• Last 5 salary increasesThe above graphs were introduced in PeopleSoft 9.2. By taking that as a reference I introduced it in 9.1 through html.• Developed Approval Workflow Engine for the pay equity process with multiple levels of approval based on certain criteria.• Awarded with ACE (Accenture Celebrates Excellence) award for successfully implementing the pay equity project.• Involved in FIT-GAP Analysis documents before and after applying retrofits for the maintenance packs.• Created SQR and AEs for the repeated year end processes. Show less

  • Application Development Specialist and Associate Manager

    Jan 2018 - now

  • Application Development Specialist and Associate Manager

    Jan 2018 - now

  • Associate Manager

    Jan 2018 - now

  • Application Development Specialist

    Jan 2018 - Jan 2019

  • Application Development Senior Analyst

    Apr 2015 - Dec 2017

  • Application Development Senior Analyst

    Feb 2013 - Apr 2015