Objective

A challenging position in Information Technology where I can use my knowledge and experience.

Primary Skills

Business Objects

Crystal Reports XI

Data Migration/Validation/Cleaning/Mapping

DTS packages ETL

Hyperion

Microsoft Access 97 thru 2010, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Outlook, Visio Microsoft Project

Microsoft Access Reports

MicroStrategy

Oracle Database PL/SQL

SAS

SQL Server T-SQL

SSRS VB.NET .NET 3.0, 3.5, 4.0, and 4.5 VBA, Visual Basic 5, 6 Windows platforms Windows 2000/XP/Windows7 XML Work Experience Confidenital Sr. Programmer Analyst Contract Assignment

• Work flow automation by converting manual processes to software agents using VB.net, SQL Server, MS Access, MS Excel, and Crystal reports.
• VB.NET Visual Basic for application: Designing and coding custom interfaces using Visual Basic for Application's
• Stored procedures: Writing stored procedures using PL/SQL for database interface as well as triggers
• T-SQL: Using SQL Server queries for data validation
• SQL Server: Creating Tables, views, and stored procedures
• MS Access: Using Access 2003/2007 in creating custom databases tables, queries, forms, reports, macros and VBA modules and converting databases from 2003 to 2007
• Crystal Reports: Using Crystal Reports XI in creating custom reports Reports, Sub reports, and Graphs
• MS Excel: Using MS Excel in creating custom reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the database

Confidenital Sr. Programmer Analyst Contract Assignment

• VB.NET Visual Basic for application: Designing and coding custom interfaces using Visual Basic for Application
• Stored procedures: Writing stored procedures using PL/SQL for database interface as well as triggers
• T-SQL: Using SQL Server queries for data validation
• SQL Server: Creating Tables, views, and stored procedures
• MS Access: Using Access 2003/2007 in creating custom databases tables, queries, forms, reports, macros and VBA modules and converting databases from 2003 to 2007
• Crystal Reports: Using Crystal Reports XI in creating custom reports Reports, Sub reports, and Graphs
• MS Excel: Using MS Excel in creating custom reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the database

Confidenital

Sr. Business System Analyst Contract Assignment

• Providing comprehensive technical support for mission critical financial data housed in MS Access, MS Excel, Brio, Hyperion , SQL Developer, and SAS
• Develop requirements documents, implementation plans, issue lists, status reports and other written documents in accordance with the recommended methodology
• Configuring secured connection from MS Access, MS Excel, Brio, Hyperion SQL Developer, and SAS to backend Oracle databases
• PL/SQL: Using Oracle queries for data validation
• Crystal Reports: Using Crystal Reports XI in creating custom reports Reports, Sub reports, and Graphs
• MS Excel: Using MS Excel in creating custom reports forms, macros and VBA modules , aimed at task automation and data presentation
• MS Excel: Using MS Excel in creating custom reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• Requirement Gathering: Working with different department to gather information for report writing, database development, and application development to meet management and Business requirements.
• Hyperion: Using Hyperion in creating custom reports Reports, Sub reports, and Graphs
• One-on-one user support and training
• Working in conjunction with Business Analysts in capacity of Assistant Project Manager and,
• Interacting with Oracle databases ad-hoc queries
• Liaison between Business users and EDW Team: Translate business requirements to technical requirements
• Support, manage, and coordinate EDW Team

Confidenital

Sr. Application Developer Contract Assignment

• Design and development of database schemas and database interfaces aimed at workflow automation and information gathering. Project included:MS Access: Using Access 2003/2007 in creating custom databases tables, queries, forms, reports, macros and VBA modules and converting databases from 2003 to 2007
• SQL Server: Designing a Corrective Action and risk assessment databases tables, views, stored procedures triggers using SQL Server 2008
• VB.NET: Designing and coding a database interface for the risk management database
• Stored procedures: Writing stored procedures using T-SQL for database interface as well as triggers
• T-SQL: Using SQL Server queries for data validation
• Crystal Reports: Using Crystal Reports XI in creating custom reports Reports, Sub reports, and Graphs
• MS Excel: Using MS Excel in creating custom reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• Database segmentation front-end/back-end in order to provide limited secure interface to various user groups based on a need-to-know policy
• User Manuals: Writing User manuals and training users for the applications that I have developed or enhanced
• Documentation: Writing documents for system enhancements and,Requirement Gathering: Working with different department to gather information for report writing, database development, and application development to meet management and Business requirements.

