Data Developer

Kranthi Kumar Anantha

C Unix Developer

Address **** * **** ***, ********, IL, 60026

Phone 720-***-****

E-mail *******.****@*****.***

Have 5 years’ experience in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.

Application development experience using multithreading, Serialization, Externalization, Collection, Generics.

Working with relative ease with different Software development methodologies like Waterfall, Agile (SCRUM) and Rational Unified Process (RUP).

Strong experience in C/C++ on Linux, Cross-platform and embedded systems.

Extensive Experience in Multi-tier Application Development and good knowledge of Design Patterns.

Developing firmware and drivers for WIFI modules, Ethernet modules and the modules in Linux operating system for intel based micro controllers.

Experience in working with different operating systems like Windows 7/XP/2000/98/95, UNIX and Linux.

Experience with Oracle, Microsoft SQL Server, MySQL, and Microsoft Access in writing PL/SQL, stored procedures, functions and triggers.

Experience in storing data using Object-Relational Mapping (ORM) tool for communicating with database.

Hands on experience in design, implementation and maintenance of system architectures using application servers like Tomcat.

Experience in writing the Shell scripts, Perl on different UNIX environments.

Expertise level knowledge in entire software development lifecycle (SDLC) process from business analysis to development, testing, deployment, documenting, maintaining and user training.

A strong leader and team player, adept at supporting team members to achieve personal and professional goals. Outstanding oral and written communication skills.

Background includes data mining, warehousing and analytics. Proficient in machine and deep learning.

Quality-driven and hardworking with excellent communication and project management skills.

Experienced Data Architect well-versed in defining requirements, planning solutions and implementing structures at the enterprise level. Analytical problem-solver with a detail-oriented and methodical approach.

Skills

UNIX, LINUX

C, C++, SQL, Java, Python

HTML, JavaScript

Eclipse, Intellij, MyEclipse

RESTful Web services

DB2, Oracle 8i/9i/10g, SQL Server, MySQL, MS Access

ERwin

Key performance indicators

Staging tables

Warehousing expertise

Report generation

Structure designs

Work History

April 2019 -

Current

Unix Developer

BCBS, Chicago, IL

Involved in Design, Documentation, Coding and Unit Testing implementation of functional specifications using C/C++ and SQL in Unix box

The project was developed in C++, Pro*C and shell commands/scripts had a very prominent role.

Writing wrapper functions for system calls which are system dependent (Solaris).

Created JIL files that are used to schedule jobs daily, weekly, monthly and quarterly in the Autosys according to the requirement.

Responsible for fixing problems wherever they are: product functionality, reliability, performance of product installation and update network protocols.

Worked on third party vendor interface files and generated reports for vendors using C++ and shell scripting.

Worked on Letter generated programs using C and UNIX shell scripting.

Created stored procedures and wrote several queries in SQL for batch processing.

Creating UI controls using JavaScript, CSS and HTML5.

Responsible to manipulate any HTML5, CSS3 using JavaScript to make the page have a dynamic

Responsible for designing the User Interface by coding in HTML5, CSS3, AngularJS, to build this SPA Single Page Application.

Worked on EDI transactions in which XML files are parsed out and processed.

Provided on call support for scheduling jobs, file transfers and transactional processes.

Aug 2017 – March 2019

Unix Developer

Aetna, Hartford, CT

Working at building large scale passenger forecasting application for revenue management team.

Development work using C, C++, Bash shell on Linux platform using tools like Orchestrate, Data stage, Control-M

Processing data from large flat files using structure padding to ensure that the data structures are correctly aligned.

Reviewing design and test documents for group forecasting

Code implementation to create the list of significant and non-significant itineraries by using the four years booking history datasets

Code implementation for dividing the itinerary dataset into local, pseudo-local and path OD (origin/destination) combinations.

Writing JavaScript for client-Side validations and Dynamic Effects.

Implemented group forecasting algorithm for local, pseudo-local and path itineraries to generate the forecasted passenger count

Implemented updates to the business/leisure pre-classification model

Implemented a quality check module to check the output of booking data process

Read and write datastage data sets using orchestrate scripts that are called from bash scripts

Working with SQL, Teradata, SQL Servers and other statistical tools

Working on data analysis and data visualization

Transitioning to agile development model from the current waterfall model

Jan 2017 - JUL 2017

Data Modeler

JB Hunt, Lowell, AR

Gathering business requirements for database and application updates/changes.

Developing, validating, and communicating OLTP & OLAP relational data modeling solutions.

Using CA ERwin to design data models; publishing the models to CA Erwin Web Portal tool to view the metadata information about the tables and lineage between the data elements.

Creating the conceptual, logical and physical data models.

Implementing metadata strategy and building metadata repository using Erwin while maintaining business rules, data dictionaries, data transformation rules.

Generating DDL scripts and providing them to the database administrators to physically implement on the database server.

Working on data warehouse, database and Operational Data Storage (ODS), and data marts; creating meta data repository of various data elements in the data warehouse and data marts.

Involved in creating the source-to-target mapping document and end-to-end document.

Creating templates, domains and naming standards for designing the data models.

Managing the model mart efficiently to keep all versions of models up to date.

Working with the ETL team by providing required documents and generating business reports.

Managed identification, protection and use of data assets.

Gathered, defined and refined requirements, led project design and oversaw implementation.

Designed data models for complex analysis needs.

Developed and delivered business information solutions.

Jun 2016 - Dec 2016

Data Modeler

Visa Inc, VMCP, Austin, TX

Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ER Studio.

Developed a Conceptual model using Erwin based on requirements analysis.

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.

Involved in Data Mapping activities for the data warehouse.

Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.

Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.

Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.

Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.

Reverse Engineered DB2 databases and then forward engineered them to Teradata using ER Studio.

Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.

Responsible for migrating the data and data models from SQL server environment to Oracle 10g environment.

Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.

Extensively worked on the naming standards which incorporated the enterprise data modeling.

Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.

Education

May 2015 - May 2016

Master of Science: Information Technology

Colorado Technical University - Denver, CO

Jul 2009 - Bachelors: Computer Science

Apr 2013 JNTUK, India

Contact this candidate