TECHNICAL SKILLS:

Operating Systems: Windows 7, 8, Vista, Windows 2000, Windows XP, Windows NT, Windows 95/98,10 Windows3. X, MS DOS, UNIX

Languages: VBA, VB, VB5.0, VB6.0, VB.NET, C#, SQL, VBScript, JavaScript, ASP, ASP.NET, HTML, FORTRAN, MQ SERIES

Technologies: .NET, MTS, COM, DCOM, COM +, XML, XML.NET, XLST, ADO, ADO.NET, Web Services (Design/Implementation & Consumption), SharePoint, PowerPoint.

Databases: SQL Server 2000/2005/2008/2010 , Oracle, MS Access 97 /2000/2003 - 2010/ XP, Sybase, DB2

Data Modeling Tools: ERWin

Report Generating Tools: ActiveReports, Crystal Reports, VB report Tools, SAS, Microsoft Reporting Services, WebFocus

Software Development Tools: Visual Studio 2005-2008, Visual Studio 6.0/.NET, Visual Interdev, FrontPage, Visual SourceSafe, MQ Series

Other Tools: Adobe Acrobat, Macromedia Flash, ePass, Photoshop, Power Point, Microsoft Office, PeopleSoft, Data Flex, Toxedo, Lotus Notes, Lotus 1 - 2 - 3, Excel, Microsoft Office Project Management, Siebel, Visio, Software Development Life Cycle (SDLC)

Data Warehousing: constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making including functions of Data Warehouse Tools and Utilities Data Extraction, Data Cleaning, Data Transformation, Data loading and Refreshing.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Senior Business & Data analyst

Responsibilities:

• Assist to Confidential management collect from branches and regions worldwide information about application in use.
• Determine type of each application, purpose, language, term of use, license and financial information.
• Determine applications duplications, time to retire.
• Generate reports and presentation for Confidential central and regional management using Excel, VBA, PowerPoint. Automate data migration from collected Excel reports into Central PowerPoint presentation.
• Automate data migration from Excel files or lists in SharePoint to reports and back. Provide daily meetings with regional team to update optimization process.
• Report to Confidential management about current. Generate auto e-mailing application to distribute standard forms to applications owners, VBA, Excel, and Outlook. Create Front end to update lists in sharepoint (VBA, MS Access)

Confidential

Senior Business & Data Analyst

Responsibilities:

• Security Vulnerability Remediation Program-Steering Committee.
• Data analysis Project created for Confidential Security Department.
• Organize Data migration, warehousing & validation from different data sou rces, including SharePoint, SQL into Data analysis Templates.
• Provide input on incidents maintenance planning processes and systems. Work closely with the business areas and translate the requirements to IT solutions. Create Templates, custom Dashboards, reports (SQL, VBA, Excel, pivoting, Charts, graphs, MS Access). Create and implement into Excel Dashboard custom math formulas to estimate trends and forecasts of calculated issues resolves (Math & Statistics). Made dynamic charts and graphs Reports based on receiving data.
• Coordinate all incoming data requests (collecting all information requests, assigned to correct groups, tracked to completion and distribution)
• Execute listings and tabulations to support global drug safely and compliance.
• Make automated templates to manipulate with data, make updates, auto generate reports and presentations. (PowerPoint, SharePoint, VBA, Excel).

Confidential

Senior Operational Business Data Analyst

Responsibilities:

• Data Warehousing and automation current Dashboards and Excel Reporting using SQL Server, Excel and PowerPoint VBA. (macros pivoting, formulas, Sharepoint, Visio, Powerpoint.) Organize data migration from different sources into developed Excel template. (SQL SERVER, SQL VBA, Access, Excel)Provide data validation and analysis.
• Organize auto migration data to Powerpoint Presentation for Bank Engineering Department management.
• Automate Powerpoint Presentation(slides export & import, slides and shapes manipulation), auto upload & download presentation to&from sharepoint. (Visual Basic for Application, Excel formulas & pivoting)

Confidential

Data Analyst /Developer Consultant, SCHAUMBURG, IL

Responsibilities:

