SUMMARY:

• Over 15 years of experience in IT and Client/Server Web based Application design, analysis, testing and production support utilizing Microsoft VB/Access/Excel/Word/PowerPoint VBA, Macros, Pivot Tables, Cubevalue, Chart, C#, C++ VB.Net, Asp.Net, Java, PeopleSoft, SQR.
• Demonstrates proficiency in interfacing, integration, Object and data migrations, Security administration and System Audit
• Worked with the users, gathering information about the process in the SAP HR, ECM, BW, BS, OM, PeopleSoft HR, Payroll, Time & Labor, Benefits and Compensation.
• Generated tables using Analyst Software and developed Standard, Unknown, Summary, Regression and other reports.
• Development of Technical and Functional Spec’s for HR, Payroll and Time & Labor processes.
• Expertise in writing, tuning and debugging using (Arrays, Procedures, Look - Up, Break, Files, Charts, Images and so on..) and Query tools like Queries.
• Strong working knowledge on Oracle, SQL Server, Query Manager, Toad, SSIS, SSRS.
• Developed business objects, database objects using OODesign/OOP using Excel/VBA/C#.
• Demonstrates proficiency in interfacing, integration, Object and data migrations, Security administration and System Audit
• Involved in gathering requirements, designing, building and testing production break/fixes and enhancements
• Experience analyzing and writing complex queries between cross platform system databases UNIX and Windows experience
• Used of SQL, T-SQL to transform data
• Developed applications using PL/SQL packages, Stored Procedures
• Provided on-call Production support of applications during business and non-business hours
• Possessed good communication, analytical reasoning, logical and problem solving skills.
• Provided support and for end users

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows, UNIX and RedHat Linux

Databases: Oracle 8i/9i/10g, SQL Server 7, MS Access and MySQL 4.X olap db: tm1 analysis services microsoft Technology: excel/vba, Macros, outlook, word, powerpoint, asp.net, Visual basic.net, Ajax, LinQ, WPF, vbscript

Development: excel/forms, access/forms, SQL, Macros, PLSQL, Brio SQR, Oracle forms, COBOL, Queries, STAT 5.2, HTML, C, C++, C#, JAVA 5.0, Java-scripting & VB

