SUMMARY:

• 10 years of industry experience in the analysis, design, development, testing, implementation and maintenance of software applications in the prime brokerage, equities applications.
• 6 years experience in Goldman Sachs as a Database Architect, database lead and a developer.
• Built strategic and robust systems to automate the existing manual processes.
• Held responsibility for maintaining databases for about 16 Client Facing applications
• Good experience with database modeling tools like Infospere Data Architect, Erwin and in gathering business requirements, code reviews, release management and volume testing.
• Extensive experience in Performance Tuning and Query Optimization
• Coordinated with DBAs, in rolling out database instrumentation and monitoring tools.
• Conducted presentations about Database best practices
• Did Capacity planning, database infrastructure planning and project planning
• Worked in BCP and worked in rectifying Confidential violations
• Responsible for replacing manual builds with automated build and release procedures.
• Experienced back - office programmer in developing Batch process using PERL/DBI/DBD, Unix Shell Scripts and has knowledge of Java, MS Access, Business Objects and Tableau.
• Created autosys and ActiveBatch jobs for scheduling data load jobs.
• Experienced in handling financial data and performing analysis and discussions with different teams to reuse existing infrastructure components.
• Worked in production support extensively in stabilizing many old applications

TECHNICAL EXPERTISE

LANGUAGES: Perl, TSQL, C, C++, UNIX Shell (KSH), AWK, SED

RDBMS: Sybase 11.x/12.x, MS Access 2000, Sql Server 2012/2016, SSIS, SSRS

OPERATING: Sun Solaris 2.x, HP UNIX, Windows NT/2000, Red

SYSTEMS: Hat Linux, UNIX System V

MISCELLANEOUS: CGI, DBI/DBD, Java, HTML, JavaScript, Apache Web Server, CRON TAB, BCP, ISQL,SCCS, CVS, SWIFT, CRYSTAL REPORTS, BUSINESS OBJECTS, AUTOSYS, SOURCE FORGE, Python, C#,TABLEAU

PROFESSIONAL EXPERIENCE:

Confidential, NY

Senior Developer

Technology: Python, KSH, TSQL, SQL Server 2012, SSIS, SSRS, C#, Tableau Reports, Business Objects, UNIX, ActiveBatch, SVN

Responsibilities:

• Involved in creating complex stored procedures which were used to request and update Market Data received from Bloomberg.
• Designed SSIS Packages to transfer data from flat files to SQL Server from various Counterparties.
• Used SentryOne, Execution Plan, SQL Profiler and perfmon to optimize queries and enhance the performance of databases.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS in (SQL Server Database Tools) SSDT
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data Confidential warehouse.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created Tableau Dashboard which shows the business users Market data availability, priorities and SLAs for various tickers.

Confidential, NY

Senior Developer/Project lead

Technology: Perl, KSH, TSQL, Sybase 15, Java, BCP, CGI, Apache, XML, Kdb, JSP, Business Objects, Unix, AUTOSYS, Perforce, SSIS

Responsibilities:

• Built strategic systems as part of the regulatory requirements to streamline netting requirements and delivered financial reports like FIN41, Dodd Frank and Enhanced Balance Sheet Netting reports.
• Gathered business requirements, performed analysis, code reviews, testing, release management, pre and post checkout procedures.
• Managed all phases of the software development lifecycle (SDLC) for multiple projects and monitored progress to meet deadlines.
• Implemented interfaces using Perl to load trade level positions, notionals, mark-to-market values, counterparty and collateral data for different asset types like EQ-OTC, FX, IR-OTC, Mortgage Backed Securities, commodities, PB, Listed derivatives, etc from upstream data providers.
• Created data models for storing positions, counterparty, collateral, product, trade and netting data for multiple asset types and implemented batch processing in Confidential which serves as the data warehouse for generating critical financial reports.
• Created Perl and shell scripts for validating, data massaging, transforming and loading data into data warehouse.
• Implemented interfaces which are independent of data source/destinations using Java and kdb and thus created a common platform to integrate with primary data providers.
• Created stored procedures containing complex business and aggregation logic.
• Created Perl and Shell scripts to provide feeds to downstream systems.
• Worked on Balance Sheet netting project using SOAP and Spring batch framework to generate daily and month end reports.
• Built a rolling 6 month data repository and a Business Object Reporting interface for effective reporting for Dodd Frank project.
• Played a key role in reviewing data gap analysis for the OTC derivatives data while integrating with RACE platform to create Balance Sheet Netting reports and worked with business community to resolve various data quality issues.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data Confidential from different up streams.
• Worked closely with business users in providing services and solutions aligned with regulatory requirements.
• Worked rigorously in performance tuning, finding best optimal paths and optimizing the processes.
• Worked in making the applications train compliant as per firm’s standards.
• Created automated workflow process to ensure only designated business users can access critical data.
• Created business objects reports for generating financial reports to users
• Created design documents for generating netting reports as part of firm’s strategic view.
• Supervised BOXI R3 to R4 report migration.
• Defined and maintained the use of internal tools to track project issues and progress.

Confidential, Stamford, Connecticut

Database Architect & Senior Developer

Technology: Perl, KSH, TSQL, Sybase 15, Java, DBI/DBD, BCP, CGI, Apache, HTML, JSP, Solaris 2.x, Windows 2000, AUTOSYS, SOURCE FORGE,SSIS

