Data Architect Database Developer

Jitendra Gupte

302-***-**** /******@**********.***

Data Architect/Lead Database developer

Professional Summary:

18+ Years of experience in Data Architect/Lead Database developer proficient in performance tuning T-SQL, fine tuning complex queries, stored procedures.

Experience in database designing, development, performance tuning, production and application support.

Possess strong experience in data modeling, data analysis and ETL.

Experience in developing Java/J2EE based multi-tier applications using web services, XML and JSP.

Experienced in complete lifecycle of technology projects including, Business Requirements, Technical Architecture, Design Specification, Development and Deployment.

Proficient in UNIX. Coordinating with teams spread across the globe. Have strong interpersonal skills.

TECHNICAL SKILLS

Programming Language : JAVA, and J2EE, Python, Perl, Transact SQL, JavaScript, C

Databases : SQL Server 2008, Sybase 12.x, Sybase 15.x,

HBase, Hadoop, HDFS

Operating System : Windows XP, UNIX, Linux.

Development Methodologies : Object Oriented Programming Strategy, Agile, Scrum

IDE : Eclipse, JBuilder

Application Servers : WebLogic, Tomcat, Jboss

PROFESSIONAL EXPERIENCE

BANK OF AMERICA (Pennington, NJ) Mar 18 - Present

Data Architect / Sql Server Developer

Prime Finance Technology

Designed and developed a new data warehouse to accommodate firms’ current needs and future growth.

Migrated the data from legacy systems to new data warehouses.

Developed a reporting framework to facilitate creation of new reports.

Collaborating with the UI team leads in integrating the reporting components.

Lead the teams spread across different geographical locations.

Actively work alongside senior business users on resolving any issues encountered and propose appropriate solutions.

Designed and developed a new client billing system for firms clearing and Asset based financing business.

Optimized the batch performance to meet the SLA.

Technology: SQL Server 2016, Java 1.6, XML

Citigroup (Warren, NJ) Oct 16 – Mar 18

Database Developer/Architect

Prime Finance Technology

Designed data warehouse for prime finance reporting. Developed reports for delta one products like equity swaps. Performed database analysis, troubleshooting and performance optimization.

Lead the teams spread across different geographical locations. Provided mentorship to junior developers.

Responsible for handling all application audits and providing requested details to auditors.

Actively work alongside business users on resolving any issues encountered and propose appropriate solutions. Optimized the batch performance to meet the SLA.

Prepared Analysis and Design documents as per prescribed standards.

Providing production support (first and second level support).

Developed complex SQL stored procedures.

Address the contention issues and improve performance.

Technology: SQL Server 2008, Java 1.6, JSP, XML, Tomcat, WebLogic.

RBC (Jersey City, NJ) March 14 – October 16

Associate

Back office Operations

As application custodian for various critical applications responsible for ensuring the applications meet enterprise wide compliance and regulatory mandates.

Responsible for handling all application audits and providing requested details to auditors.

Provided reports from the archival database to senior management as needed.

Improved performance of various critical feeds to meet the SLA.

Performed database analysis, troubleshooting and performance optimization.

Developed SQL stored procedures/ triggers.

Address the contention issues and improve performance.

Wrote shell scripts / Perl scripts to extract data from Sybase ASE and Sybase IQ servers.

Did enhancements for Margin calculator application based in Java.

Technology: Sybase 15, T-SQL, Java 1.6, Servlets, JavaScript, spring, JSP, XML, Tomcat

Bank of America (Pennington, NJ) April 13 – March 14

Senior Developer/ Systems Analyst

Wealth Management

Business Rules development

Developed BOM (Business Object Model) for the rules project based on XSD.

Developed functions to use in B2X mappings.

Authored business rules as per BRD.

Deployed the rules application on the server.

Did unit testing of the rules using SOAP UI.

Prepared Analysis and Design documents as per prescribed standards.

Technology: Sybase 15, Java 1.6, Ilog Jrules, IBM ODM 8.01, SOAP

Citigroup (Warren, NJ) Nov 11 – Mar 13

Senior Developer/ Systems Analyst

Prime Finance

RTI (Real time Inventory)

Performed the code analysis of Real time Inventory application and refactored the code base.

Created new modules. Merged / moved old modules. Refactored the maven configuration files.

Merged the various services where possible. Deployed and tested the code.

Changed the Junit tests where needed.

P&L

Part of the technology team responsible for developing and maintaining P&L system for the firm's Prime Finance group. Developed new ETL processes to populate a new data warehouse. This data warehouse enables management to have a consolidated view (P&L) of different business units of the firm.

Took the lead role in deploying new ETL processes (using Talend) for a firm wide initiative.

Developed/enhanced the data warehouse for the reporting system.

Defined metadata standards for data warehouse and ETL process.

Performed database analysis, troubleshooting and performance optimization.

Developed SQL stored procedures/ triggers. Created views for secure access to the data.

Technology: Sybase 12.5 T-SQL, Mongo DB, HDFS, Shell/Perl scripts, SQL Server 2008, Talend, Java 1.6

Morgan Stanley (New York, NY) Jan 10 – Oct 11

Contractor

Brokerage and Clearing System

Part of the technology team responsible for developing and maintaining Brokerage & Clearing systems for the financial controller group. The system is fed with equities and equity options trading data from firms trading applications. The data is also sourced from various exchanges. The system helps firms’ management to determine the cost of trading and ways to reduce it. The system is developed using Sybase T-SQL /Perl and Java (for fee calculations). Perl / Shell scripts are used to extract/transform (essentially as an ETL) data (equities trades as well as equity options) from/to various applications and to receive and send feeds to and from different vendors. Business Objects reporting (Using Webi) acts as the UI of the system. It is also used for analysis of the data and sending concise but crucial reports to top management.

Developed/enhanced the data warehouse for the reporting system.

Developed reports for prime brokerage clients for daily trading expenses.

Developed logical and physical database designs to implement the reporting system

Performed database analysis, troubleshooting and performance optimization.

Developed SQL stored procedures/ triggers. Created views for secure access to the data.

Created indexes on existing tables to improve query response time.

Trained business users to navigate Business Objects Info View and create WebI reports.

Implemented business rules using Ilog Jrules to be applied during fee calculations.

Developed BOM (Business Object Model) for the rules project based on POJO.

Technology: T-SQL, Sybase 12.5, Business Objects (BOXI), Autosys, Java, Jrules, XM, Shell/Perl scripts,

DTCC, Tampa Jan 08 – Sept 09

Database Architect

Back Office Support System

Part of the technology team responsible for developing and maintaining and supporting various BackOffice Systems applications for fixed income groups. The systems included various reconciliation applications, accounting applications and credit surveillance applications. The system is developed using Sybase /Perl and Java. Perl / Shell scripts are used to data extractions and transmission across various applications

Risk Management

Part of the technology team responsible for developing and maintaining various Risk Management applications. DTCC is a central Counterparty for broker- to -broker (or institutions) transactions of financial securities like equities, equity derivatives. The Risk Management Systems enables Risk Managers to estimate a company's exposure under various scenarios. The system is developed using Java and Sybase.

Technology: Sybase 15/12.5, T-SQL, Solaris 5.8, Shell/Perl scripts, Java, Servlets, JSP, Struts, XML.

UBS, New York Aug 05 - Dec 07

Lead Database Developer /Analyst

Whole Loans

Whole loans technology group develops, maintains and supports applications that facilitate loans trading and servicing. Conduit (Flow Loan purchasing), Confine (Mortgage data management), WLTS (Mortgage Trading and Accounting) are some of the applications under their umbrella. As a database lead extensively involved in guiding/advising team members and other project leads in designing new databases.

Responsibilities:

Coordinated with production DBAs to change the server parameters.

Created Shell Scripts to automate processes of loading the price sheets used for loan pricing.

Liaised directly with Trader’s Assistant (TA’s) to better understand the requirement.

Provided support to database developers and business users.

Implemented dynamic SQL in stored procedures for increased performance/productivity.

Formulated solutions to improve existing database designs, to be more responsive to ever changing business processes. Resulting in significant reduction in expenses

Technology: T-SQL, Sybase 12.5, Shell/Perl scripts, Java, Servlets, JSP, Struts, XML, Ant, Tomcat, Eclipse

Bank of New York, Teaneck, NJ May 04 - Aug 05

Senior Developer/ Systems Analyst

CTIR (Corporate Trust Investment Reporting)

This is a new website for the Corporate Trust Investment division of the Bank. It contains all the reports generated by analysts for all the products that are offered. These reports are published in a timely manner on this website, for Bank’s clients. Reports are stored in blob format in Sybase and retrieved from the database by the interface provided on the website. There is a cron job that uploads reports in the database.

Responsibilities:

Wrote Java stored procedures in DB2.

Wrote a data migration module to load data from legacy tables/ flat files into new tables.

Used embedded SQL in java. Wrote JSPs. Changed existing JSPs.

Involved in Analysis, Design and Development using J2EE components such as JSP, Servlets, and EJB.

Designed and implemented Entity Beans for the persistence layer. Used WebLogic as Application Server. Deployed EJBs in WebLogic 6.1.

Servlet was used to establish a database connection pool. UI generation using JSPs and Struts framework

Created documentation and Run Book. Provided the first level of support for all production issues.

Technology: Java, Servlets, HTML, JavaScript, JSP, EJB, XML, WebLogic 6.1, JBuilder, DB2, Solaris 5.8,

Education:

Bachelor of Science, University of Pune, India

Advanced Diploma in Computer Management, NIIT

Contact this candidate