Database Architect / Developer Resume
5.00/5 (Submit Your Rating)
PROFESSIONAL SUMMARY:
- 12+ years of IT experience in Data Warehousing solution implementation / Big Data Architecture and development.
- Proficient in writing excellent quality code in Python, Perl, Shell Scripting, C/C++.
- Excellent analytical, written, oral and communication skills.
- Took numerous initiatives in multiple roles to enhance the process / product which helped the company run business effectively.
- 4+ years working with HortonWorks Hadoop Platform.
- Worked in Linux environment, advanced experience in shell and python scripting. Detailed knowledge of Unix operating systems.
AREAS OF EXPERTISE:
Big Data Ecosystems: Hadoop, YARN, MapReduce, SPARK, HBase, Pig, Hive, Sqoop, Flume, Impala, HUE, Drill, Oozie, STRaaS, Kafka, Cloudera Hadoop Stack, Netezza, AutoSys
Databases: MySQL, SQL Server, Oracle, Confidential V2R5/V2R6/12/13.
Programming Languages: Python, SQL, C/C#/C++, PHP, Ruby, Scala, Java, Perl, R Programming.
Tools: Eclipse, MS Visual Studio, IntelliJ, JIRA, Tableau, Microstrategy, SAS.
EXPERIENCE SUMMARY:
Confidential
Database Architect / DeveloperResponsibilities:
- Worked on a Confidential to Hadoop Migration project. The Pipeline was written for Confidential and ETL jobs were scheduled using UC4. The new pipeline involved converting Confidential SQL to Spark SQL. Developed data validation testing use cases.
- Wrote Pig, Hive and Map Reduce programs on clickstream data. Automated Unix Scripts through crontabs to run analysis on listings data at Confidential .
- Wrote Wrapper Scripts in Python for Distcp, Hadoop commands and logs analysis.
- Developed and supported ETL jobs into production for Confidential project. The ETL jobs entailed both Confidential and Hadoop scripts.
- Participated in Confidential \ Confidential for making buyers as sellers on Confidential as their old items could be re - listed if they had bought the same on Confidential . This was highly appreciated and encouraged as part of bringing innovation and driving business revenues.
Confidential
Database Architect / Developer (C/C++)
Responsibilities:
- Data modelled \ mapped, developed and deployed ETL code, wrote advanced Confidential SQL.
- Experience in extended stored procedures, db-link, packages, parameterized dynamic pl/sql to migrate the schema objects as per business requirements.
Confidential
Professional Services Consultant
Responsibilities:
- Worked on Confidential ETL for Mediation and Rating Engine (Calling Cards).
- Developed C++ application to download live ftp data consisting of CDRs (Call Detail Records)
- Developed a C\C++ application which automated Confidential Scripts and replaced considerable manual processing (approx 30 hours\project) to a single command line execution.