• Confidential RXClaim project for auditing department. Project automates pharmacy prescription and financial auditing process. Create database and front end using SQL Server, MS Access, Excel, Visual Basic for application. Automate Excel Templates using VBA, macros, formulas.
• Assist to auditors nationwide to check Pharmacy networks - PBMs build networks of retail pharmacies, to provide consumers convenient access to prescriptions at discounted rates and monitor prescription safety across all the network pharmacies, alerting pharmacists to potential drug interactions even if a consumer uses multiple pharmacies.
• Help to auditors to Check Mail service pharmacies provide mail-service pharmacies that supply home-delivered prescriptions without the face-to-face consultation provided by a pharmacist.
• Help to auditors to check formularies - PBMs use panels of independent physicians, pharmacists, and other clinical experts to develop lists of drugs approved for reimbursement in order to encourage clinically appropriate and cost-effective prescribing;
• Help to auditors to work with Plan design - PBMs advise their clients on ways to structure drug benefits to encourage the use of lower cost drug alternatives - such as generics - when appropriate.
• Automate process to import data from Excel, text files and other sources to database. Organize Auto data validation, export text files for other group and create reporting tolls to compare Import and Export files and financial delta. Create Auto data analyzing process and pass reports to auditing or re-auditing process.
• Create full documentation, end - user education and presentations using PowerPoint and Visio.
• Automate data migration and Data Warehousing from different sources (SQL Server, text Files, Share Point and Excel files) into Access database. Automate clean up and validation raw data process. Manipulate with uploaded data, generate reports. Automate data manipulation in Excel. Create dynamic reporting tool in MS Access (MS Access 2007/2010, VBA forms, queries, Excel, macros SQL Server, tables, stored procedures, views).
• Full circle project, SDLC, Data validation, documentation, end - user education, presentations (Visio, Power Point).

Confidential

Consultant, Elgin, IL

Responsibilities:

• Confidential commercial credit card tracking tool. Fixed existing tool in Excel (VBA), add missing functionalities after MS Office change (xlsx, xlsm format).
• Data Warehousing and Automate data migration from different sources (SQL Server, text Files, Share Point and Excel files) into Access database. Automate clean up and validation raw data process. Manipulate with uploaded data, generate reports. Automate data manipulation in Excel. Create dynamic reporting tool in MS Access (MS Access 2007/2010, VBA forms, queries, Excel, macros SQL Server, tables, stored procedures, views).

Confidential

Consultant, Riverwoods, IL

Responsibilities:

• Audit scheduling system.
• Maintain and rebuilding existing MS Access application and Excel templates for multi user environment after MS Office and Windows migration, using VBA, Macros, MS Access, Excel, coding, form design and reports.
• Organize data loading from SAS and Excel to Access for future reports.

Confidential

Consultant, Chicago, IL

Responsibilities:

• “Worldwide Traders Desktop Applications maintenance” after migration to Windows 7 and Office 2010.
• Rewrite existing application in xlsm format, add and change functionalities.
• Create database to keep all new standard requirements, add searchable functionality, create reports per user instructions.
• Linked Access 2010 front end to SQL Server database utilizing VBA code and forms hyperlinks to documentation in SharePoint.
• Automation in data transferring from Excel local desktop applications into Reflection IBM. Coding in VBA, Macros, modules, COM objects and Reports.
• Reset and updated password protection features for custom Excel application.

Confidential

Consultant, Hoffman Estates, IL

Responsibilities:

• Loading data from different sources nationwide, such as Oracle, SQL Server, etc.,
• Create front ends in Access 2010 and Excel 2010).
• Maintain existing application to transfer VBA code and functionalities from .xls, xlsx files into xslm.
• Automate existing workbooks and create new custom reporting tool in .xlsm format using VBA, SQL, macros, Access 2010, Excel 2007, Excel 2010, forms, queries, ActiveX controls and reports.
• Organize system to distribute new reports and update existing trough SharePoint.

Confidential

Consultant

Responsibilities:

• Project for Strategy Planning including Data analysis and existing Access, Excel application improvements and maintenance, based on new company policy, change requests and calculations.
• Data Warehousing and Integrate Excel files into SharePoint and used SharePoint as a data source to track and deploy data.
• Using Excel, 203-2010, VBA, SQL, macros and reporting tools.
• Recreating existing documentation.
• Services into MSDB, running packages on schedule basis.

Confidential

Consultant, Chicago, IL

Responsibilities:

• Data analyst and developer for data migration project.
• Organize database from different sources such as text files and Excel, make data validation, standardization and data maintenance.
• Loading data into database, tracking ad hoc and standard reports development, using Excel, VBA, macros, coding and Access.
• Merged Excel files into SharePoint.
• Tracked and deployed data via SharePoint.
• Used VB.NET and XML for deployment of packages
• Develop MS SQL Server 2008 R2 based code to store packages from different sources in MSDB.
• Create procedures and SQL Server jobs to run packages.
• Create data flow presentation for user on weekly basis. Create SSSI packages, upload packages trough Integration Services into MSDB, running packages on schedule basis.

