Skills

Work History

Confidential

• Worked on initial design and functional requirements phase.
• Clarified requirements, business needs and project objectives,
• via feedback sessions and client meetings, in collaboration with stakeholders.
• Created tables, data-modeling, queries, forms and reports.
• Created/provided automation coding for various tasks in MS-Access.
• Create several detailed and drill down Reports.
• Also worked with MS-Excel spreadsheet. Data was imported into MS-Access database tables.
• Created queries and Reports including graphical representation of data.
• Utilized Advanced Excel skills pivot tables, graphs, vlookup in working with Excel.

Environment: SQL Server, MS-Access, MS-Excel, MS-Office Suite.

Confidential

• Consultant thru Spectra-Force Technologies
• Worked with the Human Resources database.
• Reviewed and understood the requirements for development.
• Downloaded large data sets from SAP database into MS-Excel spreadsheet. This data was then imported into MS-Access database tables, created queries and Reports including graphical representation of data.
• Utilized Advanced Excel skills pivot tables, graphs, vlookup, if statements in working with Excel.

Environment: MS Access 2007/VBA , MS-Excel 2007, SAP database.

Confidential

MS Access Developer

• Developed MS Access databases for various usages.
• Performed upgrade from Access 2007 to 2010.
• Reviewed and understood requirements for software development.
• Performed work during initial design and functional requirements phase.
• Clarified client requirements, business needs and project objectives through feedback sessions and client meetings, in collaboration with all stakeholders.
• Captured requirements and developed design document.
• Performed data collection, analysis and interpretation, provided data management, and created reports.
• Designed and imitated project, and designed, analyzed, and tested system.
• Created tables, data modeling, queries, forms and reports.
• Created switchboard with various detailed and drill down reports.

Environment: MS Access 2007/2010

Confidential

MS Access Developer / Analyst

• Utilized human resources database. Imported required data from database into an MS Access database for updating data, and provided Excel reports of newly hired employees, terminated employees and current employees on file on a global basis.
• Provided reports on a weekly basis to management.
• Designed and created Microsoft Excel spreadsheet to provide functional user interface with another analyst.
• Coded application in Microsoft Excel VBA, which provided tool to assist another developer in creation of new data analysis systems.

Environment: MS Access 2007/VBA

Confidential

SQL Developer / Technical Analyst

• Updated existing databases to reflect new changes in the law and provided users with updated databases.
• Created/updated and maintained tools.
• Created and maintained SSIS package for the process of data cleansing, according to requirement.
• Modified, enhanced, and maintained several MS Access prototype tools on a required basis used by management stakeholders/business users.
• Provided ongoing support/expertise for several tools, including TRDBA, Timestamp, SuperTracker 2000, Inspection Correction Tool, Monthly Management Report, and QA Scheduling Tool.
• Troubleshot user issues and provided solutions.
• Wrote queries to analyze data and provided critical reports to management in MS Excel for decision making.
• Improvised, rectified, and enhanced code in MS Access to reflect new regulation changes.
• Performed compact and repair of database.

Confidential

Lead Technical Analyst

• Performed business analysis and gathered, analyzed, and documented functional/business requirements based on information gathering sessions with clients/stakeholders and project team members.
• Reviewed and analyzed requirements for software development.
• Conducted and participated in JAD sessions with stakeholders to collect software requirement specifications.
• Captured requirements and developed design document.
• Developed, maintained and enhanced REAC and PASS offline tools written in Access 2007 utilizing ODBC connections to data warehouse maintained in Sybase.
• Planned, designed, and implemented application database objects such as tables, queries, forms and reports.
• Built and maintained SQL scripts, indexes, and queries.
• Fine-tuned performance of SQL queries and stored procedures.
• Utilized T-SQL to create queries related to joining tables and aggregation of data.
• Provided database coding to support business applications using T-SQL.
• Identified business needs with business stakeholders, application developers, production team and across functional units.
• Developed technical documentation to support various applications such as User Manuals, Standard Operating Procedures and Technical Standardization Manuals.
• Participated in requirements gathering sessions and administration of User Acceptance Testing exercises.
• Used SharePoint for storage of completed MS Access databases.

Environment: MS Access 2007/VBA, Sybase, SQL Server 2005, T-SQL MS Excel, SharePoint

Confidential

MS Access / SQL Developer / Analyst

• Created/migrated databases to SQL Server databases for stability and usability of end users, and to collect data from various database sources to perform analysis and then integrate them with existing systems.
• Performed work on partially developed client MS Access 2003 database which dealt with rebates to Pharmaceutical and Government Part-D clients.
• Refined database to ensure Client/Server 2005 compliance.
• Created tables, queries, forms, switchboard, macros and modules, and complied with Quality Assurance department testing.
• Performed MS Access to SQL Server database migration/conversions.
• Migrated Access application to SQL Server 2005 using SSMA implemented security and login for users.
• Wrote documentation to present to users on using MS Access, SQL Server 2005 and Client/Server application.
• Utilized database objects such as tables, views, functions, triggers and stored procedures, and indexed using T-SQL queries.
• Created reports according to business requirements using SQL Server 2005 Reporting Services.
• Produced reporting data models to be used by new Report Builder ad-hoc reporting tool in Reporting Services 2005.

