We provide IT Staff Augmentation Services!

Programmer/analyst Resume

SUMMARY:

  • Highly motivated IT professional, with exceptional combination of technical, analytical, business and communication skills. Self - starter.
  • Exceptional Project Management skills. Can work independently or as member of a team.
  • 13 plus years of software development experience with financial services industry
  • 3+ years of hands on development experience with AXIOM Controller View.
  • Hands on experience with building all types of Axiom objects, Datasources, Data Models, Portfolios, Shorthands, Aggregartions, Free Form and Tabular reports.
  • Built the Regulatory Reporting projects, FR Y-14M, FR Y-9C, FR Y-9LP, CCAR , FR 2314/FR 2314S
  • Hands on experience with LINUX/UNIX Shell scripting and Shell commands.
  • Expertise in building the UNIX servers and installing AXIOM . Coordinated and implemented Hardware/Software upgrades between various AXIOM versions.
  • Created Quarterly Projects, Branches and worked on AXIOM enhancements and MRAs.
  • Worked as Developer, Developer Lead, Solution Designer and also as Business Analyst for Finance and Operations Regulatory Reporting.
  • Experience in all phases of Software Development Life Cycle ( Requirement Gathering, Planning, Development, SIT/UAT, User Sign-off, Release Management and Production Support).
  • Great Analytical, Problem solving, Designing and debugging skills of with Risk and Regulatory reports.
  • Excellent Documentation, User skills.
  • Excellent communication skills. Worked with diversified groups leveraging the business and technology skills to communicate effectively with clients.
  • Successfully led all phases of diverse technology projects, aligning business goals with technology solutions to drive process improvements, and bring in efficiency, leading to huge time and cost savings.
  • Excellent Advanced coding skills in MS Excel, MS Access creation of macros, automation of reports, charts, using VBA.
  • Advanced skills with other MS Office tools - MS Access, PowerPoint, SharePoint
  • Excellent Database skills - expertise in design and development of databases using MS Access, SQL Server 7/20xx, Oracle 7.3/8x.
  • Experience in writing SQL statements, PL/SQL, Stored Procedures in SQL Server, Oracle Databases
  • Excellent skills in Data Modeling, Documentation, User .

TECHNOLGY SKILLS:

OS: Linux, Windows

DATABASES: Oracle 7.3 / 8i, SQL Server, Sybase, MS Access

FED REPORTING TOOLS: OBIEE, AXIOM, QlikView

APPLICATIONS: MS Access, MS Excel, PowerPoint, SharePoint, Essbase

INTERNET TECHNOLOGIES: ASP, HTML, IIS, Tomcat, JavaScript, VBScript, Jscript, PHP

PROFESSIONAL EXPERIENCE:

Confidential

Programmer/Analyst

Responsibilities:

  • Created 14M Project and the underlying 3 Branches, FirstLien Mortgages Reports branch, FirstLien Data branch and Address Matching branches using ControllerView 9.6.
  • Created the AXIOM objects - DataSources, DataModels, Portfolio, Shorthand, Aggregation, AXIOM Scripting, Tabular Report and Freeform Reports.
  • Wrote Shell scripts to automate processes.
  • Extensively used Shell commands working with the AXIOM servers.
  • Organized meetings with user groups in preparing and finalizing the functional requirements document.
  • Prepared Technical Specification document on the design, implementation methodology
  • Thoroughly tested about 300 plus edit checks generated by AXIOM ControllerView with BlackKnight logic.
  • Built SQL Server database to capture all upstream data and feed to Axiom
  • Built Excel macro to compare various forms between quarters.

Environment: AXIOM ControllerView 9.6.7, DB2, SQL Server, MS Excel, Shell Scripting, Oracle 8.1, PowerPoint, JIRA

Confidential

Programmer/Analyst

Responsibilities:

  • Built the project and branches in AXIOM 9.6.7 version.
  • Created views in DB2 database and connected them to the Datasources in AXIOM.
  • Used DB2 database for tables. Built SQL Server database to capture/archive upstream data.
  • Involved in design discussions with the Confidential and gathered requirements.
  • Handled the SIT/UAT. Involved in troubleshooting and building appropriate solutions.
  • Prepared documents for user

Environment: AXIOM ControllerView 9.6.7, DB2, SQL Server, MS Excel, Shell Scripting, Oracle 8.1, PowerPoint

Confidential

Programmer/Analyst