Confidential, Deerfield, IL

Application Developer Consultant

Responsibilities:

• Rebuild and maintain existing large scale customer allocation and reporting tool and organize Data Warehousing. Project based on new end user’s and customer’s requirements after Confidential & Hewitt joining. Developer’s part includes forms, macros, modules, queries, VBA code.
• Front end Access 2003. Back end SQL server 2007 and DB2. Create Excel - SQL Server data migration tool, stored procedures, triggers, views in SQL Server 2008.
• Coding, collect outsourcing data and implement code and new project components including ActivEx and COM application.
• Create project documentation, end user guides and presentations in Power Point.

Confidential, Oakbrook, IL

Application Developer & Data Analyst - Consultant

Responsibilities:

• “Command Central” project. Create full circle project for Confidential .
• Application collect, store and analyze installation’s data and installers activity in Confidential ’s restaurants worldwide.
• Create reports and charts for company’s top level management. Application includes back and front ends, reports.
• Data Warehousing and automation Downloading data from Web into Excel, organize auto data migration from different Excel workbooks to the Central Excel master files, VBA coded procedures to organize and format received, data flow, then auto load data into Access and SQL Server database.
• Created fully protected Access database and set up/created all custom security features for multi-user access.
• Create reports parts to manipulate, update and analyze data, create reports in Excel & MS Access using VBA (code, tables, queries, forms and modules, ActiveX controls), macros and VBA in Excel (2003 - 2007), reports in MS Report services (SQL Server based tool).

Confidential, Chicago, IL

Application Developer & Analyst - Consultant

Responsibilities:

• Create SQL Server database in, including tables, stored procedures, DTP, to store and manipulate with energy saving products data.
• Create front-end in Access to enter and tracking data.
• Create Access database and front-end tool to automatically upload data from different sources including plain text files, different Excel version files into Access and SQL Server database (ADO connectivity).
• Create energy saving calculation reports and products comparison between previous “non-green” and new LED lamps technology, develop custom reports in Access and Excel based on user’s requests.
• Create tool to for auto data migration from Quickbooks files to Access and SQL Server database. (VBA coding and QODBC 9.0).
• Create project documentation and user guides. Create presentation package in Power Point and Excel including animation. Provide end-user trainings and education on the customer’s sites. (VBA, MS Access, Business Objects, queries, OLE objects, reports, Excel, macros, formulas, charts, SQL - Server, stored procedures, data transfer packages, schedules).

Confidential, Chicago, IL

Data & Business analyst - Consultant

Responsibilities:

• Estimate timeframe and manage project developing and implementation.
• Create project presentation and data flow package in Power Point and provide presentation.
• Application calculate annual tax liability on which estimated tax and extension payments mast be made. Calculate liability for income and non-income based taxes, provide matrix Summary of information relevant to the preparation of estimated payment vouchers and other federal/SALT filings, including a summary of non-income-based taxes, payment due dates, forms to use, etc.
• Adjust calculations for the Treasury Department updates and regulations.
• Assist professionals to annualized income installment method. Package Excel- based application, includes formulas, macros, charts, VBA, interactive connections between federal and state tax calculation parts, protection, user’s guide and technical documentation.

Confidential, Chicago, IL

Data & Business analyst - Consultant

Responsibilities:

• Project developed for data management organization division for Confidential in multi-user environment.
• Collect end user requirements, generate user guide and manual.
• Create Automation raw data migration process from different sources, such as Excel files, Quick books, text files, etc. into SQL Server database using MS Access, VBA, macros, QODBC, PL SQL.
• Provided data clean-up process based on internal selection criteria, presentation in Power Point, including animation.
• Develop data entry and data manipulation front -end, with forms, data analysis formulas, using custom math formulas and internal company policy. Create reporting tool, for current monitoring financial activity, forecast and employee benefits, including graphs and charts.
• Create Access front-end and SQL server database, including security part front-end, based user’s levels, separate user’s access to different layers of information, security password parts, forms, queries and reports design, coding in Access, Excel, VBA and SQL, prepare tables, relationships, stored procedures, views, data transfer packages.
• Provide implementation, end-user training and education, including prepared in Power Point animation and presentation

Confidential, Bannockburn, IL

Team Lead - Consultant

