VENNILA VAITHIYAPILLAI

+1-214-***-**** ad4y6t@r.postjobfree.com

Professional Summary

• Have 4 years of professional experience. 2 years as teaching Assistant Professor and 2 years as software developer.

• Certified Professional Scrum Master-1 (PSM1).

• Knowledge in full life cycle development of Data Warehousing.

• Strong knowledge with relational database concepts.

• Knowledge in Agile development process and concepts.

• Delivered lecture to undergraduate students on Computer Programming ( C and Java).

• Best outgoing Sports Women award during undergraduate program.

• Organized and Managed sports events.

• Have good understanding in Developing ETL program for supporting Data Extraction, transformation and loading using informatica power center.

• Have hands on experience in creating UNIX shell scripts.

• Hands on experience in Snowflake .

o Strong knowledge on Bulk loading from external stage(AWS S3), internal stage to snowflake cloud using COPY command.

o Good understanding on Loading data into snowflake tables from the internal stage using snowsql.

o Used COPY, LIST, PUT commands for validating internal stage files. o Used FLATTEN table function to produce a lateral view of variant column. o Strong knowledge in SNOW PIPE for continuous data ingestion from the S3 bucket. o Good understanding on SNOW STREAM, Virtual Warehouses. o Strong knowledge in writing procedure using Javascript and Automating the execution using Task.

• Good Understanding in Logical and Physical data modeling.

• Knowledge on Dimensional data modeling, Star schema modeling and identification of fact and dimension tables

o Strong knowledge in Table creation, Views, Constraints and Indexes(B-tree and Bitmap). o Extensive knowledge in Analytical functions and Common Table Expression(CTE). o Good Understanding in Case statements, SQL functions, Sub queries, SET operators, Joins and Merge.

• Hands on experience in Informatica power center

o Good understanding on Slowly Changing Dimention and transformend data into SCD1, SCD2,SCD3,SCD4 and SCD6.

o Extensive knowledge in CDC(Change Data Capture), Parameter and Variables and implemented CDC logic using workflow variables.

o Strong knowledge in Dynamic file handling and lookup cache and reverse lookup. o Good experience various kinds of transformations like Expression, Aggregator, Router, Sorter, Sequence Generator, Joiner, Lookup, Update Strategy, Rank and Filter. o Good understanding in reusable maplet and transformation, worklet and workflow tasks. o Strong knowledge in informatica performance tunning involving source level, target level and map level bottlenecks.

• Proficient Android applications development involving user infaces, API integration, push notifications.

• Experience in using java with Eclipse and designing the UI layout using linear lauout, Relative layout, Frame layout, Table layout, list view using android native widgets.

• Experience in developing android applications for Tablet and mobile devices using Eclipse, Android SDK and ADT tools.

• Experience working with Google Maps API, Twitter and Face Book APIs.

• Willing to update my knowledge and learn new skills. Tehnology Skills

ETL Tool Informatica Power Center

Cloud Snowflake, AWS, IICS Cloud Platform

Language SQL, Shell Script, Core Java, HTML5

Database Oracle, Snow flake, Sqlite database

Operating system Windows OS, Unix

Tools Toad, SQL developer, Eclipse, Android SDK

Certification

• Professional Scrum Master PSM 1

Professional Experience

ITTI Pvt Ltd, Bangalore Jan 2014 - April 2015

Systems Engineer

Bharathiyar Institute of Engineering for Women Jun 2013 – Dec 2013 Assistant Professor

Maha Barathi Engineering College, Chinnasalem August 2010 – June 2011 Lecturer

Snowflake Hands on:

• Prepared sample test data.

• Uploaded the data into AWS S3 bucket.

• Uploaded the data into internal stage using PUT command in snowsql.

• Created integration object and moved the data from AWS S3 bucket into external stage.

• Responsible for transforming data from external stage to snowflake using bulk loading Copy into command and SQL transformations.

• Created views on top of integration tables to support Slowly Changing Dimention (SCD-2) views for historical analysis.

• Developed Javascript procedure to encapsulate transformation logic for moving data within snowflake from stage table to integration/target tables.

• Implemented error handling and audit logging processes within the procedure code to ensure the data quality and traceability.

• Scheduled snowflake procedure using snowflake tasks based on project requirements. Informatica hands on Project:

Overview:

Design and develop Datawarehouse for restaurant food chain. The solution will automate data extraction, transformation and report creation. Responsibilities:

• Responsible for requirement gathering.

• Responsible for Data Modeling and Logical diagram and Physical diagram.

• ETL mappings, mapplets, workflows and worklets using Informatica Power Center 8.x.

• Identify efficiencies and ways to improve the design and development process.

• Worked with pre and post sessions and Extracted data from different sources(CSV, RDBMS-Oracle) into staging area.

• Implemented Slowly Changing Dimension (SCD1, SCD2, SCD3) to maintain a current and history information in the warehouse tables.

• Wrote complex queries and created summary tables and views for the business requirements.

• Developed mappings/reusable objects/transformation/mapplets by using mapping designer, transformation developer, mapplet designer in Informatica Power Center.

• Working with various transformations like router, lookup, expression, joiner, aggregator and normalizer in implementing Complex mapping.

Project-ITTI Updates App November 2014-April 2015

Client: Internal app (ITTI Pvt. Ltd)

Overview:

ITTI Updates application is the HR communication app. The application have different dashboards for different users as Associates or Visitors. The HR team can send the message as notification to all Employees, Specific Team members, Multiple team and visitors through this application. HR team can schedule the message and send birthday wishes to the employees. Associate users also can see the upcoming birthday list and send the birthday wishes as SMS. The Associates can access the intranet and corporate website through this application. The visitors can see the career opening information and can access the corporate website. The application itself can generate the birthday remainders as notification for associate users. Responsibilities:

• Responsible for designing login form, different users dashboard, communication module for different screen resolutions.

• Developed code for login verification and validation, different dashboard functionalities and integrated calender packages.

• Prepared User Requirement Specification, System Requirement Specification, Design Document and Casual Analysis Requirement.

• Integrated third party libraries.

• Integrated different dashboard modules and communication module.

• Prepared test cases and performed unit testing on all modules.

• Prepared user manuals.

Project – XLA(Experienced Los Angeles) January 2014-October 2014 Client:Civic Resource Group

Overview:

XLA is a Tourism Application for Los Angeles city in USA. The tourist spots are categorized and the user can see the list of particular (or) all places in the map in a respective category by clicking ON/OFF button. Metro lines are implemented on the map. So the user can get the route and bus timings and bus location on the map from one location to another location. The user can post their photos, videos and their reviews on Social network such as Face Book, Twitter.

• Developed android applications using core java language in Eclipse.

• Implemented Restful APIs and third-party libraries to enhance the application functionality.

• Designed and developed metro, wishlist and gallery modules using XML markup lanuage.

• Integrated Google Maps API into the application to enhance the functionalities.

• Collaborated with cross functional teams to design and develop mobile applications that met business requirements.

Education:

Master of Engineering: Computer science and Engineering Jayaram College of Engineering and Technology, Trichy, Anna University – 2011 to 2013. Bachelor of Engineering: Computer science and Engineering Jayaram College of Engineering and Technology, Trichy, Anna University – 2006 to 2010

Contact this candidate