Applications: MICROSOFT (WORD, EXCEL, POWERPOINT, ACCESS, FRONTPAGE, SQL QUERY

Reporting Tools: excel/reports, access/reports, SQR, SSRS, Business objects, Crystal reports, PS Query

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Analyst\Developer

Responsibilities:

• Developed Cost allocation budget application
• Developed Monthly end SAP Expenses and manipulated TF and AMC expenses
• Developed Group Expenses by Division and Department
• Developed Group SAP Expenses between “UPI” and Division related
• Developed Associate Corporate overhead UPI related expenses to Department where Staff belongs
• Developed to Identify expenses directly to projects using idesk projects Id
• Developed Allocating UPI related expenses using TRS (Time recording system) Information.
• Developed Allocating Remaining Costs to four Departments CFG, CMG, CNG and CTT
• Developed Allocating Department level Costs to Investment and Advisory projects.
• Developed Allocating to Investment Product level.
• Added Customized ribbons, modified add-ins

Environment: VB6, Office 2013 Professional plus, Excel/Access\Word VBA Macros, Add-ins, Excel/Word Ribbons SAP Data

Confidential, Auburn Hills, MI

Analyst\Developer

Responsibilities:

• Production support on projects users and role creations using VBA
• Developed VBA application from scratch to develop Q* policies, and entitlements reports to manage and identify missing policies roles and active directory
• Developed VBA application from scratch to developed Active Directory policies, User specific creation, User specific role assignment reports
• Supported VBA applications which read data from various sources and rearrange them in new formats to save tens of thousands of man-hours of manual Excel work
• Developed and supported VBA applications on ETL programs handling millions of data using VBA macros.
• Developed VBA reports on policies, modelID’s, Users, Role, Role Entitlements, User access Mainframes and so on.
• Enhancement to clear Log files from server.
• Developed Adhoc reports on daily basis

Environment: VB6, Office 2010 Professional Plus, Excel/Access/VBA, Windows 8.1

Confidential, Troy, MI

Analyst\Developer

• Support Excel 2010 applications
• Prepared Scripts for Upgrade Office 2010 Professional Plus to Office 365 ProPlus.
• Prepared deployment documentation, troubleshooting documentation
• Prepared help desk questionnaires in support of deployment Office 365 to user’s machines.

Environment: Office 2010 Professional Plus, Office 365 ProPlus, Excel/Access/VBA, Windows 8.1

Confidential, Princeton, NJ

Applications Analyst/Developer/DBA

Responsibilities:

• Analyzed existing Forecast Model Builder and developed New Forecast Model accessed Internet/Intranet.
• Build Forecast Model Characteristics and Data stored to map for calculations.
• Analyzed a structure of input sheets and validate the data by user inputs.
• Data is planned to store in two ways. One in Access database and the other in worksheet and restored the data back to the input sheets if user wants’ to update.
• Data is mapped in multiple levels of structures and restored for calculations.
• Build & Tested an Interface which looks like exactly html web page users and can navigate to different Input sheets, Calculation sheets, or charts & Diagrams.
• Provided inputs that would be the foundation of the structure of multiple input/output worksheets throughout the model
• Build & Tested and captured the time series forecasts for total and newly treated patients for a Segment by Sub-Segment, Geography, and Patient Group, as well as other critical inputs for forecasting market size.
• Build and Allowed the users to define unique attribute names, number of attributes, regimen components, and regimens (name and number), for all sub-segments and patient groups in the model.
• Build & Tested and captured inputs for product profile, market entry, indication launch timing, Share of Voice, Current Shares, Market adoption in order to generate Relative Attractions, Diffusion Curves, and peak share outputs
• Build & Tested and captured peak market access and the dynamics of market access for the relevant BMS regimens in the model by geography, sub-segment, and patient group
• Build & Tested and captured the dosing, pricing, Doss of Therapy, compliance, and persistency related information for the relevant BMS regimens in the model
• Build & Tested and consolidate all of the inputs into one useful view, as well as to calculate shares, patients, volumes, and revenues for the Selected BMS regimen, Sub-segment, geography, and Scenario.
• DBA activities are maintained for this application in between the users.

Environment: Excel/Access/ VBA/VB6 2003, 2007, RAD, DBA, OOPs, C++, XML DAO, Macros, Adhoc Reports, Upsizing Wizard, Access Database, SQL Server, SSRS Internet/Intranet.

Confidential, Parsippany, NJ

Applications Analyst/Developer/DBA

Responsibilities:

• Analyzed Salary Hike to the Employees - Enterprise Compensation Management
• Developed Excel/Access VB application uploading SAP data to Excel Object Oriented and processed data to Salary Planning sheet to all the Employees report to the Manager
• Developed Excel/Access VB application uploading SAP data to Excel and processed data to Salary hike Budget plan sheet to all the employees in the Client.
• VBA programming TM1 macro functions and ODBC link to accounting to customize interface and automate processes.
• Analyzed, modeled, Build & Tested and implemented select portions of a TM1 based forecasting, budgeting and financial reporting solution.
• Designing and Building of Cubes, Dimensions and Elements in a team and DBA activities.
• Participated in a complex application development that used TM1 9.0 APIs to go through dimensions, elements of cubes and prepared user interface in Excel.
• Worked on Data issues in TM1 reports. Worked extensively with TM1 Error Logs file to figure out the data loading process and pin point where the data went wrong and implement the fix.

Environment: Excel/Access/PowerPoint/VBA/VB6 2007, DBA, RAD, C++, OOPs, XML DAO, Macros, Adhoc Reports, TM1, SAP HR, ECM Upsizing Wizard, Access Database, SQL Server, SSRS, Windows Vista.

Confidential, Newark, DE

SharePoint Analyst/Developer/DBA

Responsibilities:

• Developed the requirements based on business events and responses
• Developed Adhoc reports, data-centric solutions for user interface application which can access, consume, and manage data from any data source.
• Build up the Security administration for TQM (Total Quality Management Database) and CAMS (Controlled Analytical Method Services) such as Creating User and Group Accounts and Security permissions to all objects in Excel/PowerPoint/Access/VBA.
• Customized Project Management for TQM using Access/VBA, Macros, and Access DBA.
• Customized Equipment Management, Archives Management for TQM using Excel/PowerPoint/VBA DAO, and Macros.
• Involved in Payroll Processing - Paysheet Creation, Pay Calculation, Pay Confirmation.
• Re-built the Payroll checks customizations done on related to logo on checks and Add Personal Hours Box with start, earned, taken, adjustments and end balance.
• Maintained user groups and security on TM1 objects.
• TM1 files administration and responsible for moving data from Development to test server for user testing.
• Development of test cases for TM1 applications (TI Processes and TI Rules)
• Worked on Excel VBA applications to parse XML files and feed these data to DB.
• Developed Method Reports, Run Numbers Reports, and Method History Reports for CAMS using Access/VBA, DAO, Macros, Reports, TM1, Forms and Queries. Also Integrated SQL DBA and pulled data and processed to transfer third party.
• Developed and implemented select portions of a TM1 based Salary Planning.
• Created new Access applications based on existing Excel spreadsheets in order to streamline and standardize reporting and analysis
• Programmed Excel and Access applications to provide analysis and graphing from external Pharmaceuticals.
• Developed XML/Access/VBA, DAO, and TM1 Interface Application to transfer data from Analysis tool to SQL database and generated Analyst Standard data report.
• Improved the size of data base objects using Upsize Wizard.
• Developed Excel/XML? VBA, ADO, Macros, Pivot tables, Charts, Application to transfer data from Analysis tool to SQL database and generated Analyst Unknown data report.
• Developed Excel/VBA, Macros, Adhoc reports, Pivot tables, Charts, Interface Application to transfer data Application to transfer data from Analysis tool to SQL data base and generated Analyst Summary Report for both Standards & Unknowns.
• Developed Excel/VBA, Macros, Interface Application to Upload data from Analysis tool to SQL data base and generated Analyst Regression report
• Developed Excel/VBA Interface Application to transfer data from Analysis tool to SQL data base and generated Analyst Summary of Standard report.
• Scheduling and distributing reports through Data validations, Data conversions and Migrations.

Environment: Excel/XML/ Access/VBA, Adhoc reports, DBA, RAD, SAP HR, ECM, BW, BS, OM, Payroll, Benefits, TM1, DAO, Macros, Upsizing Wizard, Asp.Net, C#, COM, Ajax, C++, XML, Visual Studio, Crystal Reports, SQL Server, SSRS, Access Database, Windows XP.

Confidential, LA

Lead PeopleSoft HCM Consultant

Responsibilities:

• Quick Hire - Developed & provided a simple and easy mechanism of database application for users to hire Residual Stakeholders into Application database forms without having to enter data into numerous delivered screens using Peoplecode.
• STD Process - Designed for maintaining details Benefits (General Info, Claim data, Payment, Process Info, Physician Info, and Light Duty) of EE’s Medic-claim’s using SQL and Peoplecode.
• Report Processing - Customized the run control forms (Pension Process - zpy201, zpy202, zpy203, Report of contributions - zpy212, zpy213, zpy214, zpy215, zpy216) consistent and use "from payend date - to payend date" Integrating SQL Server database,TM1, using SQR, Excel/Access/VBA, Oracle.
• Developed custom data extracts and formatted results into a readable format for client in application database.
• Developed and supported interfaces with SQL database systems.
• Extensively done ETL activities using PL/SQL.
• On-call support of applications during business and non-business hours
• Extracted data from third party tool (TALX) and loaded into Application database using Peosoftcode, SQR.
• Customized the SQR report to get check reversals based upon payroll run id(s). Panel with option to turn off generation of labor adjustments for a check reversal
• Developed Inbound and Outbound Access Interfaces to extract data for NBC employees as per client requirement

Environment: PeopleSoft HCM, 8.3/8.42, HR, Payroll, Benefits, Compensation, Excel/Access/VBA, Macros, Upsizing wizard, Forms, Adhoc reports, C#, Brio SQR, SQL Server, Queries, COBOL, Windows XP

Confidential - SFO, CA

Report Analyst

Responsibilities:

• HRAUTHORIA - Designed, Developed, Tested & Maintained AUTHORIA Export Program. Compensation-Authoria project, new outbound text files is generated from Application database to the Authoria system. (‘INDIVID.TXT’, 'ADDRESS.TXT', 'JOB.TXT', 'JOBFAMILY.TXT', 'INDJOB.TXT', 'INDFTE.TXT', 'SALARYGRADES.TXT', 'INDSTATUS.TXT', 'SALARY.TXT', 'INDCURRENCY.TXT', 'POSITIONTABLE.TXT', 'EDHIST.TXT', 'LOCATION.TXT', 'PROCESSMGR.TXT', 'ORGUNIT.TXT', 'INDORGUNIT.TXT') using SQR, Peoplecode, Application Engine, Oracle, Access/VBA, DAO, Access Database.
• Report BNCCSABB - Developed the process Sabbatical Accrual. Conversion Program into Leave accrual table.
• Created backup copy of access database and Improved upsizing the Access Database using wizard.
• Responsible for Data interfaces between Oracle and third party software.
• Developed complex inbound, outbound interfaces and processes for HR applications.
• Developed several Benefits, HR and Payroll reports using Excel/Access/ Excel, Macros based on the needs of the customers.
• Involved in business development life cycle, customizing Oracle Forms, Oracle Reports and Oracle PL/SQL Programs.
• BNCCABSC - Developed the process Sabbatical Accrual. Conversion Program is developed to load the sabbatical information from JOB into the Absence History pages.
• BNCEESPP - Developed the process “New Employee Stock Purchase Plan” Export, Employee Stock Purchase Plan (ESPP) will include allactive employees who are eligible to participate in ESPP.
• BNCCGENL - Developed the process “To stops the enrollments for 401K and 401KCU” in general deduction table.
• Customized online object “Mass Transferred and Terminated EE's” with status I (Seasonal In-Active) and U (Terminated with Pay) in input file should not be uploaded, but the log message needs to show error with error message and not success.
• Prepared analysis document and design methodology to meet new enhancements.
• Prepared Technical Design Documents and Impact Analysis Documents and responsibility of reviewing all documents of critical priority.

Environment: Peoplesoft HRMS 8.3, PeopleTools 8.4, Application Designer, Peoplecode, SQR, Application Engine, Process Scheduler, Excel/VBA, Access/VBA, ADO/DAO, COM, Macros, Forms, Reports, C#, ASP.Net, HR, Administer, Upsize Wizard, XML, Crystal Report, SQL Server, Queries, Windows XP

Confidential, Edison, NJ

PeopleSoft HRMS, Excel/Access Report Programmer

Responsibilities:

• Used PL/SQL to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Converted data from third party systems to PS reports tables.
• Developed different custom reports using Access and Query Tool Reports.
• Involved in Payroll Processing - Paysheet Creation, Pay Calculation, Pay Confirmation.
• Re-built the customizations done on PAY001 and DDP003 related to logo on checks and Add Personal Hours Box with start, earned, taken, adjustments and end balance.
• Involved in setting up meetings for gathering information with users and draw them in a document.

Environment: PeopleSoft HRMS 8.3, PeopleTools 8.4, Application Designer, Peoplecode, SQR, Excel/VBA, Access/VBA, Forms, Reports, C#, COM, ASP.Net, XML, HR, Administer Workforce, Crystal Report, Oracle, Queries, COBOL, Windows XP

Confidential

PeopleSoft Programmer

Responsibilities:

• Involved in setting up meetings for gathering information with users and draw them in a document.
• Participated in Initial Upgrade & Move to Production Process
• Performed Initial and final Audits to ensure that the database is clean.
• Involved in Application Upgrade, Performed SQL Scripts
• Participated in Copy and Compare report Analysis
• Retrofitted the Objects as per the requirement
• Analyzing and Customizing the Excel/Access programs

Confidential

PeopleSoft Programmer

Responsibilities:

• Responsible for gathering requirements, designing, building and testing production break/fixes and enhancements.
• As a Developer - Responsible for Privacy (keeping data hidden), Integrity (keeping transmitted data intact), Authentication (verifying the identity of transmitted data)
• Designed and developed a custom Access Report that computed all the deductions for all employees based on their existing benefits setup which created an interface file for feeding it to CBM.
• Administrative workforce - For Hire EE’s to obtain accurate National id’s or to set National id’s customized SQC.

Environment: PeopleSoft HRMS 8.3, PeopleTools 8.4, Application Designer, Peoplecode, SQR, Excel/VBA, Access/VBA, Forms, Reports, C#, COM, ASP.Net, HR, Administer Workforce, Time & Labor, Benefits, Oracle, Queries, COBOL, Windows XP