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

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

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

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

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

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

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

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

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

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

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