Resume

Sign in

Sql Developer

Location:
Trenton, New Jersey, United States
Posted:
January 01, 2018

Contact this candidate

Srihari Tallapaneni 615-***-**** / ac3vfz@r.postjobfree.com

Summary:

Over 15 years of IT experience in System Analysis, Design, Support, Maintenance, Testing and Development of various systems using various Databases - Oracle, Sybase, SQL Server and DW/BI-Informatica technologies.

Good team player as Lead/Developer/Data Analyst/Developer/Data Architect.

Experience in Oracle PL/SQL including writing queries, stored procedures, functions, packages and triggers.

Proficient in Query Optimization, Debugging and Tuning for improving performance of applications.

Expertise in oracle data pump – expdp, impdp, export, import and SQL*Loader utilities.

Experience in trade support front office, middle and back office applications – Charles River Development (CRD), Trade booking applications, Surveillance and restricted stock applications.

Experience in the design and development of reporting solutions to provide various kinds of compliance and FINRA reports based on business user requirement.

Experience in research various data sources and target mapping analysis to validate customer, accounts, Positions, Cash balance, margin data and security data.

Experience in using job scheduling tools – Control-M, Autosys and Tidal

Excellent knowledge and working experience in with validation strategies, validation planning, validation scripts and validation results analysis.

Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas. Thorough knowledge of Data modeling concepts including Dimensional Modeling.

Experience in designing and development of Data Warehouse/Data Mart Analysis.

Experience in code migrations/deployment for testing/production environments.

Experience in preparing documentation at various stages of system life cycle, which involves functional specification, user Manual and technical review.

Experience in using Linux, UNIX commands and Shell Scripting.

Experienced in Oracle Forms 6i, reports 6i ASP,.NET and Java Technologies

Extensive working knowledge of the full Software Development Lifecycle (SDLC).

Excellent Team Member and Team leader with excellent interpersonal skills and is highly dedicated and experienced.

Certifications:

Certified in National Stock Exchange in Financial Markets (NCFM)

Managerial Excellence Program (MEP) from Duke University, USA

Education: MS in Software Systems, BITS, Pilani, India

Technical Skills

Operating Systems: Linux, UNIX, windows 95/98/NT 4.0/XP

Languages: SQL, PL/SQL, T-SQL, Shell Scripting, HTML, XML

RDBMS: Oracle10g/11g, SQL Server, Netezza, Sybase, DB2

Administration Utilities: Export, Import, Data Pump SQL*Loader, NZload, NZsql, NZadmin

Tools: Informatica, TOAD, Optim, PowerShell, Control-M, Autosys, Quality Center, Crystal Reports, Hyperion Essbase, Hyperion Planning, Erwin, Visio, Microsoft VSS6.0, Ab initio, WinSQL, Forms, Reports, V.B6.0, CVS, Eclipse, Aginity Netezza Workbench

Web Related: VBscript, SOAP, IIS4.0, Web Logic, XSL, Java, WSDL

Domain Knowledge: Finance, Trading, Compliance, Risk, Telecom, Health Care Manufacturing, and Enterprise Performance Management.

First Republic Bank, NY Nov, 2016 – Present Sr.Developer

NextGen Digital Platform Online Banking platform redefines FRB's online service offering. Best in class solutions are integrated into a customized User Interface to create a compelling digital service consistent with our highly personalized service. It provides access/authentication components for the new Digital banking solution and integrates customer self-service capabilities.

CIDMS provides a platform for enterprise wide customer identity management, Single Sign On using standard SAML, user and password policy management, as well as user provisioning.

Responsibilities:

Experience in writing, reviewing PL/SQL stored procedures (procedures, functions, packages, triggers, views, MVs and other database objects).

Developed Adhoc Reports (SQL or PL/SQL scripts running in Unix System) to extract data from database and deliver to user in Excel format.

Created DDL scripts (partitioned tables, indexes, materialized views and others).

Worked on Production issues: debugging and fixing errors, tuning SQL queries, checking indexes usage. Worked with different teams to coordinate disaster recovery/database backup and archiving of critical data.

Worked on different weekly, monthly incident level status reports for various business requirements.

Experience in perform complex data analysis in OLBS and identity management applications using SQL.