Confidenital Sr. Database Programmer/Application Developer Contract Assignment

• Design and development of database schemas and database interfaces aimed at workflow automation and information gathering. Project included:
• Crystal Reports: Using Crystal Reports XI in creating custom reports Reports, Sub reports, and Graphs
• SAP Business Objects Enterprise: Utilizing Business Objects InfoView Tool for Reporting, Scheduling, and Customization
• QL Server: Designing a risk assessment database tables, schemas, views, stored procedures triggers using SQL Server 2008
• VB.NET: Designing and coding a database interface for the risk management database
• XML: Used within VB.NET C applications for data export/import tasks
• Stored procedures: Writing stored procedures using T-SQL for database interface as well as triggers
• T-SQL: Using SQL Server queries for data validation
• Business Rules Engine: Using business rule engine within their in-house software to change rules according to FDIC policy and their business requirements
• MS Access: Using Access 2003/2007 in creating custom databases tables, queries, forms, reports, macros and VBA modules and converting databases from 2003 to 2007
• MS Excel: Using MS Excel in creating custom reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• SSRS: Creating reports using SQL server reporting services in creating custom reports and graphs
• Database segmentation front-end/back-end in order to provide limited secure interface to various user groups based on a need-to-know policy
• User Manuals: Writing User manuals and training users for the applications that I have developed or enhanced
• Documentation: Writing documents for system enhancements and,
• Requirement Gathering: Working with different department to gather information for report writing, database development, and application development to meet management and Business requirements.

Confidenital Sr. Database Developer/Analyst Contract On-Call Assignment

• Design and development of databases used in conversion of data from legacy systems to newer technology while enhancing data accuracy and upgrading user interface. Project included:VB.NET Visual Basic for application: Designing and coding custom interfaces using Visual Basic for Application
• XML: Used within VB.NET C applications for data export
• Stored procedures: Writing stored procedures using PL/SQL for database interface as well as triggers
• PL/SQL: Using Oracle queries for data validation
• T-SQL: Using SQL Server queries for data validation
• SQL Server: Creating Tables, views, and stored procedures
• MS Access: Using Access 2003/2007 in creating custom databases tables, queries, forms, reports, macros and VBA modules and converting databases from 2003 to 2007
• MS Excel: Using MS Excel in creating custom reports forms, macros and VBA modules , aimed at task automation and data presentation
• HTML: Developed VBA modules to automate generation of Access Reports similar to Crystal Reports and to export the output into HTML format for FTP transfer to external Websites
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the database
• Crystal Reports/Business Object: Using Crystal Reports XI and Business Object 5.0 in creating custom reports Reports, Sub reports, and Graphs
• Database segmentation front-end/back-end in order to provide limited secure interface to various user groups based on a need-to-know policy
• Schedule Automation: Schedule the database to execute everyday on a specific time to process data and send emails
• User Manuals: Writing User manuals and training users for the databases that I have developed
• Documentation: Writing documents for system enhancements
• equirement Gathering: Working with different department to gather information for report writing, database development, and application development to meet management and Business requirements
• DOS Commands: Using DOS Commands for file and folder operations as well as scheduling tasks and,
• Novell GroupWise: Using Novell group Wise for day to day emailing.

Confidenital Title:Sr. Report Writer Contract Assignment