Environment: MS Access 2003/VBA, SQL Server 2005

Confidential

MS Access Application Developer / Analyst

• Created various MS Access databases for various departments.
• Analyzed requirements for software development.
• Captured requirements and developed design document.
• Designed tables, created queries, sub-queries, and forms, and developed drill-down reports.
• Utilized users' business requirements and created user interface forms .
• Used Crystal Reports for business reporting.
• Created switchboard with several detailed and drill down reports.

Environment: MS Access 2003/VBA, SQL

Confidential

MS Access Application Developer/Analyst

• Maintained database and generated plan based reports about various plans for analysis.
• Imported data from data source DB2 into MS Access.
• Wrote DB2 SQL declarative statements as required.
• Designed tables, created queries, sub-queries, and forms, and developed drill-down reports.
• Utilized users' business requirements and created user interface forms and switchboard with various detailed and drill down reports for state-wide supervisors, managers and employees.
• Generated daily, weekly, and monthly reports for manager and supervisors.
• Provided support to internal users in MS Access and wrote queries and VBA.

Environment: IBM-DB2, MS Access 2003/2007/VBA , SQL

Confidential

MS Access Application Developer

• Maintained and enhanced databases as per needed requirements.
• Migrated several housing applications from Wang into MS Access 2003 databases.
• Created tables, performed data-modeling, created queries, and designed forms along with VBA coding for housing application in MS Access ready for migration into Oracle database.
• Designed and printed several salary increase reports in MS Access for city-wide professional and nonprofessional employees.

Environment: MS Access 2003/VBA, Wang

Confidential

MS Access Application Developer

• Designed, developed and implemented application in MS Access/VBA from user-specifications for workmen compensation management, importing data from MS Excel files into a new MS Access database for data-validation and statistical daily input. Utilized for customer account tracking programming forms with VBA/SQL ADO coding for various calculations.
• Downloaded data from Pick/BASIC database through SQL Server connectivity, and created database in MS Access 2003 according to client/user requirements for accounting department's reporting needs and usage.
• Designed and developed a database in support of administrative accounting.
• Provided ongoing development. Adhered to Quality Assurance process through development testing

Environment: MS Access 2003/VBA, ADO, SQL Server, VB 6

Confidential

MS Access Application Developer / Analyst

• Repaired/maintained remote sites in the U.S. using a unicenter remote control software program to work with various servers on the network, and get them up and running at different U.S. locations.
• Repaired, rectified and troubleshot problems in existing Access, MDB's and bat files including Job Scheduler.
• Modified existing Access databases making them fully efficient and enhancing their capabilities.
• Investigated systems performance problems and made recommendations for improvements.
• Created, enhanced and supported Microsoft Access databases.
• Performed software development and maintenance for two MS Access production programs.
• Wrote SQL queries for Access front end converted .dbf files to MS Access table objects for ease of manipulation.
• Designed forms and query structures that increased data entry efficiency over the existing system.
• Identified and resolve performance problems.

Environment: MS Access 2003/VBA, SQL

Confidential

MS Access Applications Developer/Analyst

• Extracted and led data in data warehousing, and processed to meet new requirement. Created, designed and modeled report as per requirement.
• Created Access databases utilizing Visual Basic for applications, including tables, reports, modules, macros and forms.
• Created web page, using Visual InterDev, and designed for entry into an Access database using ASP, VBScript, SQL and HTML.
• Developed Access/Excel query system, which dynamically selected column and row data from various tables based on DLookup functionality.
• Created dynamic calculations based on tables so that future calculation changes did not require additional programming.
• Performed data cleansing through both SQL queries and internal/external VBA.
• Programmed custom VBA Excel to facilitate assembly of multiple file data into contiguous, manageable information.
• Utilized SQL Navigator to run queries to analyze data for daily functions and monthly reporting.
• Generated various benefit reports for COBRA and retirees utilizing Access SQL and VBA programming.
• Created data access pages and group DAP augmenting with VBScript.
• Developed and enhanced database and reported to management on an ongoing basis.
• Proposed and designed a fully automated contact management application using MS Access and VB, and used Crystal Reports for business reporting.
• Utilized SQL Queries as string variables called by GUI. Utilized ADO Recordsets as data sources for linked applications. Linked database to Outlook and Word using VBA. Utilized variable record sources for combo boxes in conjunction with code to make self-limiting option lists.

Environment: MS-Access 2003/VBA, Excel