Responsibilities:

  • Implemented the Axiom Datasources, Datamodels, built Shorthands, Portfolios and configured MDRMs.
  • Used iterators to run the stress test models for each of the scenarios, Severely Adverse, Adverse and Baseline per the Fed guidelines.
  • Created FACT data for sourcing all the GL data, tables from various databases.
  • Built Aggregations, Freeform and Tabular reports.
  • Involved in System Integration testing and worked with users in UAT phase.
  • Involved in Design discussions, preparation of BRD and FSD.
  • Coordinated test scope and scheduling with business users.
  • Actively ran business meetings and participated in the Analysis of the Fed Reports and data points.
  • Automated Quarterly branch creation for various Fed forms using Shell Scripts
  • Handled refilings by creating branches for the previously filed quarters.
  • Developed run books for use by the AppBank for routine tasks and trouble shooting
  • Implemented and managed the Data Sourcing module which delivers the upstream data
  • Create FACT data for the refiling periods and match the results with previous filings
  • Coordinate with AXIOM on Form onboarding, testing and bug fixes related to various Reg Reports.
  • Implemented JRA for migration of Axiom objects between Dev/UAT and PROD environments.
  • Supported UNIX file management and implemented shell scripting for automating various tasks.

Environment: AXIOM ControllerView 9.6.7, DB2, SQL Server, MS Excel, Shell Scripting, Oracle 8.1, PowerPoint

Confidential

Programmer/Analyst

Responsibilities:

  • The application is developed with Access ADP as the front end and SQL Server as backend.
  • Created detailed functional and technical documentation, on the proposed enhancements/rewrites.
  • Organized meetings with users for making design decisions.
  • Provided timelines on the deliverables, Dev/UAT test schedule and Prod migration.
  • Created test cases and expected results closely working with the users.
  • Built SQL Server database to store data using Sql Server Management studio.
  • Built tables, wrote stored procedures to run complex calculations.
  • Created Access ADP application and built user friendly interface to enter/edit data.
  • Implemented Roles to control who and what content can be accessed by the users on the front end.
  • Implemented detailed audit trails to capture the user activity for every module
  • Generated formatted Excel reports on Plan/Grant/Vesting code wise outstanding, amortization schedules
  • Extensively used VBA for creating Excel macros
  • Provided user and developed user guide manuals
  • Created DTS packages and scheduled Jobs on SQL server for processing the feeds

Environment: Access ADP, SQL Server, Excel, VBA, DTS Package, SSI services, ADO

Confidential

Programmer/Analyst

Responsibilities:

  • Created ADP applications using Access front-end and SQL Server as back end.
  • Provide user-friendly interface. Used forms and sub-forms in Access for easy access to add/edit data
  • Extensively used VBA for coding in Access and Excel, for validations, controlling program flow
  • Used ADSI queries to capture the user information based on the windows authentication.
  • Created Excel applications, macros. Used ADO to connect to the SQL server/Access databases
  • Wrote stored procedures and implemented complex logic for manipulating the data in SQL Server.
  • Created indexes on the tables for optimized performance
  • Created Linked Servers, DTS Packages, Jobs.
  • Created formatted Excel reports and Charts for pictorial representation of the liquidity matrix for senior management.

Environment: Access ADP, SQL Server, Excel, VBA, DTS Package, SSI services, ADO

Confidential

Programmer/Analyst

Responsibilities:

  • Built the Application using ASP, VBScript, IIS, Windows 2008R server
  • Created ADP applications using Access front-end for maintaining look up tables
  • Built database using SQL Server for archiving the prices from Bloomberg and the prices reported into the firm systems.
  • Provide user-friendly web interface for easy access to add/modify and edit data
  • Extensively used VBScript for server-side processing and JavaScript for front-end validations, controlling program flow
  • Created Excel applications, macros for importing data for any comparison reports.
  • Used ADSI queries to capture the user information based on the windows authentication.
  • Used ADO to connect to the SQL server/Access databases.
  • Added Admin/Reporting/Trader roles and responsibilities for accessing data at various levels.
  • Created databases, tables, views, stored procedures in SQL Server.
  • Wrote stored procedures and implemented complex logic for manipulating the data in SQL Server.
  • Created indexes on the tables for optimized performance
  • Created formatted Excel reports for senior management.

Environment: MS Access 2000/2003, SQL Server 7/2000, Excel 200/2003, HTML, ASP, JavaScript

Confidential

Programmer/Analyst

Responsibilities:

  • Built an interactive web application to help HCM to capture the information of mentors and mentees and generate reports on potential matches.
  • Mentors register on the site to offer expertise in their specialty areas and mentees register and chose the areas they want the mentors help them with.
  • Built a complex matching logic using what the mentor can offer vis a vis what the mentees expect from them as input and generated a report that identifies potential matches expressed as a percentage of match.
  • Organized design discussions with the user group.
  • Created documentation on the project. Worked with the users in creating functional specifications.
  • Created technical specification document with detailed screen shots.
  • Used Windows authentication method to capture the user from windows login.
  • Captured the user information querying the Active Directory based on the Kerberos
  • Developed user-friendly Mentee/Mentor web forms JavaScript, ASP, VB Script. Extensively used dropdowns, radio boxes, freeform text boxes to capture information.
  • Built SQL Server to capture and store the information in the backend.
  • Used ADO to connect to the database.
  • VBScript is used for server-side validation and JavaScript for front-end validation.
  • Used Session object to persist data across the pages.
  • Provided Admin interface using MS Access ADP for assigning Champions
  • Generated exception reports.
  • Built user manuals and provided to Champions on using the application.
  • Tested the application across different browsers for compatibility and functional efficiency

