JOHNSON JACOB CHACKO
331-***-**** • acf855@r.postjobfree.com
SUMMARY
- Teradata Developer with 6+ years of software industry experience.
- 2+ years of experience in analysis, design and development of data-warehouse environments, ETL jobs [using Bteq, Fastexport, Fastload,
Unix shell scripting], Data Analytics.
- Strong RDBMS concepts and 6+ years of hands-on experience in various relational database flavors [Teradata, MySQL, Oracle, MSSQL,
HSQL]
- Expertise in performance tuning of Teradata queries using indexes, partitions, statistics, etc.
- Well versed in OOPS concepts.
- In depth domain knowledge in Loyalty management platform - Shop your way Rewards which handles around 1.5 million transactions
daily.
- 2+ years of experience in Design and development of Adobe flex applications with java and hibernate.
- Familiarity with No-SQL concepts and Hadoop
- Currently working as a Technology Analyst [ETL] for Infosys Technologies Ltd. at Sears Holdings Corporation, Hoffman Estates, IL
What I am looking for: An opportunity to make an impact, one to grow my skills.
Skills/Activities Technologies/Tools
• ETL:
Customer Interaction
•
• Teradata scripting [BTeq, Fast Export, Fast Load]
Business Requirements Gathering
Databases:
• Data-warehouse design
• Teradata [12, 13]
• Application Database design
• MySQL [5.4, 5.5, 5.6]
• ETL Workflow design
• Oracle [8i, 9i, 10g]
• ETL Job Development
• MS-SQL [2005, 2008]
• ETL Performance tuning
• HSQL
• BI Report design
Application Servers:
• Query tuning
• JBOSS [4.0. 4.1, 4.4]
• Solution Design
Packaging tools:
• Application Development
• Install Anywhere [2008]
• Testing
Application Development/ Scripting:
• SQL, PL/SQL
• Strong Analytical and Reasoning Skills
• Unix Shell Scripting Java [5,6,7]
• Excellent Problem-Solving Skills
• XML, JSON
• Fast learner
• C++, C
• Good Communication Skills
• Hibernate, jdbc
• Self-motivated
• Adobe Flex [3,4]
EDUCATION
Bachelor of Technology in Electronics & Communication Engineering from Cochin University of Science and Technology (CUSAT), Kerala,
India.
Projects:
Infosys Technologies Ltd. (Feb 2012 – Current)
Designation : Technology Analyst – ETL
Project profile : Sears Holdings Corporation – Shop Your Way Rewards [Telluride]
Location : Sears Holding Corporation Headquarters, Hoffman Estates, Illinois, US
Software/Tools used : SQL, Teradata, MySQL, BTeq scripting, Fast Load, Fast Export, Unix Shell scripting, Java, Teradata
SQL Assistant, SQLYog, MySQL Workbench, Eclipse
Project Description:
Shop Your Way Rewards [SYWR] Program is the Sears Loyalty program which facilitates setting up offers and awarding and redeeming of
loyalty points for transactions at Sears, Kmart, Landsend, etc. stores and online business units as well as from partners.
Telluride project was the in-house implementation of the entire loyalty system which was till then based on a vendor package. The new
project brought in all the existing features supported by the vendor and added much more flexibilities including support for partners,
support for various kinds of new offers, etc. It included a massive data migration activity from the existing platform to the new one.
Responsibilities:
o Involvement in the overall program.
o Design and development of Data-warehouse
o Design of the ETL work flow to Load data from MySQL application database to Teradata datawarehouse
o Development of a major module of the ETL flow using Bteq, Unix scripts and Fast load
o Data analytics and generation of various functional and financial reports from the Teradata environment.
o Co-ordination with the team
o Code review
Infosys Technologies Ltd. (Apr 2011 – Jan 2012)
Designation : Software Engineer
Project profile : Wal-mart - Mtep GM Canada - Business Intelligence QA
Location : Walmart, Brisbane, California, US
Software/Tools used : SQL, Oracle, Unix Shell scripting, Java, Informatica Powercenter, OBIEE, Eclipse
Project Description:
The Mtep GM Canada project was Wal-mart’s effort to bring its online shopping experience to its Canadian customers. The Business
Intelligence wing took cares of all the reporting which are critical in making various business decisions. The responsibilities of the BI team
started from the design of the data-warehouse to populating the ware-house from the source databases using various ETL logics and
populating the reports to validating the entire workflow.
The BI QA team was responsible in creating various SQL queries based on the requirements and in validating the Warehouse design, ETL
Logic, Scripts, data in the warehouse, BI reports using the same.
Responsibilities:
o Understanding the business requirements
o Leading the BI QA team and coordinating with the offshore team
o Test-case design review
o Scripting SQL queries to validate the data in the Data-warehouse against those in the source systems
o Reviewing the scripts
o Making sure that overall function of the BI QA team is achieved
Infosys Technologies Ltd. (May 2008 – Apr 2011)
Designation : Software Engineer
Project profile : Infosys - Infosys Test Data Management solution [iTDMS]
Location : Infosys headquarters, Bangalore, India
Software/Tools used : SQL, Oracle, MS SQL, DB2, HSQL,Unix Shell scripting, Java, Adobe Flex, Java, Hibernate, Radien
Framework derived from IBM RAD, jdbc, Jboss, Eclipse, Macromedia InstallAnywhere
Project Description:
Robust Test Data Management processes are critical to maintaining applications and databases, but creating and maintaining the
necessary clones is a labor intensive activity for any IT department. Multiple clones must be configured and managed across applications,
databases, servers, and storage devices, all the while exposing sensitive customer data to potential leaks.
iTDMS is an application which automates the Test Data cloning and generation processes ensuring that sensitive data is not exposed
during test and development. It generates automated queries and executes them against various database systems [Oracle, MS-SQL,
DB2, HSQL] as needed to make sure the data set up is in place for the testing to start.
The application
o facilitates the testing team to request for test data
o extracts data out of an existing data source according to the rules set by the user to the target data source.
o generates the deficient data according to the rules set by the user.
o provides a virtual reservation for the data requested by a particular user.
Responsibilities:
o Understanding the business requirements
o Module Lead
o High Level and Low Level Design
o Database Design
o Development
o Unit Testing