• Duties: Design and development automated reports including
• Crystal Reports/Business Objects: Using Crystal Reports XI and Business Objects 5.0 in creating custom reports Reports, Sub reports, and Graphs
• MS Excel: Using MS Excel 2000/2003 in creating custom Reports forms, macros and VBA modules , aimed at task automation and data presentation
• Crystal Reports/Business Objects: Creating report parameters and writing formulas, etc
• SSRS: Creating reports using SQL server reporting services in creating custom reports and graphs
• Stored Procedures: Writing stored procedures using PL/SQL for database interface as well as triggers
• PL/SQL: Using SQL queries for data validation
• T-SQL: Using SQL Server queries for data validation
• Requirement Gathering: Working with different department to gather information for report writing to meet management and Business requirements
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the database
• Data mapping: Connecting data between Crystal Reports and back-end databases Oracle using ODBC and,
• Lotus Notes: Using Lotus Notes 6.0 for day-to-day emailing use.

Confidenital

Title:Sr. Report Writer Contract Assignment

• Duties:Design and development automated reports including

• Crystal Reports: Using Crystal Reports XI to create custom reports Reports, Sub reports, and Graphs as well as developing report parameters and writing formulas, etc
• Universe: Design and Develop universe based on business model provided by the clients
• TFS Software: Part of Visual Studio to write documents and organize document management
• Stored Procedures: Writing stored procedures using T-SQL for database interface as well as triggers
• T-SQL: Using SQL Server queries for data validation
• Requirement Gathering: Working with different department to gather information for report writing to meet management and Business requirements
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the database
• Data mapping: Connect data between Crystal Reports and back-end databases Oracle, and SQL Server using ODBC.

Confidenital Sr. Database Developer Contract Assignment

• Duties:Using MS Access and Excel to modify and enhance the company's Disaster Recovery database, including
• MS Access: Using Access 2003 in creating custom databases tables, queries, forms, reports, macros and VBA modules
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA
• MS Excel: Using MS Excel 2000/2003 in creating custom Reports forms, macros and VBA modules , aimed at task automation and data presentation
• VB.NET: Designing and coding custom interfaces using under .NET 3.0/3.5
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the databaseDatabase segmentation front-end/back-end in order to provide limited secure interface to various user groups based on a need-to-know policy
• User Manuals: Writing User manuals and training users on the newly developed database interfaces
• Documentation: Writing documents for system enhancements and,
• Requirement Gathering: gather information for report writing to meet management and Business requirements.

Sr. Business System Analyst/Database Developer Contract Assignment Duties:Using a variety of technologies to support private mortgage Residential loan origination, and loan approval process, including

• SQL Server: Creating Tables, views, and stored procedures
• MS Access: Using Access 2003 in creating custom databases tables, queries, forms, reports, macros and VBA modules
• MS Excel: Using MS Excel 2000/2003 in creating custom Reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA and SQL
• Data Warehousing: Using complex SQL queries OLAP for data mining
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the database
• Data mapping: Import/export data between Access and backend databases Oracle, and SQL Server using ODBC and direct link
• Data Reporting: Report creation using Business Objects WEBi reports
• MS Excel: Developing complex summary reports which were dispatched to subscribed users through email or hard copy
• Acted as technical Liaison between Users and offshore developers
• User Manual: Writing User manuals and training users for the databases that I have developed
• Visio: Creating E-Relationship Diagram using Visio
• Documentation: Writing documents for system enhancements
• Support: Support existing application for lead Loading
• Requirement Gathering: Working with different department to gather information for report writing to meet management and Business requirements
• Reporting Tools: Using Business Object and Crystal Reports to create Reports and Graphs and,
• DOS Command: Using Dos Commands for file and folder operations as well as scheduling tasks.

Confidential Sr. Analyst/Database Developer Contract Assignment

• Duties:Using a variety of technologies to support private mortgage Residential loan approval process, including
• SQL Server: Creating Tables, views, and stored procedures
• MS Access: Using Access 2000/2003 in creating custom databases tables, queries, forms, macros and VBA modules MS Excel: Using MS Excel 2000/2003 in creating custom Reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA and SQL
• Data Warehousing: Using complex SQL queries OLAP for data mining
• Visual Basic: Designing and coding custom interfaces using Visual Basic for Applications VBA
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• Data mapping: Import/export data between Access and backend databases Oracle, and SQL Server using ODBC and direct link
• Requirement Gathering: Gather information for report writing to meet management and Business requirements
• User Manual: Writing User manuals and training users for the databases that I have developed and,
• Visio: Creating E-Relationship Diagram using Visio.

