Greetings!! This is* Mukesh* from *ASKIT Consulting* currently I am looking for* VBA Access. *Please go through requirements and send me profile ASAP * * *Position: VBA Access* *Location: NYC, NY* *Duration: 6+ months* *Job Description:* * Develop, automated and maintain analytical tools to support Corporate Compliance Control MIS and information for management decisions, observations and tracking. * Perform external and internal data extractions from key "authoritative source" systems * Prep and perform analysis on raw data extractions * Work with peers and all levels across the function and organization on implementation of strategy and programs, using cross-functional resources as needed * Participate in global, cross-regional standardization projects *Qualifications:* Must Have the Following Skills Microsoft Office. VBA for MS Office; should be able to program and run code for automation of ALL MS Office Products (specifics for Access and Excel listed below.) Microsoft Access. Access VBA Access SQL / ANSI SQL (nested queries, inline queries, pass-through queries, etc...) Expert knowledge in RDBMS (one-to-one, one-to-many, many-to-many, 3NF, BCNF, etc...) Understanding of Access design elements - Forms, Reports, Macros, etc.. Understanding of ADO library. Understanding of DAO library. Understanding of ODBC and other Microsoft connectivity standards. Microsoft Excel. Excel VBA Applicant should have very advanced knowledge of excel. Advanced pivot table and pivot chart construction. Very Advanced skills in creating Excel forms Advanced Microsoft Excel communication strategies with databases using Microsoft Query. Advanced Worksheet techniques for constructing business forms using ActiveX controls and form controls. Dashboard and Advanced Formula construction. Advanced skills for linking separate workbooks and worksheets. Advanced skills for linking with other applications (OLE). Advanced skills for importing text files. Advanced skills for sharing workbooks. Advanced skills for constructing time formulas on the worksheet. Advanced use of Goal Seek and Solver, etc... Misc Knowledge: knowledge of HTML helpful; Should understand how to fuse VBA with HTML (for report creation, dashboards, etc...) knowledge of Microsoft SharePoint services helpful. Understanding of lists, document libraries, user administration, etc... Knowledge of XML helpful (at least one of our processes uses XML to transfer data across various platforms) Business Requirements Bachelors degree required Experience in financial services preferred Prior experience in risk, analytics or MIS development Strong sense of accountability and decisiveness in a strong work ethic culture Demonstrated ability to synthesize, prioritize and drive results with a high sense of urgency Regards, *Mukesh Sharma* Technical Recruiter *Ask IT Consulting *You Ask We Deliver! Phone: 1-516-717-2086, Fax: 631-803-4488 Email: msha...@askitc.com URL: <http://www.askitc.com/>http://www.askitc.com -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To post to this group, send email to sap-or-oracle-financi...@googlegroups.com. To unsubscribe from this group, send email to sap-or-oracle-financials+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-or-oracle-financials?hl=en.