*Recruiter* kavita.mo...@careernet.co.in Hi,
Hope you find this mail in good spirits. We came across your profile on one of the job portal and found it interesting and prospective for one of our key clients. In further to this, we would like to discuss an opening with our clients in Gurgaon / Chennai. Job Description: Client:McKinsey Knowledge Centre Postion : Analyst Group: Data Analytics Team Exp :1-5 yrs. Location: Gurgaon / Chennai, India Qualifications: Post Graduate/Graduate in Computer Applications or MBA from reputed institute, and having a course in mathematics/statistics is a plus Or Graduate in any other stream with relevant IT related certifications (like, DOEACC "A" level, GNIIT) and having high programming and logical skills Skills: Skills/ Knowledge: Soft Skills Strong problem solving and logical skills Good written and verbal communication skills. Ability to work under pressure and deliver on tight deadlines. Ability to work in a team Energetic, cooperative and pleasant personality Hard Skills** Technical VBA Transforming a problem definition into an algorithm and translating into VBA Knowledge of MS Excel/MS Access objects, their properties and methods MS Access Designing complex and scalable databases Writing complex DDL and DML queries in MS Access Building interfaces using forms Building reports Importing data from various sources MS Excel Adept at writing formulas: performing data aggregation (sumif, countif), data cleaning (like trim, len, mid), data lookups (lookups, match, index) and cell references Pivot tables Importing data from various sources (like text files, CSVs, MS Access) Experience of data visualization tools like Tableau/ Xcelsius is good to have Basic understanding of Oracle/MS SQL Server or SPSS/SAS is good to have Knowledge of Agile (eXtreme Programming) is a plus About the Client : McKinsey Knowledge Centre McKinsey & Company, Inc. is a leading international management consulting firm with 89 offices in 50 countries. It is one of the most respected and renowned organisations in the world and has been consistently ranked as the leading employer of choice across the world. McKinsey Knowledge Centre is the hub of McKinsey"s global Knowledge Management capability. It works with McKinsey consulting teams across the globe. The Centre (located in Gurgaon and Chennai) has grown into McKinsey"s largest research unit, comprising of about 500 Knowledge Management professionals. Role Description: Main Responsibilities: Understanding requirements from our clients / consultants Problem solve and propose solutions depending upon given constraints Design/develop the agreed upon solution in MS Excel/ MS Access with VBA programming Deliver end products maintaining quick turn around times and highest quality standards execute quick turn around work in MS Excel/MS Access which involves VBA Build data intensive models / tools Provide assistance/guidance to other members in MS Excel/MS Access and VBA Kindly let us know your views, so that we can discuss further details on this. Meanwhile send across your updated profile and the following details 1)Total Experience: 2) Current CTC: 3) Expected CTC: 4) Notice Period: 5) Current Company 6) Working in current company since: 7) Employment (Contract/Permanant) : 8) Current Location : 9) Preferred Gurgaon / Chennai: Would appreciate if you pass this information to your colleagues and friends, who might be interested in this opening. Looking forward to hear from you soon. Note: This is a result of mass mailing being done, if skill sets donot match or already applied, kindly ignore the mail. Regards, Kavita Moger I Associate Consultant CareerNet Consulting | URL: www.careernet.co.in Email: kavita.mo...@careernet.co.in -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com