Sr. Analyst/Database Developer

• Duties:Using a variety of technologies and practicing a wide range of IT-related tasks to support commercial loan approval and origination functions. These technologies and tasks include
• Visual Basic: Designing and coding custom interfaces using Visual Basic aimed at database interfaces, report specification front end as well as customized tools such as commission calculators, lead categorization using in-house rules
• SQL Server: Creating Tables, views, and stored procedures as the backend database source to the VB application front-end
• MS Access: Using Access 97/2000 in creating custom databases tables, queries, forms, macros and VBA modules
• Convert MS Access: Conversion of MS Access from 97 to 2000
• MS Access: Design and creation of custom recurring reports and Ad hoc reports to meet continuously changing requirements by top management
• MS Excel: Using Excel 97/2000 in creating custom Reports forms, macros and VBA modules , aimed at task automation and data presentation
• Marketing: Creation of custom queries ad hoc reports aimed at scoring existing bank customers in order to generate leads for new product offers
• Assisting users with Microsoft Office programs i.e., Word, Excel, PowerPoint, Access, etc.
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VB and SQL
• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• Data mapping: Import/export data between Access and backend databases Oracle, SQL Server and remote Intranet-based Access databases using ODBC and direct link
• Data mapping: Creating customized mail merges using Word and Access
• MS Excel: Developing complex in cell formulas for client qualification process
• Marketing: Serving as a technical liaison in product marketing campaigns
• Administering generation and publication of Monthly reports to users using the company's intranet
• Business Knowledge: Using my business knowledge and at the same time learning more to develop new programs and databases inorder to be more efficient and to perform tasks in a more timely manner
• Suggestions: Providing on-demand recommendations to the management aimed at identifying ways to perform tasks more efficiently by taking advantage of existing technologies
• Administrating generation and publication of Monthly reports to 100 users using the company's intranet
• Security Task: Implementation of group files to enforce database login using userID/password combinations
• Database encryption
• DTS packages ETL for data mapping import/export data between databases , data migration converting flat files to pipe-delimited or CSV text files , data cleaning data row consolidation and/or data validation matching data types with fields within tables in the database
• Implementation of permissions on folders where Access databases were located in order to protect the physical files from unauthorized access
• Database segmentation front-end/back-end in order to provide limited secure interface to various user groups based on a need-to-know policy
• Requirement Gathering: Working with different department to gather information for report writing to meet management and Business requirements
• User Manual: Writing User manuals and training users for the databases that I have developed
• Visio: Creating E-Relationship Diagram using Visio and,
• Domino Lotus Notes: Using Lotus Notes 6.0 for day to day emailing use.

Business System Analyst/Programmer contract assignment

• Duties:Using a variety of technologies to support private mortgage commercial loan approval process, including
• MS Access: Using Access 97/2000 in creating custom databases tables, queries, forms, macros and VBA modules

• MS Access: Creating Ad hoc reports
• MS Excel: Using MS Excel 2000/2002 in creating custom Reports forms, macros and VBA modules , aimed at task automation and data presentation
• Data manipulation: Data filtering, reformatting, merging and validation using Access, VBA and SQL

• Data manipulation: Mapping fields in one table to another within same database using data aggregation, left, right, inner and outer joins
• Data mapping: Import/export data between Access and backend databases Oracle, SQL Server and remote Intranet-based Access databases using ODBC and direct link
• Assisting users with Microsoft Office programs i.e., Word, Excel, PowerPoint, Access, etc.
• MS Excel: Developing complex in cell formulas for mortgage qualification process and,
• MS Excel: Using Excel 97/2000 in creating custom Reports forms, macros and VBA modules , aimed at task automation and data presentation.