Participated in PL/SQL, TSQL performance tuning of stored procedures and tables for better performance on reporting and updates.

Created different test cases for integration, QA, UAT, PROD testing along with business users and provided QA/UAT and Production remediation. Worked closely with the UAT team for QC/JIRA resolution and bug fixes.

Working with other DEV teams and infrastructure team providing oversight and input for engineering strategy. Worked closely with infrastructure team in monitoring critical alerts in production environment.

Environment: Oracle 11g (SQL, PL/SQL), Sybase, Informatica, SQL Server, Control-M, SOAP, XML,J2EE, Linux,Visio,Erwin

Credit Suisse, NY Jun,2013 – Oct,2016

Sr.Developer

Private Banking - Trade Applications

Charles River Investment Management Solution (Charles River IMS) automates front and middle office investment management functions for buy-side firms in the institutional asset and fund management, private wealth, alternative investments.

QTE is a Trade Booking Platform used by the Equities Trading Desk to assign executed trades to accounts and transmit them to Pershing. The remainder of the trades is manually booked in QTE by the trading desk. Once these trades are booked, they are sent to Pershing in Real-time.

Protegent Surveillance provides a platform which addresses compliance, surveillance and suitability needs of financial service organizations. Protegent Surveillance analyzes trade, account, position and client data, to support review of transactions, accounts and client holdings.

Restricted Stock system is used to submit requests of Sale, Loan, and 105B1 plans. When a client requests to sell securities, the relationship manager (RM) enters the request of sale in R-Stock, which gets sent to the Legal and Compliance Department.

Responsibilities:

Experience in writing, reviewing PL/SQL stored procedures (procedures, functions, packages, triggers, views, MVs and other database objects) and Informatica mappings.

Created DDL scripts (partitioned tables, indexes, materialized views and others).

Expertise in diagnose root cause, problem solving and identify solution alternatives for various kinds of business scenarios.

Experience in research various data sources and target mapping analysis to validate customer, accounts, Positions, Cash balance, margin data and security data.

Experienced deep understanding of Trading workflow, Manager Workbench, Blotters and Compliance to address all production issues as they arise.

Experience in analyzing Cusip, ISIN, FIX tag, Gaotag information for various kinds of trade issues and providing solutions to resolve issues.

Experience in analyzing Bloomberg, Pershing files security information loads into trade systems.

Experience in pre/post trade various application batch data loads from upstream and to downstream.

Experience in application administration, production support + UAT testing.

Environment: Oracle 11g (SQL, PL/SQL), Informatica 9.5.1, Charles River Development (CRD), Sybase, SQL Server, Control-M, Quality Center, SVN, TOAD, Linux, Erwin

BNY Mellon, NJ Jun 2012 - May 2013

Sr. PL/SQL Developer

Albridge Wealth Reporting

Albridge provides enterprise wealth management services that deliver an accurate, single view of all of their clients' assets. Albridge Wealth Reporting provides a variety of customizable client reports that cover performance, asset allocation, holdings, transactions, benchmarking, cost basis and more.

Responsibilities:

Experience in writing, reviewing PL/SQL stored procedures (procedures, functions, packages, triggers, views, MVs and other database objects).

Extensively worked with export, import, expdp and impdp utilities.

Experience in providing data size estimations to DBA team for data migrations various client staging environments.

Used Views, Materialized Views, Cursors, REF Cursors, Collections, Exception handling, Bulking Techniques.

Experience in migration of database objects and data into different environments.

Environment: Oracle 11g (SQL, PL/SQL), Informatica 9.0.1, Optim, SVN, Autosys, TOAD, UNIX

Bank of America Merrill Lynch, NY Aug 2011 - May 2012

Sr. PL/SQL Developer

Investment Banking - Market Risk Reporting

This project provides an overview of risk management, the classification of the various risk encountered and the steps involved in building a risk management strategy. This project explores how to identifying risk, quantifying it, and developing an appropriate strategy to manage it.

Responsibilities:

Experience in writing and reviewing PL/SQL stored procedures( Triggers, Procedures, Functions and Packages)

Experience in reviewing and tuning oracle stored procedures and oracle partitions.

Experience in VaR analysis, DeaR for different kinds of risks – market risk, credit risk.

