PROFESSIONAL SUMMARY:

• Over Ten years of experience in the field of Information Technology related to various aspects involving Data management, Data Modeling, Data warehousing, and data administration.
• Over 10 years of hands on experience in development with Oracle, SQL, PL/SQL
• Over 6 years of hands on experience in development with MS SQL Server
• Over 9 years of working in Financial industry with extensive knowledge on Risk Management, Equity, Fix Income, Derivatives product, Capital management .
• Database experience using Oracle 11g/10g/9i/8.x, MSSQL 2005/2008, DB2, SQL, PL/SQL, Sybase, SQL*Loader, SSMS, SSAS.
• Over 7 years of experience with Data Modeling using ERWIN 3.0/4.0
• More than 8 years of experience in UNIX shell scripting.
• Around 3 years of experience using Python programming.
• Over 8 years of ETL Data warehousing experience using Informatica Power Center v 9.x/8/7.x/6.x, Power Mart.
• Experience in OLTP,OLAP, Dimensional Modeling, Designing and building the Data Warehouse,.
• Solid experience in analytical queries, store procedure using programming language PL/SQL
• Strong application development lifecycle experience with excellent problem solving, analyzing skills.
• Involved in software life cycle development / programming including embedded SQL, stored procedures, requirements capture, analysis, design, implementation, testing and documentation.
• Over 4 years of experience in Object - Oriented design and development, Java, J2EE, middleware and enterprise application implementation
• Ability to work creatively and productively in a problem-solving fast paced multi task environment.
• Oracle Certified Professional & Microsoft Certified Technology Specialist SQL Server 2008

TECHNICAL SKILLS:

Database: Oracle 8.0/8i/9i/10g/11g,MSSQL 2005/2008, Sybase, DB2 9.7, MongoDB

Database Tools: TOAD, Embarcadero DBArtisan, SQL Plus, SQL loader, SSMS, SSAS, ERwin 3.x/4.1, PL/SQL Developer 5, Oracle developer 2000

Big Data Ecosystem: Spark, Hive, Pig,HBase,MongoDB,NoSQL

Programming Languages: SQL, PL/SQL, PERL, UNIX scripting, Python, Java (JDBC,RMI, EJB, Servlet), JavaScript

Reporting Tools: Crystal Report 9/10, Business Object

Operating Systems: Windows NT/98/2000/XP, UNIX

ETL Tools: Informatica Power Center/Power Mart 9.6/8.6/ 7.x/6. SSIS

Web Servers: IIS 4.0/5.0, Websphere

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Application Developer

Responsibilities:

• Developed data validations/rules using PL/SQL scripts as part of migration processes from Sybase to Oracle.
• Involved in the continuous enhancements and fixing of production problems.
• Wrote reusable store procedures to perform database maintenance as DB utilities used by applications.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Established data architecture and BI best practices, standards and data models; recommended data mart and reporting performance-tuning techniques..
• Wrote UNIX scripts to interact with Database and facilitate the data feeds and database maintenance activities.
• Program in Python as part of data extraction, acquisition and data processing.
• Extensively executed application performance analysis and implemented performance improvements

Environment: Oracle11g, Sybase, SQL Server 2008, Python, MongoDB,Toad, Embarcadero DBArtisan, UNIX, Windows, Autosys, Enterprise Visio, JIRA, Github

Confidential

Sr. Data Warehouse/ETL Developer

Responsibilities:

• Work as technical lead to handle the tasks of providing technical direction for developing, designing and integrating systems for a small offshore team.
• Responsible for building a FATCA Tax reporting solution required by HMRC regulation including Data Model design and implementation of data feeds.
• Work globally with business analysts and project managers to translate the business requirement to technical specification.
• Analyzed existing database designs and identify system deficiencies and implement effective solutions.
• Implement PL and SQL queries, triggers and Stored Procedures as per the design and development related requirements of the projects.
• Wrote reusable store procedures to perform database maintenance as DB utilities used by applications.
• Actively work on Informatica Power Center 9.6 Mapping Designer, Workflow Manager and repository manager to build up ETL data feeds.
• Extensively write SQL queries to extract data from existing upstream databases to analyzing the financial data, data quality, integrity.
• Support and evaluate data analytics initiatives, explore and recommend potential solutions for business users.
• Created UNIX scripts to dynamically to generate informatica parameter files which are used by different subject areas and wrote common shell scripts to interact with Database to perform common database activities.
• Coordinate with other technical teams to accommodate the software upgrades, environment setups and conduct system testing.

