SUMMARY:

• Proven track record of successful delivery of new software products, re - engineering and upgrading legacy applications for major financial institutions with superior customer satisfaction through consistent management of tasks.
• Experienced IT professional with expertise in information systems development, ranging from initial analysis and design to systems maintenance and enhancement.
• Proven track record of collaborating with business clients, creating functional specifications and achieving user requirements. Strong knowledge of software development and production application support methodologies.
• Self-motivated, detail oriented and innovative, consistently pursuing new knowledge, can work under pressure and take the initiative to see production issues through resolution.

TECHNICAL SKILLS:

Languages: Shell, Perl, PowerShell, Python, Control-M, AUTOSYS, Java, C/C++, Visual Basic

RDBMS: Sybase System 15.7, Oracle 12c, MS SQL 2005/2008/2012, Big Data Hadoop, Cassandra, MS Access

Data Modeling /ETL: Toad for SAP 3.1, T-SQL, Informatica 9.01, MS SSIS, CA Erwin v.7.3

Operating Systems: Solaris 8/10, Linux SUSE/Red, AIX, HP-UNIX V, Windows 7, XP, 2000, NT

Scheduler Tools: BMC Control-M 7.0, CA Autosys

Other Tools: JIRA Project Tracking, GIT Source Control, MS Visual SourceSafe, Rational Clear Case, BMC Remedy Change Management, FTP/SFTP

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Developer/ Project Leader/Consultant

• Participated in requirement gathering for ChaseConnect and JPMConnect Applications from business team.
• Created, maintained database objects, wrote UNIX scripts and AUTOSYS batch jobs based on the business requirements.
• Improved Applications performance by optimizing stored procedures, tables and indexes.
• Managed the production deployment and post implementation support.
• Monitored, analyzed AUTOSYS batches in QA, UAT, PROD environments for supporting applications.

Technology: Sybase 15.7, Toad for SAP 3.1, UNIX, SA Autosys, Windows 7, Perl, Oracle 12c, Control-M, MS Excel, MS Access

Confidential, New York, NY

IT Regulatory - Senior Analyst/Architect/Consultant

• Conducted interviews with various application managers to collect information and requirements for building Application and Production Support teams for new IHC organization, created and documented functional specifications.
• Performed data analysis, data mapping and modeling for file and message based feeds from and to various internal and external systems: electronic sales, trading desk, options department, operations, portfolio management, international trading and others. Formats included XML and plain text.
• Participated with application managers across IHC, in planning, identification of issues, statistical, and root cause analysis, remediation business cases; managing delivery, risk and issues analysis using available reporting tools.
• Participated in modeling relational data covering conceptual, logical, physical data models and dimensional data models.
• Assisted teams with delivery plans for each intersect and helped to implement Run Books for all data requirements.
• Provides data quality control by running ad-hoc SQL statements for cross-system reconciliation.
• Functioned as team lead, responsible for building, improving, simplifying onboarding processes for different types of employers and consultants at the off shore company locations.
• Formalized off shore resources onboarding process by collecting details, critical patches, and reported bottlenecks.
• Outlined recommendations for hiring managers to follow onboarding process and set time level expectations.
• Contributed to project management: planning/estimates, scheduling, defining scope of work and project deliverables, risk/ issue and dependency management, reporting project progress to business sponsors and stakeholders.

Technology: Oracle 12c, Sybase 15.7, T-SQL, Perl, MS SQL and UNIX/Windows, Control-M, Autosys, MS Excel, MS Visio

Confidential, New York, NY

Senior Developer/ Architect/ Consultant

• Provided data quality control by running ad-hoc SQL statements for cross-system reconciliation.
• Analyzed and migrated more than 450 jobs from Control-M 6.3 to new DTE standards Control-M 7.0.
• Rewrote Control-M embedded code into Windows PowerShell scripts.
• Created, modified, tested database objects (tables, views, packages, stored procedures, functions, trigger) using SQL and PL/SQL; created indexes to tune and optimize transactional database performance
• Architecting complex large database system to provide high availability, recoverability and performance in demanding environment. Implementing ETL solutions using Informatica
• Identified and documented all aspects of the business requirements into system requirements.
• Contributed to the Run Books for each application.

