SUMMARY:

• Have 14+ years of rigorous multidimensional experience in research, architecture, design and development of complex financial and other data processing systems, multi - tier applications, database and data warehouse applications from end to end with exposure to the entire life cycle of a software development (SDLC).
• Experienced in analysis, design, implementation, and optimization of both database software and database applications including Oracle / MS SQL Server, Installation, Data Migration, ETL, Designing and actively supporting and maintaining DEV/PROD databases (24x7).
• Strong experience in Oracle, MS-SQL and Access database design, development, SQL and App SQL Tuning.
• Research, Design, implement, testing and migrate to production of various ORACLE ERP applications using Case Tools like Erwin, Designer 2000, UML & Oracle*CASE.
• Domain knowledge of Wireless Cell phone, Time & Attendance, Securities industry, “Card Not Present” / on-line, real time Credit card Authorization Recommendations for fraudulent purchases, Payment Processing, and Portfolio Management practices including portfolio analysis, reporting, financial modeling & risk analysis.
• Efficient with Conceptual, logical and physical database design, data flow diagrams design, Enterprise Data Warehouse Design, Operational Data store Design, Data mart Design and create Entity Relationship Diagrams using ErWin and making extensive use of UML and Design Patterns to keep up to date with all technical developments in the field. Reorganized the existing data models, data flows and data dictionaries into a MetaData Repository.
• Ability to work at multiple levels of metadata management project, including defining the metadata management architecture, managing the metadata project, mentoring metadata developers. Implement metadata and internal data standards and protocols for the developers to ensure completeness and accuracy.
• Experienced in Decision Support System (DSS), Oracle Business Intelligence system (OBIEE), Oracle Warehouse Builder (OWB), Tableau, OOPs technology and encryption systems development.
• Solid experience in ETL applications for high volume financial and other data processing using custom C++, VB scripts and various ETL tools including Informatica / Oracle Data Integrator with FTP/SFTP/ TCP/IP.
• Excellent communication, leadership, good team player and interpersonal skills with high level of motivation, innovation and a burning desire to learn new technologies.

TECHNICAL SKILLS:

Databases: Oracle 7.x - 12c, MS-SQL, MS Access

Prog Languages: Oracle PL/SQL, SQL, UNIX Shell, Java, J2EE, C, C++, Perl, HTML, C#

Tools: Informatica 9.x/8.x, Pervasive / Oracle Data Integrator (ODI) ETL Tool, OEM

PL/SQL developer IDE, Erwin: ER Studio, OBIEE 11.x, OWB, OLAP, VS2013VB.NET, Visio, Oracle Golden-Gate, TOAD, Eclipse, CVS, ClearCase, Tableau

Operating Systems: Unix (Sun Solaris, HP-UX), Win, Win 7-10, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Sr. Data Analyst

Responsibilities:

• Designed and developed DM, DW and Interfaces with in-house applications for other metrics and data.
• KPI and their trends for the different end user side and company services performances.
• Will provide the predictive analytics about the causes and their effects to the business and customers.
• The source data are being extracted from multiple databases, 3rd party tools and other Datawarehouse.
• Various business decisions are being made based on the contents from these reports.
• Development is being done for the above application on UNIX platform. Code has been written in extensive use of Oracle PL/SQL Packages, Procedures, OBIEE, UNIX shell script, VB.Net, Erwin - ER Studio, Tableau.

Confidential, NY, NY

Solution Data Architect and Data Warehouse Lead

Responsibilities:

• Objective and consistent application of citywide compensation pay rules and various benefit policies as defined by ‘collective bargaining agreements’ between multiple employee unions and the NY city administration.
• Automates the generation of pay, other compensations, requests and leave transactions.
• Automatically sends leave, overtime, requests and timesheets to the appropriate supervisors for approval.
• Interfaces with ‘Payroll Management System’ (PMS) for pay check and leave processing.
• Feeds the denormalized data to the ‘Reports’ and ‘Journal’ databases through Oracle Streams, Advanced Queues and ‘Oracle - Golden Gate’ real time data replication software.
• Since this is a governmental agency the ‘Journal’ database records all the events and activities related to this system for future auditing and lawsuit purpose.

Confidential

Lead member

