Karthigaa Vijayakumar

­­KARTHIGAA VIJAYAKUMAR Email ID:-Phone Number: - LinkedIn: https://www.linkedin.com/in/karthigaavj/ DATA ANALYST PROFESSIONAL SUMMARY 6 years of IT experience and 4 years of programming experience as a SQL developer/ETL developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management, MySQL open-source relational database management systems and Jitterbit ETL Data Integration Server. 4 years of experience in handling US (On-Site) projects independently and reported directly US Corporate offices. Knowledgeable Oracle/MySQL Developer skilled in data collection, analysis and management. Works well under pressure and consistently meets deadlines and targets while delivering high quality work. Involved in all phases of the SDLC(Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 12c/11g/10g, PL/SQL, MySQL, MS T-SQL and Excel reporting. Efficiently made use of Table Functions, Indexes, Table Partitioning, Bucketing, Collections, Analytical functions, Materialized Views, Query Re-Write and optimization. Strong experience in Data warehouse concepts, ETL. Good knowledge on logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index. Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL Developed JavaScript event validation scripts that save data to Oracle database. Strong experience as ETL developer in Data collection, Data transformation, Data loading, Developing ETL pipelines, Scheduling Jobs, Fault Tolerant ETL Code, Data Coding, Data Mapping,scripting for checking file content correctness, work with desperate schemas. Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Experience in ETL techniques and Analysis and Reporting including hands on experience with Reporting tools such as windward. Created shell scripts for invoking ETL tasks. Have experience in integrating to big data platforms like Hadoop and query big data using Hive. Queried neo4j data to create streaming etl pipelines using Kafka. Gained training & knowledge during my Maternity break in Cloudera VM with Hadoop hdfs file system, mapreduce and performed tasks in sqoop(loaded data from MySQL to Hive tables), Hive(wrote queries in HiveQL),PIG, SparkSQL, Apache Kafka. Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team. SKILLS Programming languages: Oracle PL/SQL, MySQL Scripting languages: JavaScript (API testing, Forms and validation), Jitterbit Script, UNIX scripting, hdfs commands. Reporting Tool: Excel reporting tool, Winward Reporting tool Web Technologies: HTML (Email Templates, Forms), CSS (Forms), JSON (API testing), and XML (API testing) Applications: Jitterbit Platform for ETL Automation Tools:GitHub, Jira, Visual Studio 2017, Google Analytics, Google Ad Words, Site Inspector, Visual SourceSafe, Oracle Query tool, Slack, lucid chart Databases: Oracle 10g/11g, and MS SQL Server WORK EXPERIENCE May 2018–Oct 2018: Programmer Analyst, Seidel, INC – Connecticut, USA Seidel Inc. specializes in anodized and decorative finishes for aluminum alloy parts for the cosmetic and other industries. Their mission is to use robotics technology to automate the process of flipping parts and organizing in trays. Developed a data-based application using Visual Studio, C#, Web Form, ADO.NET, SQL Server, T-SQL. Debugging C# based application and creating real time test cases using the ABB robot on the manufacturing floor to automatically flip the parts. Responsible to load different parts of data into camera excel sheets for the camera to change the parts image input to the robot. Dec 2017–May 2018: Integration Developer, S&S Worldwide, INC – Connecticut, USA The S&S Worldwide is a retail company; they innovate and produce hands-on learning products for the Kids. They get orders through phone, email, online web portal, fax, in-office visit, through Marketplaces such as Walmart, CVS, Groupon, Staples, Google Shopping website. Their mission is to use integration technology Jitterbit platform to aggregate their order processing work flow. Design, build, test and maintain software integrations between cloud-based ERP system and ecommerce marketplaces, including Walmart, Amazon, Staples, CVS. Utilize JavaScript and Jitterbit Script to develop processes using Jitterbit IDE and REST API to exchange order, shipping, invoice, and product/inventory data in XML, CSV, JSON format. Develop robust fault tolerant error handling and retry logic. Responsible to obtain specifications, review requirements in collaboration with business users and technical partners ­­Maintain Jitterbit Harmony platform and Collaborate with other team members to research use cases for Jitterbit in our business scenarios. 2017 – 2018: Programmer Analyst, Shoplandia, INC – Connecticut, USA The first end-to-end mobile app-based SaaS platform for shoppable video creation, streaming, and distribution for retailers. Shoplandia combines state of the art technology with a managed subscription models to help businesses launch and scale shoppable video campaigns and channels Responsible in bug fixing version 1.0 of Shoplandia’s web app (Symphony MVC, Linux commands). Liaison between product team, tech, and marketing team to document UX/UI, gatherproduct development ideas and requirements of Shoplandia’s version 2.0 mobile application. Lead the marketing campaigns for Shoplandia’s shop small project. 2015 – 2016: Programmer Analyst, United Technologies Corporation – Connecticut, USA United Technologies Corporation’s Environment, Health & Safety (EH&S) organization provides technical expertise to create and sustain a workplace that is free from hazards, supports safe operations. UTC’s EH&S department mission is to transform their traditional audit process to paperless using technologies. Developed forms and data views for UTC’s Environmental Health & Safety department using Oracle PL/SQL (create tables, create views), JavaScript (manipulate html forms and to manipulate data from database). Responsible to create reports with requested data from the end user to automatically generate a report when the user gives a certain filter and clicks the download button in the reporting website. Responsible to create the 2020 goals dashboard view in UTC’s Environmental Health & Safety -corporate SharePoint website. Jan 2015 – Dec 2015: Web Analyst/Graduate Assistant, Central Connecticut State University – Connecticut, USA The Office of Marketing & Communications is responsible for increasing public awareness and understanding of CCSU, its people, programs, and promise.The office is also responsible for administering the University Web site. Migrated CCSU's official website pages to Omni update web pages using Dreamweaver, HTML, CSS. Worked with faculties and professor to create, modify web pages using HTML, CSS. Tracked the quality of the website using a site inspector tool and corrected the web page structure and content. Dec 2012 – Apr 2013: SEO Analyst, Lemon Peak Marketing Pvt Ltd., – Chennai, India Digital Marketing Company with specialization in online marketing, Mobile application development and Web designing. Performed Keyword research analysis for Adword Marketing campaign to promote ShipUSAtoday client. Responsible in performing off page and on page optimization for client websites. Jan 2012 – Dec 2012: SEO Analyst, COMODO Inc., - Chennai, India The Comodo Cyber security platform enables customers to protect their systems and data against threats, including zero-day attacks. Responsible to perform off page and on page search engine optimization for COMODO websites. EDUCATION August 2017 - Master’s in Computer Information Technology, Central Connecticut State University–Connecticut, United States May2011 -Bachelor of Engineering in Computer Science, Anna University – Chennai, India PROJECTS Competition task of a Big data Hacker’s Day Challenge of HCL - Finding the unique URL that comes first using hdfs, excel, csv, hive, HiveQL and sqoop. Performed Sqoop various imports such as incremental import, lastmodified import from csv to MySQL and MySQL to Hive and performed static, dynamic partitioning and clustering. Developed one-pass processing of 1.29 MB of Yale Stocks and Flows MySQL database from data.gov website and performed sqoop import operations and did Hive imports for doing ad-hoc analysis using partitioning and bucketing. Created streaming pipeline from neo4j graph database as kafka producer to nodeJS,CSV,AWS as kafka consumer using confluent kafka libraries. Course equivalency finding tool to match disparate university course data and give results using Linked open data using SPARQL, RDF Trip planning application for users to get bus information from Hartford downtown CT to New Britain, CT and other places.