Responsibilities:

• Data Warehousing and Improvement of several customer service existing Access applications and reports, using VBA, Excel, Macros, SQL SERVER, including automate data migration process from Access and Excel into SQL Server database.
• Design local electronic signature and password’s system. Rebuild old Access application versions, including front-end, back-end, queries, reports, VBA coding.
• Current system support and end user training based on new system changes.

Confidential, Oakbrook Terrace, IL

Developer - Data Analyst

Responsibilities:

• Automation reporting system process for CPA and CFA professional screening, using Oracle, Access, SQL queries, Discoverer, Excel, VBA, formulas and charts.
• Provide existing reports maintenance and adjusting for new report automation system.
• Develop new reports based on new company policy and requirements, using Access, Excel, VBA, macros, custom developed formulas, charts. Create back-end and front-end to enter report’s selection criteria and data manipulation.

Confidential, Hoffman Estates, IL

Business Analyst

Responsibilities:

• Reporting project using Microsoft Report Services, Crystal Reports, Visual Studio 2005, SQL Server 2005, XML, “.RDL” files project has been created to organize data migration & data flow from SQL Server 2000 into SQL Server 2005 environment and generate groups of reports including Ad Hoc reports.
• Provide clean up data and data migration from different sources .CSV, .XLS files into database.
• Project architecture and reports structure oriented to describe general and detailed company activities and tracking data by customer’s request in appropriate formats.
• Reports has been created for marketing groups, sales department, accounting and legal departments to make statistic and financial analysis. Including, store procedures, data transfer packages, charts and data math analysis by custom formulas, data validation procedure and testing, reports development and deployments into Web based application, collecting user requirements and end-user education & training.

Confidential, Deerfield, IL

Business Analyst

Responsibilities:

• Project has been created for marketing department to support Confidential marketing activity for new pharmaceutical products worldwide.
• Provide sale analysis by products, micro & macro components, regions, hospitals, hospitals departments, patient's ages et cetera using Visual Basic 6.0, VBA coding, Excel, macros, SDLC technologies, statistical analysis, and math formulas, SQL Server, Access 2003, reports, Ad Hoc reports, charts and Visio diagram.
• Convert Accounting Department existing, applications from Access 95 and Access 97 into Access 2003, transfer existing data into SQL Server using data transfer packages.
• Compare with another products sale using statistical analysis formulas and Confidential internal formulas as well. Convert and transfer data from different sources into database, develop and provide data validation.
• Developed front-end to analyze business process and sale represents reports domestic and worldwide.
• Application includes front- end in Visual Basic that read, analyze and store Visio files data in Access and SQL Server databases that has been created as well and included store procedures and data transfer packages.
• Prepare and provide presentation in Power Point for Confidential 's marketing team and customers, including animation. (VB 6.0, Access 2003, Visio, Excel, SQL Server 2000, Crystal Reports Power Point). A variety of tasks required generally involving analyzing business requirements, working with marketing to develop technical solutions, with Sourcing and Finance to work out costs forecasts/budget and pulling together overall timelines and solution into a management summary.
• Provide Confidential ’s domestic & foreign representative training and software user’s support as well.

Confidential, IL

Consultant

Responsibilities:

• Short term project for Sales Department. Existing sale analysis application maintenance and report system creating. Added extra formulas and new reports to evaluate sales activity and provide business analysis based on corporate standards. Technology part includes VBA, ActiveX objects, Access 2003, SQL Server, Excel, macros, Visio.

Confidential, Schaumburg, IL

Business Analyst - Consultant

Responsibilities:

• "Global Analysis Reports System". Project has been created for “Global Analysis Department” for automatically evaluation and estimate current and make prognosis for future sales activities by company products groups, by regions and worldwide as well. Generate reports using WebFOCUS, which turns the collected corporate data into the meaningful information, complemented with the web components for presenting the information, and interacting with the end-users.
• Analysis based on company standard requirements and contains math formulas and calculations.
• Project created from scratch, using SDLC model and included databases, front-end, testing, user guide documentation, implementation support and Data Warehousing .
• Tools and technology: Excel, macros, Access & SQL Server, Crystal Reports, Ad Hoc reports, VBA. WebFocus (FOCUS 4GL dialects).

Confidential, Waukegan, IL

Programmer - Consultant

Responsibilities:

