OBJECTIVE

• Seeking a software professional position that will utilize my broad understanding of various technologies and strategies.

SUMMARY

• Strong business analysis skills in financial & marketing businesses
• Strong ability to manage projects and drive deliverables, well - versed in agile software life cycle
• Self-starter with the ability to thrive in a fast paced environment and be able to deal with conflicting priorities with ease.
• Able to produce project and program artifacts in great quality.
• Able to confidently express the benefits and constraints of technology solutions to technology partners, stakeholders, team members, and senior levels of management
• Work effectively and cooperatively with various teams to get the job done on time
• Strong technical background and keen to learn about the new technology trend
• 16+ years of experience in enterprise data architecture, supporting high-performance, highly-available and scalable Information Management solutions
• Proven expertise in Relational and Dimensional Data Modeling
• Experience leading and architecting enterprise wide initiatives, specifically system integration, data warehouse build, data mart build, data lakes, etc. for a large enterprise
• Experience implementing and supporting Operational Data Stores, Data Warehouses, and Data Marts
• Experience with physical, logical, and conceptual data modeling
• Experience with implementing data reporting and visualization tools
• Implement fixes and enhancements, create Test Plans, Test Cases and perform unit and integration testing

TECHNICAL SKILLS

Oracle: Certified Oracle DBA; Strong experience in physical and logical database design. Strong skills of writing SQL, PL/SQL, performance tuning, external table and analytical functions. Familiar with the tasks of application DBA, such as Export/Import and SQL Loader. Java 3+ years’ experience of writing Java applications

Business Objects: Strong experience in creating universes and building complicate summary reports.

C++: 2+ years’ experience; Knowledge of makefiles, source-level debugger, program development environment and Standard Template Library (STL)

XML/XSL: 1-2 years’ experience; knowledge of Apache’s XML parser and XSLT processor

Others: RStudio, Data Science, Data Analysis

Softwares: Erwin, Oracle Enterprise Manager, TOAD, PL/SQL developer, Ctrl-M, IBM Datastage TX (formerly known as Mercator), F-Secure, Visio 2000, JBuilder, TFS

PROFESSIONAL EXPERIENCE

Confidential, Wilton, CT

Manager, Business Systems Analysis

Responsibilities:

• Mainly work on the Enterprise Risk Management system which is used to set up Confidential ’s corporate risk strategies.
• Working as a Tech Lead for the data migration project which kept the old systems running while developing and feeding the data into the new system, and keeping them in sync. Confidential has lots of legacy systems which need to be consolidated or retired. The initial set up of ERM (Enterprise Risk Management) system referential data was implemented using agile development cycles. While feeding the data into the new system, we made lots of compatibility test to make sure it would satisfy the needs of the downstream systems.
• In charge of important database development work to support trading and risk management. Created logically complicated PL/SQL packages to calculate daily credit capital capacity for the risk management team. It used all the risk attributes in the system. Have done extensive reconciliation and QA with the front end programs.
• Understanding of Waterfall, Agile, Scrum Methodologies.
• Being an effective leader for junior developers regarding how to manage work load and set up priorities.
• Analyze thoroughly the business requirements, provide efficient solutions for business users, enhance the existing processes, and improve the infrastructures and database frameworks.
• Responsible for managing and organizing the data by analyzing, developing and implementing data models, policies and standards.
• Develops Data Models for the Enterprise Risk Management portfolio that support the integration and organization of data / information across systems. Having deep understanding of the enterprise risk management data models and data flows.
• Work with Business, Architects and System Analysts to fully understand the business requirements and translate them into Conceptual, Logical and Physical models.
• Design and implement BI data models as well as the process for loading data while adhering to architectural requirements of maintainability and scalability. Support business intelligence development initiatives and interact with the business partners throughout the development life cycle.
• Coordinate data models, data dictionaries, and other database documentation across multiple applications
• Partner with DBAs to transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database.
• Work with Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata.
• Experience with a data modeling tool, such as ErWin.
• Develop technical designs, process flows, code development, unit/system/UAT testing, and post implementation support.
• Making fast root cause analysis and provide effective system issue resolution.
• Always strive to understand the challenges and opportunities; formulate and propose innovative uses of data assets that can help solving real and material business issues.