Technology: Oracle 11g, Control-M, PowerShell, UNIX/Windows, Python, Perl, MS SQL 2008, GIT, T-SQL

Confidential, New York, NY

Senior Developer/ Architect/ Consultant

• Reduced monthly Control-M failures from 3770 in July 2013 to 1920 in January 2014 after analysis, optimization and improvements of existing Control-M Batch.
• Actively participated in the development and monitoring more than 3100 real time Control-M daily jobs for Global Calypso application.
• Provided Level 2 and Level 3 support for Global Calypso for organizations located in London, India, Brazil, Hong.
• Provided design and implementation complex ad-hoc data extracts for Business by using SQL query.
• Responded to potential problems by following rules, ensuring the best quality of service at all times.
• Tracked incidents by using a global call logging system until they closed, following best ITIL practices.
• Contributed to the Run Books for each application.

Technology: Calypso, Control-M, UNIX/Windows 7, Perl Scripting, PowerShell, Sybase 15.7, T-SQL, Oracle 11g, MS Access, GIT, FTP/SFTP.

Confidential, New York, NY

Senior Developer/ Project Leader/Consultant

• Wrote ad-hoc SQL statements, and Perl cross-system reconciliation programs to provide data quality control.
• Extracted, analyzed, and modified more than 950 Informatica workflows. Replaced old email entries with new Data Center mail client information. Implementing ETL solutions using Informatica
• Monitored, analyzed, and improved more than 1200 real time Control-M jobs for all new Data Center Hedge Fund Services Applications.
• Migrated existent UNIX cron commands in Control-M jobs for each environment.
• Performed extensive thorough testing and analyzes new Production and Testing Environments for all applications, scripts and programs and Control-M batches.
• Participated in process of migration and testing Geneva application in new Data Center in production and user acceptance testing environments.

Technology: UNIX, Perl Scripting, Control-M, Informatica 9.01, MS SQL 2008, SSIS, Oracle 11g, Sybase 15.1, Windows 7, Autosys, MS Excel, Access

Confidential, New York, NY

Senior Developer/ Project Leader/Consultant

• Designed and executed migration of a UNIX batch and application server from one platform to another; maintaining adequate communication with clients and IT management; acting as liaison between development, project management and other support teams to facilitate timely and standard-driven execution.
• Participated in modeling relational data covering conceptual, logical, physical data models and dimensional data models.
• Took lead role in incident and problem management in the event of production outages until resolution and closure following best ITIL practices.
• Managed migration of database centric batch jobs from end-of-life infrastructure to new strategic platform, thereby consolidating and streamlining Control-M job executions more than 50%.
• Met compliance requirements migrated cron commands to Control-M jobs for each environment.
• Planned, documented and executed migration. Identified and successfully tested key components (FTP, connect direct, secure FTP connections) upon migration completion. Restricted Production access based on audit assessment.
• Pro-actively analyzed recent production issues, identified root causes and implemented preventative measures to increase stability of environment.
• Participated in process of migration PB Data Ware House (DWH) applications from UNIX based, SQL Loader scripts to Informatica based applications.
• Developed tools required for improving the deployment processes and supporting the environments.
• Improved database performance by optimizing stored procedures, tables, and indexes (by reviewing query plans); analyzed error logs and drove issue resolutions to conclusion.

Technology: UNIX Scripting, Oracle 10g, Sybase 12.5, Perl 5.8, UNIX, Control-M, Informatica 8.6, MS SQL2005, SSIS

Confidential, New York, NY

Senior Developer/ Project Leader/Consultant

• As hands-on team lead, followed up the work assignments of all team members to ensure client/user satisfaction and the delivery of enhancements, reports and solutions to the business. Tasks consisted of production support, user support and system enhancements.
• Responsible for database development and system support for handling large scale commodity data.
• Performed hotline support, Incident management, troubleshooting and resolving of production Incidents
• Created Database Model to fully utilize business requirements and improve application performance.
• Optimized stored procedures, tables, and indexes (by reviewing query plans); analyzed error logs and drove issue resolutions to conclusion. Created triggers for keeping strong database referential integrity.
• Implemented feeds for Editorial database from different platform sources, using ETL-based tools.
• Worked as the Database Administrator, scheduling maintenance procedures and making necessary updates.
• Utilized SSIS tools for getting/providing information from/to MS Excel, MS Access.
• Participated in all phases of the software development cycle. Gathered requirements from Quantitative/ Business Analysts, wrote and confirmed specifications, implemented, deployed and supported system components

