SUMMARY:

• 11+ years of experience in full software development life cycle (SDLC) including analysis, design, coding, testing and implementation for the insurance and financial industries
• Advanced data mining techniques tools and algorithms, knowledge of big data strategy, Hadoop, HBase, Hive,MapReduce
• Extensive experience in database development and performance tuning (Postgres,Oracle, Sybase ASE/IQ, SQL server, Netezza)
• Lead in database design/data modeling from conceptual models to physical models
• Demonstrated expertise in developing Server/Middleware, Web based and Client/Server applications
• Strong working relationships with team members, clients, counterparts, vendors and offshore teams. Excellent conflict resolution and negotiation skills
• Proven ability to analyze, plan, manage and motivate
• Wide spectrum of hands on application development skills utilizing various technologies (Hadoop, JAVA, .NET, SQL)
• Broad business knowledge in the insurance and financial industries
• Highly self - motivated, resourceful and adaptive team leader/player
• Superior ability to achieve immediate and long-term goals
• Expert level in Netezza SQL Analytic Function, stored procedure

SKILL:

Internet: LDAP, Java Servlets, JavaScript, VBScript, ASP, HTML, XSLT

Cloud: AWS Web Service (EC2, S3, EMR,RDS, SQS), Presto, Hadoop, Python

Database: Postgres, Oracle 12.6, Hive, Presto, Netezza, MS SQL server,SYBASE(ASE/IQ), Bachman, ERWin, Power Designer, Transact SQL, Open Client, IBM DB2, UDB

Language: Java, SQL,XML, XSLT, C++, UNI shell, Perl, Python, AWK, SAS, Business Object XI 3.0.

Tools: Hadoop,Aqua data Studio, Spring Frame work, Eclipse Luna, Maven, Restful Service, Hibernate, putty, Splunk,Postman, pgAdmin, Toad for Oracle,AXIS 2.0, JAX 2.0, MS Visual Studio, Autosys, Jams Client, Sqoop, Stash(SourceTree), SVN/CVS, JIRA, Winscp, R Studio, MS SharePoint, BuildForge, Maestro

OS: Windows, Linux, UNIX, Sun Solaris

WORK EXPERIENCE:

Senior Developer/data Architect

Confidential, New York

Responsibilities:

• Onboard the CBOE bridge pattern to AWS S3 and oracle database using in-house framework.
• Develope hive query for ETL process
• Develope Presto query for Exception view report
• Migrate Oracle statitc table to PostgreSql using AWS database Migration service
• Load data from on-Prem file to S3 using Java
• Using Hive, Hadoop, Unix shell, Perl, Python, Java JDK 1.8, Maven, sqoop, AWS DMS

Senior Application developer/Architech

Confidential, New York

Responsibilities:

• Migrate existing imagine application Version 6 to Imagine Version 7 and Sybase 12.5 to 15.7
• Install and configure Imagine trading system and back office tools on Linux
• Redesign/develop dividend calculation module to replace existing vendor dividend calculation
• Support existing Imagine Application (Batch process, database purge, bug fix, AUTOSYS job change, build script, LOPR report etc.)
• Fine tune stored procedure and query
• Using Sybase ASE 15.7, Stored Procs,Triggers Unix shell, Perl, Java JDK 1.6

AVP/Senior Developer/Data Architech

Confidential, New York/New Jersey

Responsibilities:

• Identify risk trades, Calculate loss, Allocate the loss among different allocations and blocks.
• Using Java JDK 1.5/1.6, DB2, Netezza, KDB+ and spring.
• Equity Surveillance/Complaince Report
• Analyzed data needs for various Compliance reporting
• Designe fees fact tables for fee calculation (FIAT fees and Sec 31 fees)
• Implemente ETL process with Informatica for data loading.
• Complaince Report includes Off Premise and After hours report, Self help report and Market Access/Threshold report, Mocloc, etc
• Using Netezza stored procedure, nzload, and Informatica,Java and Business object
• OATS (Order Audit Trail System) recertification
• OATS require member firms to record in electronic form and to report to Confidential certain information related to equity NASDAQ and other OTC securities orders. Confidential uses the reported information to build a time sequenced audit trail for surveillance and examination purposes.
• Validate & reconcile OATS reporting to expected output for each test case
• Review list of test cases not found in production during the prior three months to certify that they are invalid
• Produce Recertification pack which provides an overview of the testing results
• Maintenance of Equity Trade & Transaction Reporting Test Case Library based on Change Management function
• Using Netezza NZSQL, stored procedure, UNIX Shell, Perl, Business Object Report, Informatica and NZload
• Build the book (level II non-dark pool market data) from NBBO market data
• Estimate dark pool Quote
• Calculate book snapshot
• Enrichment with Strategy Parameters, Restrictions and source systems
• Convert existing logic from KDB to Netezza
• Responsible for the redesign of the Variable Calculation and Analysis System which involved migrating the original calculation engine to an existing data warehouse
• Translate Business/Technical requirements into programmed application modules
• Design new rate engine feed and various criteria
• Design COI database to suit Star Schema and Performed detailed analysis for data quality issues and proposed solutions for fixing them
• Implemented ETL process with Informatics for data loading
• Design new path filter, validation and calculation rule for fees indicated above
• Design the reporting and front end
• Designed and implemented the process to load reference data from various data sources, including PathFinder, ESM, Chorus and SDS system using Java JDK 1.5, WebService, XML, AXIS 2.0, Xpath and TibcoRV
• Loaded raw feed from source system and validated by product, account, currency, exchange
• Created working table for partially and invalid trades, calculated all the fees using rule engine, aggregate data on liquidity to position level (post to Quest) using Java, Hibernate, Terracotta, Sybase ASE
• Designed transfer schema for data in Sybase ASE being transferred to Sybase IQ for report, Created Business Object report for data mining and analysis, fine tuned the report query to minimize the report generation time
• Automated Exception report, Control report, Equity Count and Effective Rate report generation
• Created dynamic purge process for Sybase ASE/Sybase IQ to run on daily and weekly basis
• Loaded external fees from different exchanges (NYSE ARCA,AMEX, CBOE, Turquoise, direct edge, EMCF, and other EURO exchange) using Perl 5.0, and UNIX shell
• Completed several projects on data conversion from Sybase IQ 12.7 to Oracle/SQL evaluation using BCP and freeBCP
• Designed and deployed complex business rules views/stored procedures/triggers/cursors
• Performing data mining for mismatched business data
• Monitoring Database to pro-actively fine tune performance issues

Confidential

Sr. Developer

Responsibilities:

• Worked with various business areas (Front Office, Middle Office, Data Management, Research) and IT teams to develop and support a series of applications critical to the investments financial operations. Utilized skills in Core Java, Servlet, JSP, JDBC, and SQL Server to develop such applications
• Loaded and aggregated data from different sources - relational DB, flat files, Excel files, and XML files using core Java, JDBC and Perl scripts
• Managed user access, reports and applications running on the investments web portal. The portal was built with a combination of technologies including WebSphere, Vignette Content Management and LDAP. Reports accessible through the portal were developed using Actuate and SSRS. Created portlet application for multimedia resource management, enabling users to request and reserve multimedia resources online. Created investment orgchart
• Performed database design, developed stored procedures and database performance tuning
• Developed and supported a number of reports used in the daily and monthly Investments financial operations. The reports were written using MS SQL, SQL Server Reporting Services (SSRS) and Actuate. Implemented a .NET console application to generate Excel files/reports. Implemented the portlet to allow use to launch Actuate E spreadsheet Reports

Confidential

Technical lead

Responsibilities:

• Lead in design and development of database and applications for Confidential Individual Business “Laptop Project.” This project aimed to provide 8,000+ sales reps with laptops and applications to assist them in selling and prospecting at point of sale as well as managing their clients and accounts. The development was performed using the following tools: Sybase SQL Anywhere, Bachman, Power-designer, SQL Remote, PowerBuilder, Perl, and WATCOM SQL, VB, Microsoft DOM object 5.0, ASP and JSP. Serviced-oriented architecture was utilized to achieve maximum performance
• TSE user login validation communicate XML DOM object/Web service get the agent data and parse XML
• Lead in design and implementation of the EasyLink Application for Client Data System. This VB-based Windows application allows Confidential agents to collect client information and replicate the client data to consolidate database. It also loads data from MetDirect flat file to their current CDS application database
• Lead in design and implementation on conceptual and logical process modeling for future state database ( a corporate wide customer database)
• Completed on logical and physical Data Architecture Design of a variety of applications (Annuity, Future Focus, Life Insurance, Property and Casualty and FURR) which included Data Analysis, Entity Relationship Diagrams, Data Distribution and Replication Models

Developer

Confidential, Jersey City

Responsibilities:

• Participated in the analysis, design, programming and implementation of Futures Information Retrieval System. The system operates in a client/server environment utilizing PowerBuilder running as the GUI front-end with the Sybase SQL server database running off SUN as the back-end., implementing Tools using AWK, UNIX shell programming
• Designed and implemented stored procedures and DB-library programs to retrieve, update and insert data into the Sybase database
• Performed Omni stored procedure optimization and performance tuning. Used Omni SQL Server to retrieve data from different resources