PROFESSIONAL SUMMARY:

• Innovative and resourceful professional wif around 13 years of IT experience in Software Development Life Cycle wif strong communication, interpersonal and organizational skills.
• Industry experience includes Health Care, Web Portal Development and Manufacturing. Skills include analysis, design, testing, and deployment of systems wif exceptional abilities in support and maintenance.
• Worked on various technologies/plat forms such as ASP, IIS, MS Access, MS Excel, VBA, SQL Server, Business Objects,Tableau, Crystal Reports, Visual Basic, SharePoint and Oracle.
• Written Several VBA code programs in both MS Excel and MS Access platforms
• Worked wif MS Office 97/2000/2003/2007/2010/2013 versions.
• Written VBA Code to fetch data from SQL Server, ODBC Connection, Excel Sheets in teh Same Workbook, Treating Excel Sheet itself as a table.
• Designed and developed application for fetching data, perform Analytical processing, perform several complex calculations and presenting teh data in custom format using VBA
• Written Several User Defined functions to achieve teh final output using VBA
• Written VBA Code in MS Access to Update SharePoint list
• Developed forms in MS Access, Flexibility for user wif Dashboard interface containing Several buttons (As teh user clicks teh buttons all teh tasks will be controlled by VBA Code in teh behind)
• Written Several lines of VBA code using Nested Loops
• Written Code to fetch data in Access tables, where a particular column TEMPhas values separated by ‘#’, used Functions like Split to split data into array of strings, analyzing it and creating reports of such detail content
• Written VBA code for formatting tables in Excel
• Written Macros to Control Pivot Tables in MS EXCEL

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/NT/2000/XP/7/8, UNIX and MS - DOS

Programming: Java, C++, C and COBOL

Database: MS - Access 2013/2010/2007/2003, SQL Server 2000/2005/2008,Oracle

GUI: Visual Basic 6.0

Internet Tools: ASP, HTML and Java Script

Web Servers: IIS, JWS and PWS

Methodologies: OOA/OOD

Others: Sharepoint, Visual Source Safe, Microsoft Office

Business Intelligence: Tableau, Business Objects 6.5/XI/XIR2/XI 3.1, Micro Strategy 9.30

Security Tools: HP Fortify Suite, Web Inspect 9.30/10.0/10.1/10.2

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Reporting Developer/Analyst

Responsibilities:

• Gathering teh reporting requirements from teh Business Users, document them, analyze, design, test and implement teh reports.
• Analyze and prepare necessary reports for teh WIB database
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports
• Extensively used SQL queries, Views wif several joins
• Documented teh whole process including teh Process definition wif flowcharts, User Manual, Possible Future changes, settings
• Proficient in writing, executing MDX Queries and MDX functions
• In Process of developing Dashboards using VBA button to generate reports on press of a button

Environment: Tableau, Microsoft Access 2013, SharePoint 2010, VBA, Excel 2013, SQL Server 2014, Windows 7

Confidential, Grand Rapids, MI

Sr. Ms Access/VBA Developer

Responsibilities:

• Gathering teh reporting requirements from teh Business Users, document them, analyze, design, test and implement teh reports.
• Worked Parallel wif Business Users for resolving teh day to day common issues
• Worked wif Microstrategy Office to extract report data into teh Excel sheets
• Redesigned and automated teh Assortment Planning tool
• Redesigned and automated teh process of EndCaps tool, teh process to avoid downloading of 24 excel reports into a single press of button
• Worked from scratch for teh automation of EndCaps planning tool
• Extensively used VBA to perform several complex calculations
• Created adhoc reports to users in Tableau by connecting various data sources.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports
• Extensively used SQL queries wif several joins between teh Tabs in teh same Excel Sheet
• Documented teh whole process including teh Process definition wif flowcharts, User Manual, Possible Future changes, settings
• Worked on Pivot Tables wif large volume of data using Data Cubes and SSAS
• Proficient in writing, executing MDX Queries and MDX functions
• Extensively used Pivot Tables and Charts and Developed several Management Dashboard Reports
• Extensively used Index, Match and Vlookup functions wherever necessary on large volumes of data
• Developed Dashboards using VBA button to generate reports on press of a button

Environment: Microstrategy office 9.3,Tableau, Microsoft Access 2013, SharePoint 2010, VBA, Excel 2013, Power BI, SQL Server 2008, Teradata, Windows 7

Confidential, Detroit, MI