Responsibilities:

• Research, architect and developed the new’ Confidential database systems that receive the data from the multiple agencies every day and translate those data and load in to these systems for further processing.
• Designed the logical and physical database systems with multiple relation, fact and dimensions tables, materialized views, triggers, sequences and constraints.
• Created logical and physical Confidential using ‘Erwin - ER Studio’ for these systems.
• Designed a Corporate Conceptual Model as an architecture migration target and developed procedures and documentation to map this model to the database models to facilitate information location.
• Designed the Data Models and DFD's (Data Flow Diagrams) by using ERWIN and Visio 5.0.
• Created Data Structures for Corporate Data Warehousing for Decision Support Systems (DSS- Confidential ).
• Worked on data warehousing component from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements.
• Designed, developed and enhanced the various ETL processes to load the required data from different agencies with multiple formats effectively using Informatica, PL/SQL packages and VB.NET.
• Created new data formats for Extract, Translate and Load (ETL) the data to ‘ Confidential ’ and ‘ Confidential ’ Confidential database systems with the consultations with various internal and external stake holders.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager.
• Performed data manipulation using basic functions and Informatica Transformation.
• Designed and developed multiple in-house Oracle PL/SQL package modules for data processing, data feeds, multiple reports creations and email the reports to multiple, participating agencies.
• Designed, assisted and developed OLAP Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, dashboards or scorecards based on business requirements.
• Participated in business requirements gatherings & prepared technical design specifications documents.
• Performed SQL tuning to improve the application performance. Used EM to identify high-resource consuming SQL and by running Explain Plans, gathering statistics, and rewriting the queries by using Hints.
• Used AWR reports for understanding and troubleshooting the performance problems in several levels of tracing, including session level, database level by using SQL TRACE, TKPROF, DBMS APPLICATION INFO, DBMS SUPPORT, and other methods to identify and troubleshoot performance issues.
• Lead architect for the configuration “Data-Analyzer” report which identifies anomalies in ‘data-contracts’ across all the application domains and produced a daily/weekly reports for the BA team to fix the problems.
• Designed, developed and supported the “Configuration Analyzer” report which produced a list of config-data deltas to the application architect for analysis/review and finally fixing them. The RCA Root Cause Analysis document not only highlighted the cause of the problem but included the short-term and long-term fixes that could be implemented by the project stake-holders after consultation with the other DEV teams.
• Modified the existing ‘CityTime’ system to improve the overall performance by changing the data flow.
• Created and maintaining multiple test and control scripts for QA tests, maintenance and proactive error finding using Oracle, UNIX, & VB scripts.
• Development is being done for the above application on UNIX and Windows platforms. Code has been written in extensive use of Oracle PL/SQL Packages, Procedures, Functions, Triggers, OWB, UNIX shell script, VB.Net, Erwin - ER Studio, Informatica.

Confidential, Iselin, NJ

Sr. Oracle Programmer

Responsibilities:

• Research, designed, developed and maintain the new Oracle PL/SQL modules that extracting data from various sources and recursively exploding the finished goods up to the bottom most level of ‘Bill of Materials’.
• Designed and developed multiple DOS shell scripts, VB code for ETL operation for data extractions.
• Developed the internal protocols and file formats for extract, translate and load the data to DB with the consultations with various departments including forecasting, planning, supply chain management and sales.
• Designed and developed MRP Oracle database schema including logical and physical schema.
• Created a comprehensive documentation and MRP schema - ER diagrams using Erwin studio.
• Created a Business Flow and Data Flow diagrams using MS Visio.
• Designed and developed multiple reports using ‘Tableau’ for internal clients from multiple data sources.
• Development is being done for the above application on Windows platforms. Code has been written in extensive use of Oracle PL/SQL Packages, Procedures, Functions, Triggers, DOS shell script, VB.Net, Erwin - ER Studio.

Confidential, New York, NY

Sr. Software Engineer

Responsibilities:

