SUMMARY:

• Creative Senior Software Engineer offering +15 years of experience. Enthusiastic about developing forward - thinking solutions to tomorrow's productivity problems. Resourceful with adaptable approach to challenges. Proficient in SQL, R, SQL, Python, AWS and Agile/SCRUM methodology.
• Data Analytics, Big Data, and Predictive Analytics Certificate - Ryerson university - 2017
• Bachelor of Science Degree in Computer Software Engineering
• Over 10 years of experience in developing Relational Database Management Systems, back-end / front-end applications with recent exposure to NoSQL databases like Apache HBase, Cassandra, MongoDB
• Over 5 years of experience in Data integration, Data Warehouse, and Data Management, Extract, Transform, and load (ETL)
• Proven track record in designing, modeling, and analyses of data for online Transaction Processing (OLTP), and Business Intelligent (BI) applications
• Strong knowledge in Hadoop ecosystem, Hive, Pig, Spark / Scala, and Sqoop, AWS, Internet of Thing (IoT), Analytic methods, machine learning, depth learning
• In depth understanding of different line of businesses in finical sector (Mutual Funds, Capital Market, Investor Line)
• Exceptional communication and presentation skills with an established track record of successful client interactions, strong analytical thinking, multi-tasking, and problem solving skills
• Self-supervised professional, with strong team player skills and natural tendency to challenge status quo and ability to think outside of the box, Result oriented with excellent time management and organization skills

TECHNICAL SKILLS:

Big Data: Apache Spark / Scala, Hadoop HDFS, HIVE, PIG, AWSRDBMS/NoSql: Oracle 11g 12C, SQL Server 2013, DB2, MySQL, MongoDB, Casandra, Graph DB, Neo4j

Programming Language: Python, Perl, Java Script, C/C++, PL/SQL, UNIX Shell Script, XML

BI/ ETL Tools: Tableau, Qlick, Talend, Informatica

Operating System: Unix-HP, Linux, Windows server 2000

Data modeling tools: ER Win 8, Power Designer, Oracle Designer

Software methodology: Agile / Scrum, SDLC, UML

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Software Engineer / Data Analytics

• Lead a team consists of five developers and business analysts for create a new cloud-base portfolio management system ($1.5-million project) that aims to enhance the existing system in terms of functionalities, user-experience, performance, reliability, and scalability.
• Develop a complex visualized dashboard that analyses end-user satisfaction and system accessibilities using Talend, and Tableau.
• Manage a cross functional collaboration among multiple development teams in order to analyze potential system solutions based on evolving client requirements and enhance relational data model.
• Manage a team of 10 offshore IT technical supports and QA team to ensure accurate resolution of issues/incidences reported by business and alignment of solutions with business objectives
• Designed and implemented software components for Rate of Returns conversion project that was considered highly complex and mathematic intensive project using scientific analysis and mathematical models to predict and measure outcomes and design consequences.
• Managed end to end Integration of data from several complex investment applications into one API application, using design thinking method, enhancing customer experience leading to 20% increase in Wealth management line of business.
• Revised, modularized and updated old code bases to modern development standards, reducing operating costs 50%.
• Designed and developed real time data processing system for trading department by analyzing database of 100GB data, using R.
• Collaborated with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.
• Interviewed co-op students, provided mentorship and guidance, and assigned projects/tasks to them during their internship period.
• Developed, designed and implemented upgrade of Oracle DB from 11g to 12C, and documented all phases of project.

Environments: Oracle, R, Perl, Talend, Tableau, UNIX shell, PL/SQL, Java

Confidential

Sr. Software Engineer / Team lead

• Ongoing support, analysis and development associated with change requests of Retail Information System (MIS), following the agile method framework to ensure priorities are addressed with input from stakeholders (Product Management, Engineering, Operations).
• Provided requirements analysis and documented detailed requirements for CRIMS Mutual Fund Straight through Processing (via FIS) as well as process and data maps, demos, business/context/system, diagrams, use cases, working with Charles River experts, in-house development teams, program managers as well as mutual funds operations team.
• Provided analysis and prepared high-level requirements document for a composite performance reporting project.
• Participated in requirements gathering analysis for CRIMS Compliance module to be enabled for firm and account level pre-trade and portfolio level surveillance, identified necessary data elements and done research analysis on CRIMS out-of-the-box compliance reports.
• Prepared requirements document for a number of change/enhancement requests, follow up with DEV, QA and UAT support.
• Day to day maintenance of artefacts and project SharePoint site maintenance as it relates to analysis documentation.
• Provided data analysis to define scope, requirement priorities and associated risks of multiple project
• Created data model and metrics for reporting to senior executives and management reporting.
• Provided technical and business consultation to compliance officer and senior management from marketing department in relation to creating score card reports for evaluating investment advisor’s performance.
• Managed and executed oracle upgrade, data extract from Retail Information System (RIS) to HUB (Netezza), and Data Warehouse for marketing department (using IBM data stage).
• Led project meeting and provide effect resolution for tuning data base, increase performance and data security.
• Developed implementation and test plan for Charles river upgrade (Trading system) project
• Improved support process by managing business requirement, implementing response process and lookup repository for application support and development team.
• Reversed engineered the reports and identified the data elements, Dimensions, Facts and Measure required for the reports.
• Provided complex ad-hoc reports to project team and help them to understand the system and have better decision, using Oracle SQL, SAS, TIBCO, and Tableau.
• Interact with technical specialist, developers, application managers, and business analyst during the gathering of BRD, solution verification and release
• Review, assess and evaluate application updates with the development team to ensure optimal performance.
• Designed and developed a report package for compliance auditors to improve regulatory audit process.
• Created several automatic batch reports for compliance team based on FATCA and AML requirement and sent the result to mainframe.
• Designed Sales hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.

Environments: Oracle, SAS, Tableau, UNIX shell, PL/SQL, Java

Confidential

Sr. Software Engineer / Development Lead

• Performed code review sessions with other developers and suggested improvements/ alternate strategies.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Developed a Conceptual model using Erwin based on requirement analysis.
• Normalized Logical and Physical data model using Erwin.
• Studied in-house requirements for the Data warehouse to be developed.
• Managed tracking and resolving database related incidents and requests, within SLAs, reviewing service-related reports.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Designed and developed several data extraction procedures using oracle triggers and resolved issues (using PL/SQL, T-SQL, and SQL server 2005, Informatica).

Environments: SQL server, UNIX shell, PL/SQL, .NET

Confidential

Sr. Software Developer

• Migrated Application from oracle 4.5 to oracle suite 10g by providing new functionality and new performance (Using Oracle forms/reports PL/SQL) to .NET application.
• Designed report for .NET front end application using crystal report and provided test to ensure layout is same as existing reports
• Developed management reporting application based on 4 different applications and databases for BOING company
• Co-ordinated code review with joiner developer and provided professional advice to the team to increase the performance and reduce security issues