Data Engineer
Resume:
Antara Basu
Apt # ***
Milpitas, CA 95035
********@*****.***/ **************@*****.**.**
Data Architect with “GE Transportation”, with 11+ years of experience in database technologies. Proficient knowledge in Big data, Data Modeling, Data Warehousing, ETL, Mobile Database solutions and PL/SQL programming. Excellent understanding of business operations and analytics tools for effective analyses of data.
PROFESSIONAL EXPERIENCE
GE TRANSPORTATION
Data Architect, October 2015– April 2017
Sensor data from various locomotives ingest into the database. Designed various predictive modelling and health-checks for processing them, using machine learning algorithms in R.
I was responsible for managing the performance and availability of the Transactional & Data Warehouse environment and integration of Data lake with various source systems and data warehouse using batch and real-time ingestion streams. Managing 60 TB's of data across 3 environments.
Driving integration of Data lake with various source systems and data warehouse using batch and real-time ingestion streams.
Also, building the best suitable mobile architecture for supporting online and offline transactions; and simultaneously engaged in building Enterprise level common Asset Data Model.
Highly skilled in diverse aspects of technical and solution architecture including database design, data modeling using ERwin (Dimensional &Relational), ETL design, Database sizing, Big Data solutions, architecting roadmap for future enterprise
Building up analytical solutions on massive data volume using Cassandra, HIVE and Hadoop batch layer technology and reducing the over-all processing time
ORBITZ WORLDWIDE
Data Engineer, July 2014– October 2015
Directed the team to follow agile methodology (certified Scrum Master)
Laid end- to-end Data Analytics platform for some customer metrics
Involved in creating various infographics
Working with 4V’s of data (Velocity, Variety, Volume and Veracity) using Informatica and PL/SQL
Tracking customer’s behavior pattern via clickstreams using Hadoop Framework
DELOITTE CONSULTING PVT LIMITED
Technology Consultant, February 2013 – June 2014
Estimating the Data Capacity for the New Data Mart and Server
Created the complete the Data Model (using ERwin) for HIX-WellPoint
Processing and storing various raw data (XML, csv and text) into Oracle
ACCENTURE
Team Lead, February 2010– February 2013
Created various complex procedures in Oracle 11g
Delivered end-to-end ETL and gave structured data for analysis
Tuned complex and messy applications, and improving customer experience
Prepared various adhoc as well as customized reports for Business users
Automated many reports and thus decreased manual error
Managed a team of 8 members
Comprehensive data warehouse to extend
Capabilities for customer segmentation, prospect recommendations,
sales forecasting model and customer lifetime value model
INFOSYS TECHNOLOGIES LTD
Technology Analysts, September 2006 – February 2010
Created the screens for cash reports in oracle forms and reports 6i.
Involved in rigorous Unit testing and preparation of UTP.
Captured the functional requirements and prepared the Design Documents. Designed and implemented data creation of 400-450 tables for a banking system to Oracle
Developed a custom data synchronization process between DB2 and oracle
Performed Data Profiling and Data Quality Assessment
Performance tuning of SQL's
Added new scripts for improving the functionality
Mentoring new team-member
SHRIRAM PISTONS & RINGS LTD.
Product Engineer, July 2005 – September 2006
Clients: Hero-Honda, Renault, Ford, General Motors, Maruti, Bajaj, Ashok Leyland, Tata Cummins
EDUCATION
2010-2012 M.S. (SOFTWARE SYSTEMS) CGPA: 8.65
oBITS PILANI
2001-2005 B TECH (METALLURGY AND MATERIALS ENGINEERING) CGPA: 8.46 (84.6%)
oNATIONAL INSTITUTE OF FOUNDRY AND FORGE TECHNOLOGY, RANCHI
TECHNICAL SKILLS
Programming Languages :
SQL, PL/SQL, Golden Gate (for database replication), NoSQL, Splunk
Databases :
Oracle, Exadata, Teradata, Cassandra, GreenPlum, CouchBase, PouchDB, Postgresql, MariaDB (beginner’s skill)
Emerging technologies:
Hadoop, R, Python, Cassandra
ETL :
Informatica and Talend
Contact this candidate