Senior Developer, Regulatory Resume

TECHNICAL SKILLS

Languages: Java, PowerBuilder, C, Python, Perl

Platforms: Unix, Microsoft, Macintosh

Databases: Oracle, Microsoft SQL Server, Hive HQL, Essbase

Tools: Crystal Reports, Rapid SQL, SED, AWK

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer, Regulatory

Responsibilities:

Served as part of team that migrated 100+ applications from Oracle based system to Hive (Cloud) - based system in record 17 months (1 month ahead of schedule), helping company in huge cost savings.
Discussed requirements from users, developing designs, documenting, and submitting to users for approval.
Created Oracle scripts, functions and packages using PL/SQL, getting, updating, and providing data for various reports, while testing, running, and migrating application to UAT and production.
Wrote Python scripts to handle different expiration dates and frame dynamic SQLs.
Helped QA team in writing SQL scripts to connect target data to source, proving validity of results.
Wrote SQL scripts in Hive Cloud computing language, registering table structures, parameters in framework and coordinating with deployment team to roll out to production.
As-built documents along with Flow Chart of Batch Execution, helping users in understanding flow of data from source to final exception data.
Performance tuned script, improving speed of execution.
Maintained and provided production support for all applications in Regulatory Divisions, warranting users surveillance activity was not hampered.

Confidential, Chicago, IL

Developer / Analyst

Responsibilities:

Created stored procedures in Oracle and SQL Server, updating setup data and providing data for various reports.
Developed programs in Java, accepting data and displaying reports.
Utilized Windows in PowerBuilder, presenting and updating data.
Designed and developed business logic in C#, displaying report data.
Handled Production Migration, providing production support.

Confidential, Chicago, IL

Software Engineer

Responsibilities:

Developed data model by studying existing model.
Created tables and necessary stored procedures and UNIX scripts, converting data from existing application to new ODEN application.
Modified windows in PowerBuilder, suiting needs of users.
Wrote UNIX scripts along with SQL, reconciling data, ensuring all match.
Tested whether code worked well and quality of statements, certifying balances in statements were accurate.
Created ADHOC Reports, using stored procedures and Excel.
Monitored batch jobs, and in case of failure, took necessary action, confirming reports were sent to users on time.

Confidential, Chicago, IL

Software Engineer, Securities, Sales, & Trading Group

Responsibilities:

Wrote Unix and PERL scripts, generating reports.
Used simple KORN-Shell scripts along with SQL, filtering out relevant data and emailing to users.
Framed dynamic SQLs where 1 script did insert, update, delete for multiple tables, helping by using fewer generic scripts to make updates to multiple related tables.
Ran load scripts to load data into database, ensuring monthly data files arrived and DBAs had refreshed database.
Analyzed data, during PWC Audit, which involved studying PERL scripts and explaining differences to users, working on SOX compliant activities.

Confidential, Chicago, IL

Software Engineer

Responsibilities:

Developed data model, after getting inputs from users and further discussion, producing better information.
Designed and created application, using PowerBuilder 8.0 with in-built framework, simplifying application by reducing number of objects.
Created Oracle stored procedures, handling feeds, updates, and reports.
Tested the application, deploying into production without bugs.