Information Technology Project

Avantika Kaza

****.********@*****.*** 732-***-****

A career in Software Engineering with Requirements Gathering, System Designing, Data Modeling, and ETL Design, Development, Production, Support and Maintenance.

Highly collaborative and driven team player in ascertaining business needs, evaluating existing policies/programs, and executing upon required end game deliverables. Strong analytical, financial modeling, business process and problem-solving skills.

Key Strengths

Understanding ETL Concepts

Excellent knowledge of HTML5, CSS3, JavaScript

Documentation and Reporting

Java

Thorough understanding of SQL, DB2

Advanced Word, Excel, PowerPoint skills

Technical Skills

Languages: Java, SQL, C (Novice).

Web technologies: J2EE (JSP, Servlets, JDBC, Java beans), JavaScript, CSS3, HTML5, jQuery

Databases: MySQL, MS Access, SQL Server, Oracle 10g, 11g, DB2.

Datastage Tools: IBM Infosphere/Websphere Datastage Designer, Datastage Administrator, Datastage Director, Query tool, Unix shell scripting.

Tools: Excel- Pivot tables, VLOOKUP’s, Macros, Access, PowerPoint Microsoft Workbench, Microsoft Project 2010, Microsoft Word, Balsamiq, Tableau, Data flow Diagrams, SSRS

Career

American International Group (AIG) Charlotte, NC Oct’ 2015 – Dec’ 2016

Datastage Developer/ Analyst

Responsibilities:

Worked on Datastage Tools like Datastage Designer, Datastage Director and Datastage Administrator.

Extensively worked on Data Migration, Data Cleansing, Testing and ETL Processes.

Single handedly developed parallel jobs using different processing stages like Transformer, Aggregator, Join, Sort, Copy, Merge, Funnel, CDC, Lookup, Change Apply and Filter.

Scheduled jobs to run in a sequence using the Datastage Job Sequencer.

Worked on the replication of data from DB2 Platform to IBM Db2 Analytics Accelerator (IDAA) using SQL Queries.

Wrote SQL queries, design and implemented tables, functions and views.

Organized and correct data by exercising function within Microsoft Excel; Writing Macro when necessary.

Monitoring, controlling, preparing and reporting the status of programs, projects and operation budgets.

Experience conducting complex analysis on large sets of data including the understanding of data flow and integration of various data feeds to make decisions.

Provides tracking, analysis, and reporting of projects of varying contract type, size and complexity.

Ability to interact and work effectively across various levels of management including senior executives

Tools Used: IBM Infosphere/Websphere Datastage Designer 8.7, Datastage Designer 11.5, Datastage Administrator, Datastage Director, Query tool.

Enlume Inc. Oct’ 2012 to Oct’ 2013

Data Analyst Intern

Responsibilities:

Made a list of more than 4,000 perspective donors using an Excel-based model to provide insights for museum directors(Client)

Created and updated weekly reports with more than 10,000 entries from the donor database.

Reorganized the database by removing duplicates and categorizing key contacts to ensure usability.

Technologies Used: My SQL, SQL Server, Excel

Academic Projects: University of North Carolina at Charlotte Jan 2014 to Dec 2014

Student

Project 1: Network Based Application Development:

Responsibilities: Developed web pages with HTML5 and CSS.

Set up the database to access products and their details and to maintain records of the users.

Maintained well logged technical documentation of all that is done from inception to delivery.

Technologies Used: Net Beans, My SQL, JSP, Java Script, JDBC.

Project 2: Harvard Case Study: IT Management

Responsibilities:

Studied and Identified Case Study Problem and prepared detailed Work Breakdown Structure (WBS)

Estimated time, cost and resource requirements and likely risks during the project.

Collaborated with the team by conducting weekly meetings

Technologies Used: Microsoft Project 2010, Microsoft Word 2010, Google Docs.

Project 3: Human Computer Interaction

Responsibilities:

Developed Wireframes for the website Discover charlotte to enhance User Experience.

Conducted surveys with students, teachers, officers to get their suggestions of a user-friendly website design.

Understood the factors that determine how people use technology and ways to improve users understanding of websites and achieve efficient and simplify user interactions.

Technologies Used: Balsamiq, Microsoft Word 2010, Google Docs.

Education

Free Code Camp (Jan 2017- Pursuing)

Full Stack Web Development Certification

University of North Carolina at Charlotte, NC (Jan 2014 - May 2015)

Master of Science in Information Technology, GPA:3.66/4.00.

Jawaharlal Nehru Technological University, Hyderabad, India (2009-2013)

Bachelor of Technology in Information Technology, GPA: 3.6/4

Contact this candidate