Sr. Application Developer

Responsibilities:

• Gathering teh requirements and implement teh new requirements for teh reporting process
• Downloading teh Scanning results for teh 1100 applications daily and run macros to update teh SharePoint wif teh latest scan results using VBA and MS Access Queries
• Uploading teh same data to Database and produce various trending reports
• Generated several Reports out of SharePoint Lists, MS Access Database, Excel Sheets, CSV’s using MS-Access and Excel Macros wherever necessary
• Extensively used SharePoint lists to represent teh data through out all teh regions
• Generated several Pivot Tables in Excel by using teh SharePoint as back end and using Power BI Pivot Tables and Power Query
• Prepare teh daily NON Compliant URL list and send it across to all regions
• Generated Several Reports from Excel and Access Macros and updating teh GM management reports
• Involved in creation of several Pivot Tables and several Management Dashboards
• Provide Reports for support, guidance for Security Leads, IT Managers
• Involved generating reports using custom built queries from in SQL Server using SQL Server Management Studio.
• Reconcile McAfee URL registrations periodically and remove unnecessary URL from scanning
• Reconcile McAfee URL’s wif ASMS data
• Providing Ad hoc Reports from various people like IT Owners, Business owners, Suppliers etc.
• Global Point of contact for WAS Metrics reporting
• Working on teh data which is a result for merging data from two sources, perform necessary calculations
• Ensure teh metrics are accurate and up to date and implement day to day changes like prepare Custom WAS reports on request
• Reconcile McAfee Invoices from month to month wif IT Purchasing
• Generate pictorial views in teh form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.
• Involved in Cross Checking teh Calculations from teh report wif Manual calculations against teh database and was Involved in development of Test Cases
• Preparing Estimated Invoices for Finance Group, reconciling teh approved Invoices wif Finance group
• Supporting teh technical needs of SharePoint lists, WAS Metrics
• Creating SharePoint Lists, Custom views for teh list, adding additional columns, calculated columns and Sharepoint administration.

Environment: Microsoft Access 2013, SharePoint 2010, VBA, Excel 2013, Power BI, SQL Server 2008, Windows 2008, HP Fortify Tool Suite, VISIORR Donnelly

Confidential, IL

Sr. Access Developer

Responsibilities:

• Built teh entire database for teh Aetna Reporting from teh given project specifications
• Developed User Interface in a friendly manner to obtain teh reports by a single button press.
• Involved in writing several SQL Queries to update teh Target Tables according to fulfill teh business implementation.
• Developed teh DB to merge data from SQL Server using Linked Tables and from Excel Sheets, “.CSV” files (from Main Frames).
• Developed Access Macros using VBA to upload data from Excel sheets into Respective tables
• Developed Excel Macros to modify teh data that is received from Custom Point to fit into teh Aetna Reporting
• Used Link tables from SQL Server for Louise Detail Reporting
• Analyzed business requirements and developed custom Access reports and queries for teh RRD D.csv & Louise D.csv Import files.
• Developed several MS Access Reports for teh Custom Point
• Involved in creation of Pivot Tables and Pivot Charts
• Developed set of several complex new reports for new ware house that start operations at Temecula, CA
• Worked on adding new warehouse codes and implemented teh changes in common reports and thus recalculating all financial reports which are linked wif WHS production.
• Worked on various invoice reports to implement a new “Binding Charge” for all three ware houses.
• Developed several complex reports such as Kit Machine Units, Kit Hand Units and Inkjet Units for all teh three warehouses.
• Developed Few reports in Business Objects XI 3.1

Environment: Microsoft Access 2007, Business Objects 6.5/XI 3.1, Microsoft Excel 2007, Visual Basic 6.0, Oracle 10g and SQL Server 2005, Windows 2000

Confidential, Detroit, MI

Sr. Access Developer

Responsibilities:

• Worked as production Support for all teh Regions (GMNA, GMAP, GME & GMLAAM).
• Developed PL/SQL Stored Procedures to perform Complex Calculations, Lease Transaction Report, Cash Flow Reports.
• Used VB Scripting code to perform teh Upload Activities
• Developed sever complex reports including Pipeline Report, Lease Transaction Report, Cash Flow Report, Lease Extend / Buyout Report etc
• Worked on fine tuning teh Queries to fulfill teh report requirements.
• Worked Parallel wif Business Users and Project Leads of Various Regions
• Modified teh Report Queries every month to fulfill teh Business Users Requirements
• Modified teh relationships by removing unnecessary tables for faster access of data.
• Resolved Issues wifin teh given time frame across all teh regions.
• Developed Access Macros to upload data from Excel sheets into Respective tables
• Developed queries to copy data from one column of a source table to another column of a destination table depending upon an existing condition.
• Developed Excel Macros using VB Scripting for automatic generation of Serial Numbers.
• Developed several MS Access/Ms Excel Reports
• Developed complex report that consolidates all regions Lease Transaction Report.
• Updated several existing reports to reflect teh Forex changes.
• Developed Lease Expenses Forecast Report that halps to analyze teh future expenses.
• Developed several complex financial reports for Global Lease Management System.
• Developed a new version of database, wif production tables residing on teh Server and teh all teh intermediate tables on teh Client PC.
• Involved in Several Net Meeting Sessions and resolved several Issues through out teh regions
• Involved in full documentation of teh whole database including teh Process definition, monthly report generation, Monthly Report Consolidation for storing them in e-Room Facility.

Environment: Microsoft Access 2003, Business Objects 6.5, Microsoft Excel, Visual Basic 6.0, Oracle 10g and SQL Server 2000, Windows 2000

Confidential, Livonia, MI

Sr. Access Developer

Responsibilities:

• Responsible for development and integration of many querying and reporting functions for a multitude of system users and clients.
• Close interaction wif other Developers and Business Analysts.
• Involved in Business meetings to gather teh requirements for teh new application.
• Analyzed client requirements and developed custom reports and queries.
• Involved in design of Forms & Validations in access.
• Involved in developing teh ASP application for teh users to enter teh security roles for different users using SQL Server as back end.
• Involved in creation of Pivot Tables and Pivot Charts for data analysis.
• Created Daily reports for billing purposes in MS Access.
• Created Weekly reports for teh social workers for plan their week ahead.
• Created special reports for trends in complications.
• Converted existing spreadsheet tracking methods to MS Access.
• Created customized MS Access modules, forms and reports to accommodate business rules and methods
• Created Mailing list reports in MS Access.
• Developed GUI screens for user interface for accessing, searching and manipulation of reports

Environment: Microsoft Access 2003, SQL Server 2000 and Oracle, MS Excel, Visual Basic 6.0, Business Objects 6.1B, IIS, ASP, Windows 2000

Confidential

Sr. Programmer Analyst

Responsibilities:

• Involved in total conversion of teh project from desktop version to Internet Version.
• Redesigned teh database to create provision for storing teh data for multiple users as teh old database supports only single user data.
• Developed Interfaces in ASP same as that of in Visual Basic Screens.
• Involved in creation of Pivot Tables and Pivot Charts for data analysis
• Used Java Script extensively for all client side validations whenever necessary.
• Developed Online Quiz on Health related topics.
• Developed Online Health Calculators using Java Script
• Developed facility to update day-to-day health related articles wifout changing teh code.
• Developed Access Macros to upload data from Excel sheets into Respective tables.
• Developed Excel Macros using VB Scripting for automatic generation of Serial Numbers
• Developed web based Key Request System as a part of Software Key requests, which monitors how many key requests teh user, TEMPhas placed.
• Developed Online Shopping Facility for teh software products
• Involved in integrating teh code for Credit Card payment authorization through 2checkout.com.
• Developed teh Log creation for teh users for watever teh pages they visit once they login to teh portal.
• Developed teh facility for teh administrator to Enable/Disable teh User profile, extend his validity date, reset teh User password, and reset teh user’s personal details.
• Developed teh batch creation facility for prepaid licenses.
• Developed web pages in ASP.
• Used Java Script extensively for all client side validations whenever necessary.
• Involved in Front End Design of Job Seeker & Employer Pages
• Developed teh facility for employer for posting of Jobs.
• Involved in development of Control Panel for Administration of teh total portal.
• Developed teh facility for teh Administrator to view/change teh users profile
• Developed teh facility for upgrading teh Employer to a higher level or downgrade to a lower level.
• Developed teh facility for employer for Searching a User who is having a certain skill set.
• Developed teh facility for Job Seeker for searching of jobs availability
• Developed teh facility for Administrator for view teh Job Seekers & Employers page wise

Environment:ASP, MS Access, MS Excel, Visual Basic 6.0, Crystal Reports SQL Server 7, IIS and Windows 2000