Technology: MS SQL2005, SSIS, Oracle 11g, Sybase 12.5, Perl 5.8, UNIX/Windows, MS Excel, Visual SourceSafe

Confidential, New York, NY

Senior Developer /Consultant

• Wrote stored procedures, views, triggers, using DDL, DML, DCL, TCL statements, and Perl cross-system reconciliation programs to match data with upstream systems to provide data quality control.
• Participated in all phases of the software development and support cycle. Gathered requirements, wrote and confirmed specifications; implemented and deployed system components. Provided post-release maintenance.
• Provided 24/7 hands-on production and applications support.
• Responsible for database development and system design for handling large scale financial data for the DRCM group.
• Implemented and maintained report distribution module to deliver reports via email as Excel attachments.
• Improved database performance by optimizing stored procedures, tables, and indexes (by reviewing query plans); analyzed error logs and drove issue resolutions to conclusion.
• Designed and implemented complex ad-hoc data extracts for specific business reports in Perl.
• Responsible for developing detailed specifications based on business requirements and testing the ETL application following all ETL standards and architecture.
• Developed a library of reusable modules in Perl, which shortened project implementation timeline.
• Packaged system upgrades for smooth distribution to end-users.
• Understand how the business used and properly supported the applications in their space by being a liaison between development and business teams. Worked to improve quality of the system and its applications.
• Participated in incident and problem management in the event of production outages; owned, tracked and responded to user issues and queries until closure.
• Troubleshot complex issues across multiple application tiers and design/implement solutions to solve technical, performance, and business process flow problems.

Technology: Sybase 12.5, T-SQL, Perl 5.8, UNIX Scripting, AUTOSYS, CT-Lib, MS SQL2005, SSIS, Rational Clear Case

Confidential, New York, NY

Senior Programmer/Analyst

• Organized and supervised the migration of more than 5000 GL batch jobs to Centralize AUTOSYS 4.0 in a short period of time to meet company requirements and policy.
• Ensured application performance, supported batch cycle for production system with over 1500 global users.
• Tuned and optimized database performance by reviewing query plans and creating indexes.
• Worked closely with DBA to configure Sybase server per application requirements. This involved reconfiguring Sun Solaris and Sybase server memory. Certain tables were bounded to cache to improve performance.
• Responsible for Solaris upgrade and Sybase 12.5 migration, using Perl scripts for remapping data.
• Prepared multiple ad-hoc reports by SOLAR reporting tool, helping management with critical variance of budget and actual expense; wrote library of reusable Perl and JAVA data extraction programs.
• Developed a library of reusable modules in JAVA, Perl, to improve turn-around during implementations.
• Assured complete smooth distribution system upgrades to end-users by packaging Sybase DDLs, AUTOSYS scripts.

Technology: Sybase 11.9/12.5, Perl 5.0, UNIX, AUTOSYS, Java beans, JavaScript, HTML, C/C++, CT-Lib, MS SQL

Confidential, New York, NY

Senior Programmer/Analyst

• Assured system’s Y2K compliance and EURO conversion by developing an interface to data stored on Mainframe.
• Implemented migration from SYBASE System 10 to SYBASE System 11.

Technology: Sybase 10/11, UNIX Scripting, C/C++

Confidential, New York, NY

Consultant

• Developed a Central Indicative (CI) Database to collect, organize and repose certain debt and equity information, which is widely used by multiple applications throughout the company. In day-to-day operations ensured database data quality and integrity.

Confidential, New York, NY

Consultant

• Developed Real Time Margin System (RTM) for the clients (Lehman Brothers and Paine Webber), a software that provided the broker/dealer with the ability to identify and limit risk exposure, access and/or monitor on an intra-day basis credit risk and regulatory requirements for Retail and Joint Back Office accounts.