SUMMARY

• 10+ yrs experience of strong software analysis, design and programming in financial, telecom
• 8+ yrs experience wif C/C++, Java, python, SQL, C#/VB, Oracle, SQL Server, Unix, Windows
• 5+yrs experience of Data warehousing, BI (ETL, SSIS,SSRS, Power BI, Informatica Power Center)
• 3+ yrs experience of data analytics (Servlet, JSP, JDBC, XML)
• Solid understanding of full lifecycle of software project and methodologies Agile and Devops
• Depth noledge and strong experience wif mission - critical, high available, real time system and system level development, performance optimization
• Excellent trouble shooting and problem solving skill

TECHNICAL SKILLS

Language: C#/C++/C, Java, Python, SAS, XML, UML, VB, SQL, shell script, Perl, Tcl/tk

Platform: Unix (HP/Solaris/AIX), Linux, NT, VMS, Vxworks, ucLinux, MontaVista, Hadoop, FDFS

Database: Oracle, DB2, Sybase, MS SQL Server

Tools: SSIS, SSRS, SSAS, Informatica Power center, Erwin, Power BI, Hive, HBase, Eclipse,Visual Studio, Weblogic, Websphere, FTFS, GIT, ClearCase,, SVN

Networking: TCP/IP, SIP,VoIP, SNMP, Ethernet, ATM, OC3, SONET/SDH, CPdump, Ethereal, AiroPeek, OmniPeek

PROFESSIONAL EXPERIENCE

ETL /BI Developer

Confidential

Responsibilities:

• Involved in business analysis, Erwin, modeling(Source/Target, logic/physical). Data warehousing data mart design and implementation
• Gather and document business requirements to design appropriate technical solution
• Analyzed legacy data sources to retrofit file redefinitions and occurrences to design the related Hive tables making use of complex data types
• Data mart Design and Modeling
• Design, develop and test ETL/ELT data processes SSIS
• Analyze source systems to determine integration approach
• Developed new and enhance existing SSRS reports
• Developed new and enhance existing SSAS cubes
• Liaise wif Business Analysts and Testers to support QA / UAT efforts
• Created and documented SSRS design standards and templates

Environment: MS SQL Server, Oracle; ERwin, ETL, SSIS, SSRS, TOAD, Hive, Execution Plan; T-SQL, Python, Excel, XML, TFS, Visual Studio, Power BI

ETL Developer

Confidential

Responsibilities:

• Analyze business requirements and design appropriate technical solutions to meet the needs of business users for project-based and ad-hoc reporting requests
• Design, develop and enhance ETL data flows
• Integrate data from various internal and external sources
• Analyze source systems to determine integration approach
• Develop new and enhance existing SSRS reports
• Develop new and enhance existing SSAS cubes
• Work wif Business Analysts and Testers to support QA / UAT efforts
• Analyze User data inquiries

Environment: Ms SQL Server, Oracle; ERwin, ETL SSIS, TOAD, Execution Plan; T-SQL, XML

SQL/ETL Developer

Confidential

Responsibilities:

• Successfully developed and implemented ETL processes including T-SQL scripts and stored procedures
• Developed SSRS stored procedures and reports
• Integrate data from various internal and external sources
• Analyze source systems to determine integration approach
• Designed and developed overall ETL flow including automation via BMC Control-M scheduling
• Modified dimensional data model to support new ETL processes
• Designed and implemented ETL deployment process
• Drafted ETL technical support document

Environment: Ms SQL Server, T-SQL, Cognos, Data Manager, BMC Control-M, SSIS, Data Analysis

Software Developer

Confidential

Responsibilities:

• Collaborate wif business analysts and solution architects in the initiation of new solutions and/or software programs and applications.
• Design, coding and test for a new application based on using Angular JS, Bootstrap, CSS,HTML, MyBatis, Cron job, to provide electronic business services for the brokered guaranteed investment market and promote automated transaction processing and information exchange by connecting issuers and distributors.
• Assist other developers, analysts, and designers in conceptualizing and developing new software programs and applications.
• Package and Deploy J2ee/web application on WebLogic server in the development environment.
• Provide production support and troubleshooting for bugs in all staging environments.

Environment: Java, HTML, JavaScript, JQuery, JSF, Struts, Hibernate, WebLogic XML, SQL Server, CVS, Maven, ANT, JUnit.

Software Engineer

Confidential

Responsibilities:

• Video on Demand reference and application development
• A reference design and system solution for our customer (Service provider, Carrier) to help them speed up their development
• Participate system architect requirement analysis, design and implement, basing on SDLC.
• Advise on system integration and evaluation of middle ware(or 3rd party’s) and development platform for our customer
• Integrate Open source and 3rd party subsystems
• Analyze online transaction and billing subsystem and design, implement some modules using JSP, Servlet and Struts
• Design the structure of the web pages using JSP, HTML and JavaScript.
• Participate to analyze business logic and abstract, encapsulate them in middle tier EJB
• Create tables, triggers, indexes, constraints and stored procedures
• New feature enhancement and bug fix; system, unit test