Environment: SQL, PL/SQL, Informatica 9.0.1, Netezza6.0, CVS, Autosys, Eclipse, UNIX

Time Warner Cable, Charlotte, NC Jul 2010 - Aug 2011

Sr. PL/SQL Developer

Billing System Events (BSE): Time Warner Cable uses different billing systems – ICOM, CSG depending on the region to bill for different services of TWC.

CVC (Customer Value Creation) and Hawaii Integration: TWC uses Oceanic billing system in Hawaii division. Oceanic billing system is integrated with customer value creation enterprise module, to synchronize and track Hawaii customer data and product data at enterprise level.

Responsibilities:

Created DDL scripts (partitioned tables, indexes, materialized views and others).

Experience in creating validation strategy, validation plans and validation scripts to validate different events.

Experience in analyze customer data to understand customer behavior, preferences and trends.

Environment: SQL, PL/SQL, Informatica, Netezza, Autosys, TOAD, UNIX, Informatica, Cognos

State Of Tennessee -Health Dept., Nashville, TN Mar 2009 - Jul 2010

Sr. PL/SQL Developer / DBA

Provider Claim processing application (PCP): The system is used by around 6000 providers from Tennessee to submit healthcare claims for mentally challenged 1300 service recipients from across the Tennessee.

July Mandate: The system is used by the Central Office’s Denied Claims Group. The web-based system facilitates search of denied claims coming back from TennCare.

COSMOS Application: COSMOS stands for Client Oriented Survey Management Operating System.

Responsibilities:

Experience in PL/SQL Procedures, Functions and Packages using PL/SQL to implement business rules which will create cost plans, keep track of providers billing, claims submitted to TennCare.

Experience in maintaining HIPAA compliance guidelines for all database related information.

Environment: SQL, PL/SQL, TOAD, Informatica6.5, SQL*Loader, UNIX, Erwin, Crystal Reports

Nissan North America Inc., Nashville, TN Sep 2006 - Feb 2009

Sr. PL/SQL Developer/On-Site Lead

NNA Finance Application: NNA RDW, GDW Hyperion Finance Application for doing budget, forecast based on the actual expenses of Nissan North America.

Responsibilities:

Experience in preparing and reviewing detailed design documents

Experience in 24*7 support for this application and Co-Ordination with Off-shore teams.

Environment: Oracle9i (SQL, PL/SQL), Informatica, Hyperion Essbase, Planning DB2 and UNIX.

Merrill Lynch, NY Aug 2003 - May 2006

Sr. Developer/Lead

Travel Entertainment Accounts Maintenance (TEAM): TEAM is a system available for usage by the appropriate cost centers of the client. The client has a well-defined procedure through which it is possible for the members of particular cost centers to apply for AMEX cards.

Responsibilities:

Responsible for writing PL/SQL stored procedures.

Environment: Oracle9i (SQL, PL/SQL), ASP.NET, XML, VB.NET, VSS, TOAD

Vision Compass Inc., Seattle, WA Nov 2002 - Jul 2003

Technical Consultant

Vision Compass is collaborative enterprise management software system that implements, manages and delivers on the organizations business objectives.

Responsibilities:

Involved in implementation Enterprise Data Connectivity Part (EDC) which will enable the product connectivity and application integration capabilities to different databases.

Environment: Oracle9i (SQL, PL/SQL), VB.NET, ASP.NET, Windows

Group Systems Inc., India May 2001 - Oct 2002

Developer

Group Systems Workgroup Edition is the powerful and innovative electronic meeting support software that can cut meeting time while improving the quality of your meetings.

Responsibilities:

Prepared detailed Understanding documents from the given application, functional specs and interacting with the client.

Environment: SQL, PL/SQL, IIS4.0, ASP.NET, VB.NET, NT server 4.0

EnMed Inc., India Jun 2000 - Apr 2001

Developer

Customer Care Billing System -CC & B: The billing solution for EnMed is designed as a settlement solution for small to medium Clinical Trail Customer where the services are provided.

Responsibilities:

Experience in writing PL/SQL stored procedures

Environment: SQL, PL/SQL, Crystal Reports, VB6.0, ASP2.0, IIS4.0 and NT server



Contact this candidate