Responsibilities:

• Worked as a database architect and database lead and was created database design, data modeling.
• Created stored procedures which contain the complex business logic of calculating Volcker mappings.
• Gathered business requirements, analysis, code reviews, testing, release management, pre and post checkout procedures.
• Gathered infrastructure requirements, worked in database set-ups and volume testing.
• Worked in performance tuning, finding best optimal paths and taking backups and restoring data
• Created Perl/shell scripts for data massaging, data archiving, etc
• Identified areas of discrepancies and created proper error handling mechanism
• Created scripts to load the data, run sanity checks, and capture the stats.
• Used autosys for scheduling data archiving jobs and for scheduling jobs that load the data from upstream.
• Worked in production support.

Confidential, Jersey City, NJ

Database Architect & Senior Developer

Technology: Perl, KSH, TSQL, Sybase 12.5, Java, DBI/DBD, BCP, CGI, Apache, HTML, JavaScript, Solaris 2.x, Windows 2000, AUTOSYS, SOURCE FORGE,SSIS

Responsibilities:

• Worked as a database architect and database lead and created database design, data modeling.
• Created stored procedures which contain the complex business logic of calculating client contract accruals.
• Redesigned the old Confidential system to achieve a more stable and scalable system, with a potential to add new enhancements with minimal effort
• Gathered business requirements, performed analysis, code reviews, testing, release management, pre and post checkout procedures.
• Monitored data server health and rectified acess violations
• Worked in gathering infrastructure requirements, database set-ups and volume testing.
• Extensively worked in performance tuning, finding best optimal paths and taking backups and restoring data
• Created tables, complex stored procedures, triggers, audit trails etc.
• Created Perl/shell scripts for data massaging, data archiving, etc
• Identified areas of discrepancies and created proper error handling mechanism
• Created scripts to load the data, run sanity checks, and capture the stats.
• Used autosys for scheduling data archiving jobs and for scheduling jobs that load the data from upstreams.
• Worked in prod support for stabilizing prod systems, i.e. bringing down the CPUs from 100% to 20%, decreasing the time required by load jobs, decreasing the response time for time sensitive queries
• Experience in data warehousing concepts and ETL tools.

Confidential, Jersey City, NJ

Database Architect & Senior Developer

Technology: Perl, KSH, TSQL, Sybase 12.5, DB2, Java, DBI/DBD, BCP, CGI, Apache, HTML, JavaScript, Solaris 2.x, Windows 2000, AUTOSYS, SOURCE FORGE

Responsibilities:

• Worked as a database architect and database lead and was created database design, data modeling.
• Worked in creating the complex hierarchy of the payment approval workflow.
• Redesigned the old Payment system to achieve a more stable and scalable system, with a potential to add new enhancements with minimal effort
• Designed a smart loading mechanism for loading the critical client data.
• Gathered business requirements, performed analysis, code reviews, testing, release management, pre and post checkout procedures.
• Monitored data server health using tools like iwatch and rectified Confidential violations
• Gathered infrastructure requirements, worked in database set-ups and volume testing.
• Extensively worked in performance tuning, finding best optimal paths and taking backups and restoring data
• Created tables, complex stored procedures, triggers, audit trails etc.
• Created Perl/shell scripts for data massaging, data archiving, sending notifications, etc
• Created automated scripts for on-boarding existing clients on to the new Web Payment Flow.
• Identified areas of discrepancies and created proper error handling mechanism
• Gathered requirements from prod dev, created data models, Visio diagrams, analyzed and documented the workflow and processes involved and coordinated with different data up streams to ensure a smooth flow.
• Created scripts to load the data, send client notifications, run sanity checks, send usage stats and client sensitive data.
• Used autosys for scheduling data archiving jobs and for scheduling jobs that load the data from up streams.
• Performed prod support for stabilizing prod systems, i.e. bringing down the CPUs from 100% to 20%, decreasing the time required by load jobs, decreasing the response time for time sensitive queries
• Created user set-ups and client rollout

Confidential, Jersey City, NJ

Sybase Administrator/PERL/Shell Programmer

TECHNOLOGY: Perl, KSH, TSQL, Sybase 12.5, DBI/DBD, BCP, CGI, Apache, HTML, JavaScript, Solaris 2.x, Windows 2000, AUTOSYS, SSIS.

Responsibilities:

• Developed many Sybase tables, Stored Procedures and Triggers.
• Created cursors for row-by-row access of the data to perform some data comparisons.
• Worked in performance tuning of the database using indexes.
• Documented test cases and results.
• Worked extensively in TSQL queries.
• Designed and developed many PERL modules.
• Created many PERL/KSH scripts for data handling.
• Performed unit and system testing.
• Created PERL scripts for testing batches, stored procedures etc.
• Developed many TSQL batches using PERL/KSH.
• Worked in Sybase query tuning.
• Worked in Contacts module for design and development.
• Created many front-end reports using HTML.
• Worked in designing and development of Products module.
• Worked with ETL tools like SSIS.
• Supported clients based on browser.
• Developed the PERL Scripts to support front- end reports.
• Worked in many Perl, KSH scripts for the application.
• Created autosys jobs for scheduling nightly feeds.
• Extensively worked with Transact SQL for the backend.
• Created many test cases and performed testing.
• Worked with design team for design documentation.