• "Fisher Exact" - existing project modification provided for new sales requirements. Changed front- end forms and code to void source as text files.
• Created procedure to transfer data from text file into SQL Server database. Data Warehousing. Created new SQL Server database and store procedures. Created code to track and manipulate data based on sales results formulas and standards. For new database mapped source data tables and fields from other corporate databases, created procedure for data validation as well.
• Created new Excel report system. Application included SQL Server databases, Excel, VBA, Intranet report part in ASP, standard and custom financial math functions formulas and parameters.

Confidential, Lake Forest, IL

Business Analyst - Consultant

Responsibilities:

• "Building the profitability Model" has been created for financial department Confidential . Full circle of project included front and back ends, automation of data transfer and recalculation procedures, based on corporate standards and department management requirements to generate data and dynamic's reports, that shows sales department and customer's activity and profitability.
• Application included Oracle and Access databases, Excel, VBA, Crystal Reports, standard and custom financial math functions formulas and parameters. Also, provided final product testing in financial environment, implementation, end - user training and support. Application based on System Development Life Cycle parts such as Software Requirements Analysis, Systems Analysis and Design, Code Generation & Testing.

Confidential, Waukegan, IL

Data Analyst - Consultant

Responsibilities:

• PowerCenter & Medics” Project to make automation in process to generate Excel files from collected Visio charts files from insulin division customer service worldwide.
• Auto reading existing logic information on Visio files such as shapes, connectors, arrows and another objects, using chart’s logic to store this data in database. Using stored data auto creating Excel files in different formats, automatically replace Visio and Excel files into different directories based on management requirements.
• Using Siebel have created and executed Internet-based marketing campaigns, to identify and acquire new customers, and to develop customized product and service offerings that meet customer requirements and expectations and facilitate unassisted selling. Create and tested Siebel reports by managers requests to get on-demand access to critical real-time information through one single system containing financial, customer relationship management, manufacturing, and management control capabilities.
• Unit testing and auto data verification between original and created files. End - users training, guide documentation & implementation.
• Project created using VB6.0, VBA, Excel, Visio. Siebel, Access 2003, Oracle, Powerpoint and SDLC methodology.

Confidential, Waukegan IL

Programmer - Consultant

Responsibilities:

• ”CAPAR - Corrective and Preventive Actions”, based on Federal Drug Administration Requirements and SDLC requirements.
• Project created for the Quality Assurance Department and company different level management to generate all manufacture process quality control tracking & analyzing data and documentation including Customer Complaints investigation, Deviation Investigation, Recall Material Reports(including auto recalculation for different measure system parameters and shipping - receiving data), Multilevel Security System and Electronic Signature etc. for multi-user environment.
• Project created using VB 6.0, SQL Server, Access, OLE Objects, Excel and Charts (front- end & back- end, reports, user requirements documentation, education implementation and support).
• Created and set up custom security features including password, user id and electronic signature for a multi-user Access database. Database was fully protected and access depended on user’s level of permission.
• Data analyzing part of project included selection criteria determination list and reports based on queries and selection parameters.
• Product recall part of project included imbedded, custom designed math function to recalculate product quantity, volume, weight, terms of delivery and receiving.
• Used data migration tools to transfer existing data in Excel into Access tables and then into SQL Server tables. Prepare transfer data packages to synchronize data with different databases.
• Determine different user level and establish user connection using data mapping tools.
• Prepared project’s validation based on FDA and internal requirements.
• Created Power Point presentation materials for users and customers.
• Technical compliance documentation and auditing. Part of application has been created for Laboratories supporting stability, microbiology, and raw material testing.
• “Online Customer Complaint Handling System”. The project applies to all product complaints received (trough Ferro Pfanstiehl sales agents, directly from clients, or trough any other means).
• Project include featured SQL Server 2000 backend, MQ series, Core components written in C #, COM + enabled transactional components, ASP. NET, ADO. NET, XML/XSLT technology, and SOAP - based services.
• Designed XSLT Style Sheets were used to transform XML data into HTML output for end users.
• Created automatically generate quotation database and front-end for Sale Department.
• “Sign in & Actions” Project created for Quality Control & Chem. Lab Department rebuild existing plain Excel spreadsheets in Access front- end and SQL Server database.
• Project included Excel macros, charts and math functions, reports and password system.

Confidential, Waukegan, IL

Data Analyst - Consultant

Responsibilities:

• “Verifier” project created for Abbot Diagnostic Division, automatically analyze and validate corporate documents, based on corporate and international pharmaceutical and medical standards, using Visual Basic, ActiveX VB applications, Excel, macros and Excel objects, charts, Pivot tables and third party controls. This project is designed to provide all the objective evidence required by the governing documents. Provide implementation, user’s education and support.
• Validate Documentation Report” system. Troubleshooting incoming calls and create reports with Crystal Reports, created Access database as back end contains information about all validated documents, details and changes based on the company requirements and limitations. Create “Validate Report” system using Crystal Reports, macros and queries to track data by different parameters, users and Department management requirements.
• “Formula Analyzer” project was developed to assist in validation activities and test the
• Ability to find all formulas and determine which are “unique” formulas within a user Excel workbook. The user interface provided for the testing and documentation of each unique formula will also tested.

Confidential, Morris, IL

Programmer - Consultant

Responsibilities:

• "Lessons Learned" project using VB 6.0, ActiveX,, VB applications, created database in Access XP, using queries, macros, reports and Excel, Novell to perform an evaluation and remediation, testing and implementation, (Included front - end, back - end), user’s education and support.

Confidential, Schaumburg, IL

Programmer - Consultant

Responsibilities:

• Designed and implemented Package - Login and shipping systems for Laboratory and Shipping Department (Included front- end, back- end, installation and support).
• Created special based on Digit and Bar Code Labeling System program for Laboratory and Shipping Departments for each of tested and shipped specimen. (Included different Labels and Bar Code design, Bar coding & Bar Code reading system, front- end, back- end, installation and support).
• Developed Test - Processing subculture’s / drug’s system based on Aerobic/Anaerobic test’s environments (Included front- end, back-end, installation and support). Technical compliance, (Laboratories performing bio-analytical testing in support of non-clinical and clinical studies.)
• Created report’s front and back-end for Company’s management, based on company’s general and laboratory’s activities.
• Developed for Laboratory Manager and Laboratory Staff front and back- end, to create current test methods forms, documentation and test methods data entry system.
• Developed Trade Shows and trading applications to support Sales and Lab Departments efforts to market and ship organisms that are contained within their freezers. The application is a multi-parameter search feature, with several reports.
• Created automatically generate quotation database and front- end for Sale Department.
• Participated in redesign, maintenance and support existing company’s programs included Client Package Indexer and Exporter Systems, based n VB 6.0, ActiveX, SQL Server.

Confidential, Chicago, IL

Programmer - Consultant

Responsibilities:

• Created a scalable E–Commerce solution framework for Confidential –line Store–Front deployment. The NET – based application framework featured SQL Server 2000 backend, Core components written in C #, COM + enabled transactional components, ASP. NET, ADO. NET, XML/XSLT technology, and SOAP - based services.
• Participated in the design and implementation phase of core infrastructure and data access components written in C#.
• Designed and implemented web services that integrated the system with UPS – online services.
• Designed XSLT Style Sheets were used to transform XML data into HTML output for end users.
• Participated in Design and Development of Windows Based (Winforms) administrative screens.
• Participated in Design and Development of Web based forms used to manage and display information such as order, customer info and inventory.

Confidential, Calumet City, IL

Programmer– Consultant

Responsibilities:

• As team member designed back end based on Oracle, SQL Server, MS Access databases, Crystal Reports and developed front end for Data entry department, GUI forms and client information & finance / statistical analysis applications for Customer service department, using VB 6.0, ADO, RDO, MS Excel, report tools. Worked with Customer management on complex information issues. Applies improvement methodology to personal and team member performance.
• Participated in Design and Development of Windows Based (Winforms) administrative screens as the NET – based application framework featured SQL Server 2000 backend, Core components written in C #.
• Developed projects based on company business insurance strategy using VB 6.0, Oracle, Crystal Reports, created MS Access database and front applications for Legal Department. The application based on client status and status of submission of forms changes including reports and automatically transformed this reports to different users and managers. System was developed for multi – user environment and included database, GUI forms and reports.
• Developed using VB6.0, Oracle and MS Access applications for Health claims Department data processing. Established security and warning system for different management levels.
• Developed several classes and collections for existing applications, which model financial activities or utility companies, using VB 6.0 and Oracle database as backend.
• Responsibilities include requirements gathering, projects documentation, quality testing, fixing current problems in the existing parts of applications, operators and managers training.

Confidential, Chicago, IL

Business Analyst – Consultant

Responsibilities:

• Developed for Shipping Control Department timekeeping application using Primavera.
• Developed Statistic Analysis, trading application and Report System (Sales, Shipping, Data analysis, Graphs & Charts, Pivot tables).