• Enhanced the existing multiple DB systems to remove the unused objects, merging the existing objects and created the maintenance script to manage after profound analyzing the DB.
• Research, designed and developed Oracle modules to implement the ETL processing of the raw data combined with VB code.
• Designed and developed various UNIX shell scripts, C++ code for ETL with FTP and SFTP protocols.
• Created a comprehensive ER diagrams for all databases using Erwin studio.
• Installed and setup the QA test environment of Oracle BI and Cognos 8.x for the client company.
• Development was being done for the above products on Sun-Solaris and Windows platforms. Code had been written in Oracle Procedures, Functions, PL/SQL Packages, Triggers, VB, MSQL 2008 using PL/SQL Developer, Erwin - ER Studio and SVN.

Confidential, Princeton, NJ

Sr. Software Developer .

Responsibilities:

• Research, designed and developed Java modules for the products which simulate the working environment for the multiple payment processors. This application completely eliminates the new clients to check, save money and do the necessary tune-ups before sending the actual transactions to the payment processors. Error and invalid transaction settlement causes a client to pay a hefty fine to the banks and credit card companies.
• Designed and developed various Java modules for highly secured socket and multi-threading applications to support other products using FTP, SFTP, HTTP and HTTPS protocols.
• Designed and developed a VB module to Tokenize the Credit card numbers to work with SAP and Oracle.
• Designed and developed a Java test modules for both server and client interfaces.
• Development was being done for the above products on Sun-Solaris, HP-Unix and Windows platforms. Code had been written in extensive use of Java, JBoss, eclipse, Oracle PL/SQL Packages, Procedures, Functions, Triggers, Perl, UNIX shell script, VB.Net, C++, HTML, and SVN

Confidential, Edison, NJ

Sr. Systems and Software Engineer

Responsibilities:

• Research, designed, developed and maintained 2 types of “fraud detection Oracle DB modules”, which reduced the online fraud by 22% and the ultimate savings of more than $175 millions clients’ money every year.
• Designed, developed and maintained new system procedures which dramatically reduced the network traffic by 70% to upload the high volume of negative data from various card issuers and banks using custom “Oracle PL/SQL, VB and C++” ETL scripts and tools (ODI / DAC) in to different databases and materialized views. These data will contribute for the final decision-making process substantially.
• Proposed and designed multiple complex rules transaction processing and Oracle service modules based on the clients requirements, which would reduce the online fraud by 14%.
• Designed, developed and maintained the new Oracle DB credit card charge-back processing application FTM from legacy system which eliminated 3 servers and multiple software licensing cost of $80,000.
• Designed the architecture of logical and highly secured PCI complain physical Oracle database including the schema design, multiple installations on Unix and Windows platforms for decision-making services.
• Designed and implemented the high-speed real time data replications including the configuration, between the various databases and servers using ‘Golden Gate’ Real Time data replication software.
• Research and designed the enhanced OBIEE and web based report application includes 8 Oracle modules and each has its own methods of creating reports for the various clients which will be used for their time based sales performance & fraud analysis.
• Active development team member in our other division innovative product “ Electronic Payment Processing ” system that predicts and prevents the money laundering, bank fraud, credit card fraud and online payment in real time for the merchants. This product is using self-learning “Neural Network” technology, which was developed by a Noble Prize winner Prof. Leon N. Cooper .
• Development was being done for the above products on Sun-Solaris and Windows platforms. Code had been written in extensive use of Oracle PL/SQL Packages, Procedures, Functions, Triggers, Streams, Pro C*, Perl, Unix shell script, VB, OBIEE-10.1.3.x, OLAP, Rogue Wave DBTools++, Tools.h++, C++, HTML, ASP.NET, Golden-gate software, Data Integrator ETL Tool, DAC, OEM and CVS.

Confidential, New York, NY

Sr. Software Engineer

Responsibilities:

• Designed, developed and maintained the new data validation procedures, which became the standard methods for all future data validations and processing for all clients using C++, Oracle and VB.
• Upload the dirty data and send back the corrected data using various custom C++ ETL scripts, FTP / SFTP / TCP / IP protocols.

Confidential, Piscataway, NJ

Software Engineer

Responsibilities:

• Designed, implemented and maintained IRE SQL, IRE Admin Utility modules for database front-end replacement using C++ and Rogue Wave Libraries for Unix and Win NT platforms.
• Designed implemented and maintained modules for Tree processing and dynamically build, execute the SQL statements and stores the results in Tree for future use, based on the user choice