- Over 20 years of IT experience in the enterprise database ecosystem.
- Strong in Oracle PL/SQL and is passionate about data and understanding data relationships
- Strong in SQL Performance tuning, de-normalization techniques, and designing flexible and scalable ETL processes for very large volume global data-warehouse.
- Spark, Dataframe basics, and Python coding experience.
- Involved in all Seven steps of a data migration project.
- Commitment to quality from requirements through design, construction, testing, and installation.
- Experienced in database architecture, Data Analysis, Data Integration, Data Profiling, Data Modelling data lineage, data governance and data-warehouse design.
- Experienced in designing reconciliation between upstream and downstream systems.
- Good knowledge of Java, J5EE, and BI Reporting tools such as SAP Business warehouse.
- Worked in leading US Financial institutions such as Citi, Merrill Lynch, Capital One, Standard & Poor’s, Bank of New York, and Albridge Wealth Management solutions.
- Well-versed in Ralph Kimball Data Warehouse Design.
- Experience with Big Data ecosystem with processing engines Spark/Hive/Hadoop.
- Architect, design and build scalable infrastructure and platform to collect and process very large amounts of data (structured and unstructured), including streaming real-time and complex system integrations.
- Work in an IC Role as well as lead a team of designers as needed.
TECHNICAL SKILLS
Software: PL/SQL, UNIX, SQL, Erwin, Python, and Spark
Op. Systems: LINUX, Sun Solaris, HP-UNIX, NT
Databases: Oracle, Spark data frame, and Sybase
Internet: HTML, JAVA (working knowledge)
Project management tools: MS Office, MS Excel, MS Project, Visio