Leading Etl Developer Resume
Reston, VA
OBJECTIVE:
- An intellectual and challenging position that allows me to use my skills and experiences to enhance the efficiency and effectiveness of the organization.
PROFESSIONAL SUMMARY:
- Cutting - edge skill on cloud computing.
- Proficient with database modeling and design, database kernel, data warehouse, data mining and business intelligence reporting. Familiar with ETL concepts, NOSQL, and SQL-based reporting and analysis.
- Twenty years of experience developing critical communications software for International companies using full Software Development Life Cycle (SDLC).
- Expertise in developing applications using C/C++, SQL, Java, Shell Script.
- Expertise with service oriented architecture (SOA) and agile development.
- In-depth understanding and working experience with network programming, Win32 socket and SNMP Subagent development. Familiar with TCP/IP and network security.
- Outstanding leadership and communications skills as a team member. Self-starter and motivated.
- Passed CFA Level 1 in 2008.
TECHNICAL SKILLS:
Cloud Computing: AWS EC2/EMR/S3/SQS, Hadoop/Spark, Oozie/ActivitiLanguages: SQL, Python, Java, Shell Script, Scala, C/C++, XML/HTML, XSLT/CSS, UML
Web Server: Apache, IIS, Tomcat
Database: Hive/Pig, Hbase, Oracle, MySQL, postgres, SQL-Server, Netezza, Greenplum
Third Party Tools: Toad, Clearcase, Git, AccuRev, subversion, JIRA, Installshield, StartUML, Etherpeek, Valgrind, Eclipse, Pentaho, Cognos, Businessobject, Jenkins
Operating System: Windows, Linux (RedHat, Monta Vista, Solaris), VMWare
Network Protocols: TCP/IP, UDP, DNS, SSH, DHCP, RPC, HTTP, Telnet, FTP, SNMP, SOAP
Analysis tools: R, Pentaho, DataFlux
PROFESSIONAL EXPERIENCE:
Confidential
Leading ETL Developer
Environment: Linux, Python, Java, SQL, Netezza, Greeplum, AWS EC2, AWS EMR, Hadoop, Hive, TEZ, HBase, Oozie/Activiti, Spark, Splunk
Responsibilities:
- Design the General and Customized ETL process on AWS cloud.
- Provide proof of concept and evaluation on new technologies and tools on the AWS cloud.
- Streamlined and optimized the build and deployment process.
- Worked closely with Business Analysts to develop the expertise on New York Stock Exchange and Chicago Board Option Exchange data.
- Leading the ETL design on loading, validation and transform data to Netezza, Greenplum and AWS Cloud in Confidential using SQL, Java/Python, Shell scripts and Oozie workflow.
- Support Operation Team and periodical disaster recovery test.
- Generate Business Reports using Cognos.
- Setup the new server and test environment for QA.
Confidential
Data Warehouse Programmer/Analyst
Environment: Windows, Oracle 10g, Toad, Pentaho, BusinessObject, ERWin
Responsibilities:
- Worked with Project Manager on scope document and project planning.
- Evaluated the tools for data cleanup and data warehouse build - up (Informatica and Pentaho)
- Provided quality report to identify dirty data.
- Identify the source of dirty data
- Suggested data cleanse solutions.
- Advised on database architecture designs, development priorities, operation process optimization and application improvements.
Confidential, Reston, VA
Senior Software Consulting Engineer
Environment: Redhat Linux, MySQL, NET-SNMP, C++, AccuRev, JIRA, XML, SOAP
Responsibilities:
- Lead level participation in architecture, design, estimation and development planning.
- Designed configuration, diagnostics, and security modules and peer - reviewed other development areas, database schema, GUI,
- Created data collection, storage, backup and recovery scripts.
- Developed SNMP Adapter and configuration modules.
Confidential, Germantown, MD
Senior Software Engineer
Responsibilities:
- Muliple projects on front end and back end Network Operating Center Management on both Windows and UNIX/Linux Environment.