Technologies used: Oracle 11g/12c, Erwin, SQL, PL / SQL, TOAD, Microstrategy Reporting, TFS

Confidential, Stamford, CT

Sr. Database Developer / DBA

Responsibilities:

• Responsible for the database development work to support the trading, accounting and finance departments.
• Working as a part time DBA to ensure the oracle database working efficiently.
• Writing sophisticated PL/SQL packages to facilitate accounting teams to reconcile complicate physical allocations of commodity trading records.
• Building Business Objects reports to provide accounting teams quick overview of the comparison of different monthly accounting data.
• Maintain SQL Server procedures to support the cotton trading system.

Technologies used: Oracle 9i / 10g, SQL, PL / SQL, Business Objects XI, Sybase, SQL Server 2008

Confidential, NY

Tech Lead, Data Warehouse

Responsibilities:

• Responsible for the design, architect, development and delivery of Data warehousing and integration related solutions within the data delivery team.
• Work with DBAs, developers to improve the maintainability, the scalability, and the sustainability of the data warehousing solutions to meet the strategic needs of the business.
• Investigate and explore the best solutions to deliver the data to the end users by using various technologies such as Informatica ETL transformation, PL/SQL and Microstrategy.
• Ensure the quality of the data warehousing team's deliverables.
• Provide query performance tuning against a terabyte database.
• Help the security team to enforce the security policies across different business divisions.

Technologies used: Oracle 9i / 10g, SQL, PL / SQL, TOAD, Erwin 4.1, Informatica 8.1.1, Microstrategy 8.0

Confidential, NY

Data Architect

Responsibilities:

• Support commodity trading business process design and systems implementations.
• The key IT initiatives include the implementation of a trade management system, position and financial data warehouse, and performance attribution and market risk analytics systems.
• Create and maintain data architecture to increase the robustness, performance, and scalability of the entire system. Take ownership of the design and development of the DB layer functionalities.
• Establish coding standards for JDBC, stored procedures, triggers, and logical and physical schema design and enforce them within the development staff.
• Work with project managers and business analysts to provide technical expertise and solutions to different projects, such as maintaining marketing data and building ETL processes for position data warehouse of commodity trading.
• Perform impact analysis and create technical specifications and test plans. Work with front-end architects to improve existing OLTP model and increase the overall data throughput.
• Tune SQL queries and improve database performance for both OLTP and OLAP systems.
• Participate in design and code reviews, documentation of design, and implementation of methodologies to ensure high quality software.
• Provide timely work estimates for change requests for on-going maintenance tasks.

Technologies used: Oracle 9i, SQL, PL / SQL, TOAD, Erwin, OEM, Tibco

Confidential, NY

Sr. Oracle Developer / Data Analyst

Responsibilities:

• Working on different projects, which involve making enhancements for clients’ pension plan set-ups or other asset managements.
• Write oracle stored procedures, analytical functions and create materialized views etc.
• Participate in the design of new enhancements for database projects.

Technologies used: Oracle 9i / 10g, PL/SQL developer, DBArtisan 7.0

Confidential, CT

Oracle Developer / Data Modeler / Data Analyst

Responsibilities:

• Working as a team member of Data Integration Group, which provides various database supports for data warehouse reporting projects and internal business applications.
• Building online applications using Java 2.0, iPlanet WebServer, Weblogic 6.0, Java Servlet, JavaScript, XML/XSL, Oracle 8i and HTML.

Confidential, CT

Java Developer

Responsibilities:

• Using J++ 6.0, IBM VisualAge 3.0, Oracle 8.0, SQL, PL/SQL and IBM XML parser to build search engines for healthcare providers.
• The application provides great supports for doctors to search their clinical data efficiently.

Confidential, CT

Programmer

Responsibilities:

• Participated in assessment of Y2K problem.
• Assisted in design and implementation of a small product management software that enabled users to enter and track product information.