Environment: SQL Server 2008, Oracle11g/Teradata, Informatica Power Center 9.6, Toad, Embarcadero DBArtisan, RapidSQL, UNIX, Windows, Autosys, Perforce, Enterprise Visio, SVN.

Confidential

Senior Database/Data warehouse Developer

Responsibilities:

• Involve in analysis, design, development, and implementation of data warehouse used by risk management to process high volume data feed from all business lines within the bank.
• Work with application team to identify attributes and measurements for different type of assets (equity, derivatives, fix income) to facilitate calculation of market risk.
• Extensively write SQL queries to extract data from existing upstream databases to analyzing the market data, data quality, integrity.
• Work with business analyst to translate the business requirement to technical specification and manage data dictionary and business rules.
• In corporate the latest trends and techniques introduced in the market for improving the organizational efficiency and utilize different techniques to improve the performance.
• Assist project teams in overcoming the inefficiencies, problems and inconsistencies by coming up with feasible solutions in response to technical challenges.
• Created various Unix scripts to facilitate the ETL process and setup process configuration within script to automate the ETL process and enable the workflow running in parallel.
• Analyzed the database designs and provided more efficient designs and implementation using Visio and Re-architected data flow for efficiency.
• Work with internal reporting (JAVA) team to leverage technologies (JMS/ETL) to implement near real time risk reporting service
• Extensively and creatively worked on performance tuning in application level including utilizing parallelization in different level - System Infrastructure, database, ETL mapping, session, workflow, autosys jobs to maximize the process performance
• Worked on Informatica PowerCenter 8.6 Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations.

Environment: DB2, Oracle10g, MSSQL2008, Informatica Power Center 8.6,, Business Intelligence Development Studio, Embarcadero DBArtisan, UNIX, Perl, Autosys, Windows, Perforce, Enterprise Visio

Confidential

Senior Oracle Developer / Database Architect

Responsibilities:

• Used Erwin 7.1 for data modeling (logical and physical)and Dimensional Data Modeling.
• Involved in production code review and performed application performance tuning and production support.
• Extensively write PL/SQL to implement business logic for web-based OLTP and data warehouse application interfaces. Design and build ETL and OLTP processes using PL/SQL packages and triggers.
• Analyzed the database designs and provided more efficient designs and implementation using ERWin and application code reviewing for existing system .
• Performed the capacity planning required to create and maintain the databases.
• Developed database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Assists with impact analysis of any changes made to the database objects.
• Worked with system administrator to perform application and system analysis to optimize the overall system performance.
• Worked with quality assurance team to identify the information quality problem and provide solutions to address the data quality and processes defect for existing legacy system.
• Preform Data management and maintenances as secondary MSSQL DBA

Environment: Oracle10g, MSSQL2005/2008, Teradata, ERwin,Informatica Power Center 7.1, J2EE, UNIX, Window 2003

Confidential, NY

Application developer

Responsibilities:

• Extensively worked on SQL, PL/SQL and application performance tuning using explain plan and refactoring existing code to optimize the application performance.
• Involved in data modeling for FedTrade and data warehouse design document, develop, test, implement, and support new or existing applications software for Market Data management group
• Wrote SQL analytical queries to perform the role of analytical support.
• Extensively used TOAD to develop oracle PL/SQL, Stored Procedures, Materialized views to combine data from Old Data warehouse and New Data warehouse for reporting propose.
• Wrote SQL and Perl script to extract data from flat file and transform into Oracle database
• Wrote the build scripts to deploy the Oracle schema structure for different the environment.(Development, Integration, QA and production)
• Programmed in UNIX shell scripting, used cronjob and wrote shell scripts of running the store procedure to refresh materialized views in daily basis
• Used SQL*LOADER to transform the data from Windows generated file to Oracle database
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Mart/Power Center 7.1. Advance Logical and physical data models were designed from the requirements.
• Wrote test scripts and Performed Developer testing, Functional testing, No-Functional testing, Integration and regression testing for ETL tasks.
• Developed bar chart reports containing complex business logic by using Crystal report 10.

Environment: Oracle 9i/10g, Microsoft SQL Server 2005, TOAD 8.x/9.0, UNIX, J2EE, Erwin, Visio, SQL Developer, Informatica Power Center 8/7.x, Perl, Crystal report 9/10,, Windows 2003.