Environment: MS Access 2000/2003, SQL Server 7/2000, Excel 200/2003, HTML, ASP, JavaScript

Confidential

Programmer/Analyst

Responsibilities:

  • Downloaded data from upstream systems on T-1 basis into SQL Server database
  • Created a Linked server connecting TAMS, a system which provides additional mapping of Income Function split across various regions.
  • Run scheduled DTS packages to import data on daily basis.
  • Created views to aggregate Account level information at various Income Functions level and Regions
  • Created Excel Macros to generate reports required by the controllers.
  • Extensively used VBA to build business logic. Used Functions, Procedures to control program flow.
  • Used ADODB Recordsets to read data from database. Used ADO to connect to SQL Server
  • Created HTML tables and used Outlook object to create body of the emails and to send out emails to desired user groups.
  • Linked Excel files with tables in the database.
  • Generated reports in Excel format.
  • Used Excel functions, Sort, Filter Functions, Pivot tables, Charts.
  • Handled validations through the Events in VBA .
  • Created Queries, Sub-Queries for retrieval of Data.
  • Used drop down combo boxes, lists in the Forms.
  • Created MIS Reports in Access, Excel.
  • Debugged, Tested and Implemented the Application.
  • Created Modules for common validations and routines.
  • Wrote procedures, functions for various Events.
  • Created Modal and Modeless message boxes for controlling program flow.
  • Created Pivot tables, charts for data analysis
  • Designed Database and built Entity Relations .

Confidential, NY

Programmer/Analyst

Responsibilities:

  • Gathered requirements, created BRD and FSD
  • Created Forms, Tables, Modules, Queries.
  • Handled validations through Events in VBA.
  • Created Queries for Lookup values, RowSources of Forms and for Reports.
  • Used Sub-Forms as part of Main Forms for input and display of data.
  • Created Functions, procedures in Modules.
  • Created Queries to retrieve information.
  • Created Reports for senior management.
  • Used File System Object to log events.
  • Used Transactions for maintaining integrity between data transfers.
  • Created . csv files for generation of Excel sheets.
  • Created Pivot tables from the Excel sheets generated from the application for data analysis.
  • Integrated data from various databases into single large database.
  • Documented the specifications and releases. Created user manuals.

Environment: MS Access 2000, Windows 2000, SQL Server 2000, Citrix, Excel 2000, Oracle 8x

Confidential, Connecticut

Programmer/Analyst

Responsibilities:

  • Participated in meetings with the Business users, third party gateway vendors and involved in documentation.
  • Designed templates of web pages for approval by business.
  • Built custom COM components using Visual Basic to encapsulate business logic.
  • Used KANA, an email engine, for queueing the emails received and sent.
  • Built interactive Active Server Pages using IIS on Windows servers.
  • Extensively used HTML, VB Script for server validations and interfacing with the Confidential business objects.
  • Used JavaScript for client side validations.
  • Interacted with Database teams for efficient database design.
  • Connected to Oracle database via OLEDB for data storage and retrieval.
  • Used Style Sheets (CSS) for maintaining consistent look and feel of the fonts, sizes and colors across the pages.
  • Provided roles, permissions and audit trail for control purposes.
  • Extensively used views, SQL queries for data retrieval. Created stored procedures for complicated business logic.
  • Created extensive web based reports on the requests received, demographics of the applicants
  • Used MSMQ for queueing the web requests so all the requests are properly accounted for in the database.

Environment: ASP, VB Script, JavaScript, Windows 2000, SQL Server 2000, Citrix, Excel 2000, Oracle 7.3, MSMQ, IIS, Visual Basic, COM

Confidential, Connecticut

Programmer/Analyst

Responsibilities:

  • Organized meetings for Analysis of current state.
  • Worked closely with the Business users and documented the requirements.
  • Created images, templates of web pages for business approvals so the development can start
  • Managed a team of two developers for creating interactive web pages.
  • Extensively used ASP, HTML, VB Script for server validations and interfacing with the Confidential business objects.
  • Used JavaScript for client side validations
  • Connected to Oracle database via OLEDB for data storage and retrieval.
  • Used Style Sheets (CSS) for maintaining consistent look and feel of the fonts, sizes and colors across the pages.
  • Provided roles, permissions and audit trail for control purposes.
  • Extensively used views, SQL queries for data retrieval. Created stored procedures for complicated business logic.
  • Created extensive web based reports on the requests received, demographics of the applicants
  • Used MSMQ for queueing the web requests so all the requests are properly accounted for in the database.
  • Created DLLs for encapsulating business logic.

Environment: ASP, VB Script, JavaScript, Windows 2000, SQL Server 2000, Citrix, Excel 2000, Oracle 7.3, MSMQ, IIS, Visual Basic, COM

Hire Now