$$Excel-Macros$$ NetSuite Functional Consultant !! Hiring Now !!

2017-07-07 Thread Recruiter@CKI
*Hiring Now . Please Reply ASAP with your consultant resume
to akanahiy...@consultingknights.com *









*Job Title : NetSuite Functional Consultant Location : San Jose, CA (Need
Local / Nearby)Duration : 6+Months ContractPhone and Face to Face Interview
No visa restrictionsMust Haves*
Proven Hands-on (NetSuite) implementation experience required
Strong accounting experience
Strong experience in business process and internal controls
Problem solving capability
They need someone with a Finance and Accounting background who can assist
NetSuite and the users during the implementation.
They will essentially be doing implementation support, working with F
department directly helping them.
NetSuite will be doing all of the technical work while they work the
functional aspect of it.
This role is to work on behalf of the client during a brand-new NetSuite
ERP implementation to ensure the implementation being performed by Systems
Integrator will meet the business objectives and requirements.
Consultant will assist the Finance team with all the necessary finance
tasks during ERP implementation, including:
Map out the desired business process for the NetSuite ERP implementation
Assess ERP implementation business process for weaknesses & gaps and
recommend remediation or business process improvements, as necessary
Advise team with NetSuite best practices to streamline business process
Design and prepare test cases and support the Finance team in testing for
acceptance
Ensure business requirements are met when ERP goes live
Prepare chart of accounts and account mapping
Perform data clean up and validation for migration
Ability to work independently or in a team as required on the assigned
tasks and be responsive to the tasks
Proactively discuss the open issues/tickets and take the responsibility of
finding solutions in a timely manner.







*Regards,Kanhaiya JaiswalProfessional RecruiterConsulting Knights Inc,
Princeton, New Jersey |08540Phone : 609-423-4355 | Fax:  (609)
228-5321kanahiy...@consultingknights.com
www.consultingknights.com
*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Looking for Automation Test Lead @ Dallas, TX

2017-07-07 Thread Venkat Naredla
Hi,
Please find the below requirement & let me know your interest with updated
resume.

Job Description: Job Title - Technology Lead | Testing processes | Test
Automation Process Work Location & Address - Dallas TX 75204
Contract duration   - 6+
Target Start Date   - 01 Aug 2017

Job Details:

Must Have Skills
Tools automated testing tools such as jmeter Selenium Jenkins

Detailed Job Description
Test Automation Engineer. not exclusive to testing. More like multipurpose
automation engr. Could also be considered SCM role, or platform engr. Tools
automated testing tools such as jmeter, Selenium, Jenkins, shell scripting,
database manipulation and queries.

Desired years of experience
Above 5 years

Education/ Certifications
BE

Top 3 responsibilities you would expect the Subcon to shoulder and execute
Shell scripting Database manipulation and queries Multipurpose automation
engr

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Quality Consultant"at Ontario,CA@Locals And F2F

2017-07-07 Thread Mohammad Sazid
Hi ,

Hope you are doing great,
My Self, *Sazid* from R2 Technologies. We have a requirement for "*Quality
Consultant*"at *Ontario,CA*. Please review the Job description below and if
you’d like to pursue this, please include a word copy of your latest resume
along with a daytime phone number and rate in your response. You can
also reach me at *470-242-7345*301*, Drop the suitable profiles on
*saz...@r2techcorp.com
*


*Quality Consultant*
*Duration:* 7 months
*Location:* Ontario, CA
*Client UHG*
*Local candidates only*
*Need Senior profile.*

*Job Description:*
Responsibilities:
Uses risk based approach to identifying scope of testing. Creates test
plans, identifies test environments, dependencies, constraints, priority of
test cases and scheduled time for testing
Creates and executes complex SQL queries
Responsible for ensuring end to end testing methodology is followed,
including all appropriate documentation and requirements
Sets up or validates the set software and data in the test environment, per
specs
Ensures test results are accurate, thorough and appropriately documented
Communicates results and coordinates with Project Managers, Business and
Systems Analysts, Developers, and other key IT staff and leadership as
appropriate
Documents problems or results inconsistent with expected results
Signs off on application for release to the next testing stage or to the
production environment
Generates and distributes periodic status reports for testing
Sets up and executes complex scripts independently
Writes/coordinates resolution of system defects
Participates in requirements gathering sessions or solicits information on
incomplete requirements
Participates in facilitation and coordination of user acceptance testing
Skills required:
Associates degree in an IT related field or equivalent work experience
A minimum of three years of work experience in business and/or system
testing
Must have strong knowledge of SDLC with an emphasis on testing methodologies
Ability to quickly & thoroughly understand As-Is and To-Be business
processes to understand what's changing
Ability to communicate with the business in business language and with
developers in technical language
Must have strong PC skills and demonstrated proficiency in the MS Office
Suite products
Should have prior work experience with testing management tools and concepts
Ability to read logical and physical data models and understand the
relationship between various tables
Ability to clearly identify data needs and requirements for the respective
test efforts
*Ability to read various system input/output files like XML, Flat files,
ANSI 834, 835 etc. **�*
*Preferred Qualifications:*
*Experience in the healthcare domain with exposure to Claims Processing
applications and business flows*
*Experience with use cases and user stories*
*Exposure to Agile / Lean Methodology*
*Experience participating in Joint Application Design (JAD) sessions*

Thanks & Regards,
*Mohammad Sazid*

*Email*: saz...@r2techcorp.com

*Direct:* 470-242-7345 ex *301*

*Work*: 248-522-7855|*Fax:* (248) 479-5559
*R2 Technologies GA LLC*
6515 Shiloh Rd, Unit 110, Alpharetta,GA 30005

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Sr .Net Programmer"at Lansing,MI@ F2F

2017-07-07 Thread Mohammad Sazid
Hi ,

Hope you are doing great,
My Self,* Sazid* from R2 Technologies. We have a requirement for "*Sr* *.Net
Programmer*"at *Lansing,MI*. Please review the Job description below and if
you’d like to pursue this, please include a word copy of your latest resume
along with a daytime phone number and rate in your response. You can
also reach me at *470-242-7345*301*, Drop the suitable profiles on
*saz...@r2techcorp.com
*



*Title: Sr .Net Programmer*

*Location: Lansing,MI*

*Duration: 1 year Contract*

*Interview: F2F*





*Required Skills: *

Jquery, Oracle, SQL Server, Microsoft MVC framework Razor, CSS, Multi-Tier
Architecture and .Net





*Years of Experience:*  5 or more years of experience in the field.

*Job Description: *Work collaboratively in an Agile team to deliver high
quality source code to meet business needs.



   - Read user stories and implement code to meet acceptance criteria with
   attention to detail. Review and improvise code as necessary.
   - Create automated unit tests, Translate clients' business requirements
   and objectives into innovative technical applications and solutions.
   - Interact with clients to determine their requirements and needs.
   Understand and evaluate complex data models.
   - Develop solutions to improve performance and scalability of systems.
   Work in Agile iterations to deliver business value in short timeframes.
   - Converts data from project specifications and statements of problems
   and procedures to create or modify computer programs.
   - Prepares or receives detailed specifications to describe sequence of
   steps that program must follow and input, output and logical operations
   involved. Analyzes specifications, applying knowledge of computer
   capabilities, subject matter and symbolic logic.
   - Confers with supervisor and representatives of departments concerned
   with program to resolve questions of program intent, data input, output
   requirements and inclusion of internal checks and controls.
   - Converts detailed specifications to language that can be processed by
   computer. Enters program codes into computer system. Inputs test data into
   computer. Observes computer monitor screen to interpret program operating
   codes.
   - Corrects program errors, using methods such as modifying program, or
   altering sequence of program steps.
   - May prepare computer block diagrams and machine logic flowcharts for
   detailed coding of problems, and provides for the documentation of
   programming work.





*Skill*

*Required /Desired*

*Amount of Experience*

*Expertise Rating*

Bachelors Degree in a technical area such as mathematics, computer science,
engineering or information systems

Required

5



Experience with web development in JavaScript including JQuery

Required

5



Experience with web development and an Oracle or SQL Server backend

Required

3



Experience in object oriented programming

Required

6



Experience writing SQL Server queries and stored procedures

Required

3



Experience writing entity framework data access

Required

2



Experience with Microsoft's MVC 4.0 or higher framework including razor

Required

3



Experience with cascading style sheets and bootstrap

Required

5



Demonstrated knowledge and experience developing all levels of an n-tier
application

Required

5



Experience using test driven development

Required

1



Excellent verbal and written communication skills

Required

5



Experience with Angular application framework

Desired

1




Thanks & Regards,
*Mohammad Sazid*

*Email*: saz...@r2techcorp.com

*Direct:* 470-242-7345 ex *301*

*Work*: 248-522-7855|*Fax:* (248) 479-5559
*R2 Technologies GA LLC*
6515 Shiloh Rd, Unit 110, Alpharetta,GA 30005

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit 

$$Excel-Macros$$ Business Analyst Reports"at Duluth,GA

2017-07-07 Thread Mohammad Sazid
Hi ,

Hope you are doing great,
My Self, *Sazid* from R2 Technologies. We have a requirement for "*Business
Analyst Reports*"at *Duluth,GA*. Please review the Job description below
and if you’d like to pursue this, please include a word copy of your latest
resume along with a daytime phone number and rate in your response. You can
also reach me at* 470-242-7345*301*, Drop the suitable profiles on
*saz...@r2techcorp.com
*


*Business Analyst Reports (Hyperion/ VBA)*
*Location: Duluth GA*
*Duration: 6 months*


*Position Summary:*
This position demands strong inter personal skills for developing solutions
in FP (Financial Planning and Analytics) space using Microsoft Excel,
Hyperion Planning, Essbase, HFM, and DRM within the IT Business
Infrastructure Systems delivery organization. The right candidate needs to
have a very strong excel and VBA coding skills with ability to model
business scenarios with a short turnaround time. Prior support experience
in the FP space is a plus. The candidate will be responsible for business
requirements gathering, functional analysis, deployment, and support of
software applications for business functions in major areas of the business
and enterprise wide.  This position will focus as the liaison with
stakeholders to elicit, analyze, communicate, and validate requirements for
changes to business processes, policies, and information systems. They work
closely with customers, colleagues, suppliers, and other stakeholders to
define user requirements and provide integrated solutions based upon
customized computer architecture and applications.  They apply their
expertise to improve business processes and support critical business
strategies, as they seek out opportunities to educate customers in the
strategic use of technology.

*Key Areas of Responsibility*
·Develop Excel/ VBA  based solution in the FP Space
·Liaison with the business stakeholders to gather business
requirements.
·Converting business requirements to functional specifications and
communicating these to software development teams.
·Constructing applications which meet or exceed requirements,
promote re-use of software components, and facilitate ease  of
support.
·Conducting unit tests, component integration tests, systems and
acceptance testing, correcting problems, and implementing changes to ensure
adherence to test plan and functional requirements.
·Coordinating issue resolution with software vendors
·Preparing or providing input to written documentation for
technical methods, procedures, functions, or processes to  support
the installation, operations, training, and maintenance of information
technology systems or applications.
·Creating and managing the application deployment project plan.
·Specifying and maintaining the required deployment and testing
environment.
·Designing and developing test procedures which enumerate the
conditions to be tested.
·Participating in system and acceptance testing and deployment
readiness testing.
·Rolling out the processes and the systems which support them.
·Training
·Evaluating results, correcting problems, and eliminating defects
to ensure adherence to test plan.
·Providing ongoing support for the application.

*Basic Requirements:*
·Bachelor’s Degree in MIS or Finance
·5 years’ experience as a IT Business Analyst or Finance Analyst
·Advanced knowledge in Microsoft Excel, including VBA for Excel
·Experience providing end user support in an IT setting
·Experience with end user training including the preparation/lead
of formal training and information sessions
·Extensive financial process and functional knowledge
·Demonstrated problem solving abilities
·Excellent verbal and written communication skills
·Flexibility in a rapidly changing environment; Ability to work
non-standard hours when required.
·Ability to multitask and handle multiple projects at same time

*Preferred Requirements:*
·Proficient in Hyperion Smart View and Financial Reporting Studio
·Experience working with a geographically distributed team
·Microsoft Office (Word, PowerPoint, EXCEL, Outlook)
·Experience with Hyperion Essbase a plus
·Exposure to Oracle Data Relationship Management (DRM) a plus


Thanks & Regards,
*Mohammad Sazid*

*Email*: saz...@r2techcorp.com

*Direct:* 470-242-7345 ex *301*

*Work*: 248-522-7855|*Fax:* (248) 479-5559
*R2 Technologies GA LLC*
6515 Shiloh Rd, Unit 110, Alpharetta,GA 30005

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, 

$$Excel-Macros$$ Looking for Business Analyst (functional) @ Cary, NC

2017-07-07 Thread Venkat Naredla
Hi,
Please find the below requirement & let me know your interest with updated
resume.

ECMS Request Number* 153867

Job Title*  Senior Consultant | Analytics - Functional | Business
Analyst

Work Location & Address*CaryNC27511

201 MetLife Way, Cary, NC, USA

Contract duration (in months)*  6+
Target Start Date*  17 Jul 2017

Job Details: Support requirement workshops, help define the problem
statement, provide solution alternatives, create detailed design
documentation, implement deployment plan, and support knowledge transfer
with the objective of providing high-quality and value-adding consulting
solutions to customers within the guidelines, policies and norms of Infosys.

Must Have Skills (Top 3 technical skills only) * 1. BI reporting 2.
Requirement Gathering & Reporting 3. Offshore coordination

Detailed Job Description:
1. Working with business for requirement analysis and provide solution, 2.
coordinating with offshore for end to end devolopement

Education/ Certifications (Required):
BE or equivalent
Top 3 responsibilities you would expect the Subcon to shoulder and execute*:
1. Business Analysis
2. Requirement Gathering  Reporting
3. Offshore coordination for end to end devolopement Will the candidate be
client facing and/or working with business users?
Yes

-- 


Thanks & Regards,



*Venkat*

*SRS Consulting Inc.*

Direct: 510-256-5887

Email: venkata.nare...@srsconsultinginc.com

Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills 1618 Title III passed by the 105th U.S. Congress, this mail
cannot be considered Spam as long as we include contact information and a
method to be removed from our mailing list. To be removed from our mailing
list, please reply with "REMOVE" in the subject line and your email address
in the body. Include Complete Address and/or Domain/Aliases to be removed.
We sincerely regret any inconvenience. The recipient should check this
email and any attachments for the presence of viruses. The company accepts
no liability for any damage caused by any virus transmitted by this email.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Excel Macro to copy data from Word

2017-07-07 Thread Secret Shot
Hi Folks,

I really need your help, in a case i am working.

I am getting data in a word file, and i need a macro which can open that
word file using "Getfilename" option, then copy all data from that file and
paste into a excel sheet (Paste special).

I am trying below code but it is not working. So experts please help.

Kindly Help.. . . . .


Sub ImportWordTable()

Dim wdDoc As Object
Dim wdFileName As Variant

On Error Resume Next

ActiveSheet.Range("A:AZ").ClearContents

wdFileName = Application.GetOpenFilename("Word files (*.docx),*.docx", , _
"Browse for file containing table to be imported")

If wdFileName = False Then Exit Sub

Set wdDoc = GetObject(wdFileName)
wdDoc.Visible = True


With wdDoc.Selection
.WholeStory
.Copy

End With

ThisWorkbook.Sheets("Get Data").Range("A1").PasteSpecial xlPasteValues
End Sub


-- 
Pankaj Pandey
Bhopal

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Java Developer with Jboss Fuse Experience !! IMMEDIATE NEED !!

2017-07-07 Thread Recruiter@CKI
*IMMEDIATE NEED .. Please Reply ASAP with your
consultant resume to kanahiy...@consultingknights.com
*





*Job Title : Java Developer with Jboss Fuse ExperienceLocation : Boca
Raton, FL (near Ft. Lauderdale, FL)Duration : 12 Months
Contract RESPONSIBILITIES: *
Collaborate with IT and Business teams to ensure the applications are
integrated successfully and enterprise services are established respecting
the principles of Service Oriented Architecture.
Lead project engagement to define integration objectives and requirements.
Design, document, develop and test integration services using Java EE,
REST, SOAP and JMS using Apache Camel.
The candidate needs to have strong knowledge of leveraged Apache Camel for
enterprise integrations.
Assist with operational and production support, being responsible for
satisfactory resolution.
Design and code reviews with EAI Delivery resources
Provide EAI Delivery strategic Leadership

*QUALIFICATIONS: *
Bachelor of Science in Computer Science.
8+ years of development
Minimum of 5 years of experience with: Java EE, JMS, Web Services, REST and
JSON
Minimum 2 years’ experience with Apache Camel, SOAPUI, Git/Subversion and
Jenkins or Hudson.
Experience with Red Hat JBOSS Fuse
Experience with Unix/Solaris and Oracle/MSSQL/DB2 databases.
Strong analytical and problem solving skills.
Strong oral and written communication skills and a team player.
Development experience with WS-Security, SOA Governance, and Web Service
Management tools.
Experience in integrating with AS400 and Mainframe through MQ Series.







*Regards,Kanhaiya JaiswalProfessional RecruiterConsulting Knights Inc,
Princeton, New Jersey |08540Phone : 609-423-4355 | Fax:  (609)
228-5321kanahiy...@consultingknights.com
www.consultingknights.com
*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Mid Level Business Analyst !! Hiring Now !!

2017-07-07 Thread Recruiter@CKI
*Hiring Now .. Please Reply ASAP with your consultant
resume to kanahiy...@consultingknights.com
*





*Job Title : Mid Level Business Analyst Location : Miami, FL (SOUTH FLORIDA
CANDIDATES ONLY)Duration : 6-12 Months ContractMUST HAVES:*
At least 4 years of Business Analysis
Experience working on several IT Projects simultaneously
Ideally someone with QA or Security project experience
Process mapping







*Regards,Kanhaiya JaiswalProfessional RecruiterConsulting Knights Inc,
Princeton, New Jersey |08540Phone : 609-423-4355 | Fax:  (609)
228-5321kanahiy...@consultingknights.com
www.consultingknights.com
*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Sr. Project Manager with GxP & Infrastructure Experience !! Hiring Now !!

2017-07-07 Thread Recruiter@CKI
*Hiring Now . Please Reply ASAP with your consultant resume
to kanahiy...@consultingknights.com *







*Job Title : Sr. Project Manager with GxP & Infrastructure
ExperienceLocation : Foster City, CADuration : 6+Months ContractAll they
need is extensive GxP experience as well as infrastructure experience. Just
a knowledge of AWS will work for this now. Notes:*
looking for a Sr. PM, with a MINIMUM of 7-10 years experience
must have solid GxP/validation experience
must have IT pharma PM's with cloud project experience
must have any AWS or cloud experience
looking for an IT PM who has worked in the pharma space
NEEDS to be able to DRIVE projects
must have great communication skills, be able to work with all levels
PMP a plus

*Job Responsibilities*
Manage one or more work streams on a major program for our Pharmaceutical
Development and Manufacturing (PDM) group.
Assist in providing training/coaching on project management principles
where appropriate to our stakeholders (business owners, System managers,
validation engineers, etc.)
Create appropriate project plans and work schedules to meet business
objectives and priorities
Provide an ongoing assessment and management of project risks and determine
actions necessary to mitigate risks
Track and help resolve project issues
Provide regular project plan updates and status reporting on financial and
delivery progress, including weekly executive dashboards
Lead project communications activities to the stakeholders
Collaborate with other IT groups involved in the project delivery process
Assure, through monitoring and project oversight, that project delivery is
on-time and within budget; identifying, tracking, reporting, and escalating
issues as appropriate
Coordinate the delivery of training with business systems users and IT
Facilitate post implementation project reviews and the incorporation of
lessons learned back into principles, policies, practices and the in-house
knowledge base








*Regards,Kanhaiya JaiswalProfessional RecruiterConsulting Knights Inc,
Princeton, New Jersey |08540Phone : 609-423-4355 | Fax:  (609)
228-5321kanahiy...@consultingknights.com
www.consultingknights.com
*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Job offer for Sr .Net Programmer"at Lansing,MI@ F2F only

2017-07-07 Thread Mohammad Sazid
Hi ,

Hope you are doing great,
My Self,* Sazid* from R2 Technologies. We have a requirement for "*Sr* *.Net
Programmer*"at *Lansing,MI*. Please review the Job description below and if
you’d like to pursue this, please include a word copy of your latest resume
along with a daytime phone number and rate in your response. You can
also reach me at *470-242-7345*301*, Drop the suitable profiles on
*saz...@r2techcorp.com
*



*Title: Sr .Net Programmer*

*Location: Lansing,MI*

*Duration: 1 year Contract*

*Interview: F2F*





*Required Skills: *

Jquery, Oracle, SQL Server, Microsoft MVC framework Razor, CSS, Multi-Tier
Architecture and .Net





*Years of Experience:*  5 or more years of experience in the field.

*Job Description: *Work collaboratively in an Agile team to deliver high
quality source code to meet business needs.



   - Read user stories and implement code to meet acceptance criteria with
   attention to detail. Review and improvise code as necessary.
   - Create automated unit tests, Translate clients' business requirements
   and objectives into innovative technical applications and solutions.
   - Interact with clients to determine their requirements and needs.
   Understand and evaluate complex data models.
   - Develop solutions to improve performance and scalability of systems.
   Work in Agile iterations to deliver business value in short timeframes.
   - Converts data from project specifications and statements of problems
   and procedures to create or modify computer programs.
   - Prepares or receives detailed specifications to describe sequence of
   steps that program must follow and input, output and logical operations
   involved. Analyzes specifications, applying knowledge of computer
   capabilities, subject matter and symbolic logic.
   - Confers with supervisor and representatives of departments concerned
   with program to resolve questions of program intent, data input, output
   requirements and inclusion of internal checks and controls.
   - Converts detailed specifications to language that can be processed by
   computer. Enters program codes into computer system. Inputs test data into
   computer. Observes computer monitor screen to interpret program operating
   codes.
   - Corrects program errors, using methods such as modifying program, or
   altering sequence of program steps.
   - May prepare computer block diagrams and machine logic flowcharts for
   detailed coding of problems, and provides for the documentation of
   programming work.





*Skill*

*Required /Desired*

*Amount of Experience*

*Expertise Rating*

Bachelors Degree in a technical area such as mathematics, computer science,
engineering or information systems

Required

5



Experience with web development in JavaScript including JQuery

Required

5



Experience with web development and an Oracle or SQL Server backend

Required

3



Experience in object oriented programming

Required

6



Experience writing SQL Server queries and stored procedures

Required

3



Experience writing entity framework data access

Required

2



Experience with Microsoft's MVC 4.0 or higher framework including razor

Required

3



Experience with cascading style sheets and bootstrap

Required

5



Demonstrated knowledge and experience developing all levels of an n-tier
application

Required

5



Experience using test driven development

Required

1



Excellent verbal and written communication skills

Required

5



Experience with Angular application framework

Desired

1

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Job offer for Business Analyst Reports"at Duluth,GA

2017-07-07 Thread Mohammad Sazid
Hi ,

Hope you are doing great,
My Self, *Sazid* from R2 Technologies. We have a requirement for "*Business
Analyst Reports*"at *Duluth,GA*. Please review the Job description below
and if you’d like to pursue this, please include a word copy of your latest
resume along with a daytime phone number and rate in your response. You can
also reach me at* 470-242-7345*301*, Drop the suitable profiles on
*saz...@r2techcorp.com
*


*Business Analyst Reports (Hyperion/ VBA)*
*Location: Duluth GA*
*Duration: 6 months*


*Position Summary:*
This position demands strong inter personal skills for developing solutions
in FP (Financial Planning and Analytics) space using Microsoft Excel,
Hyperion Planning, Essbase, HFM, and DRM within the IT Business
Infrastructure Systems delivery organization. The right candidate needs to
have a very strong excel and VBA coding skills with ability to model
business scenarios with a short turnaround time. Prior support experience
in the FP space is a plus. The candidate will be responsible for business
requirements gathering, functional analysis, deployment, and support of
software applications for business functions in major areas of the business
and enterprise wide.  This position will focus as the liaison with
stakeholders to elicit, analyze, communicate, and validate requirements for
changes to business processes, policies, and information systems. They work
closely with customers, colleagues, suppliers, and other stakeholders to
define user requirements and provide integrated solutions based upon
customized computer architecture and applications.  They apply their
expertise to improve business processes and support critical business
strategies, as they seek out opportunities to educate customers in the
strategic use of technology.

*Key Areas of Responsibility*
·Develop Excel/ VBA  based solution in the FP Space
·Liaison with the business stakeholders to gather business
requirements.
·Converting business requirements to functional specifications and
communicating these to software development teams.
·Constructing applications which meet or exceed requirements,
promote re-use of software components, and facilitate ease  of
support.
·Conducting unit tests, component integration tests, systems and
acceptance testing, correcting problems, and implementing changes to ensure
adherence to test plan and functional requirements.
·Coordinating issue resolution with software vendors
·Preparing or providing input to written documentation for
technical methods, procedures, functions, or processes to  support
the installation, operations, training, and maintenance of information
technology systems or applications.
·Creating and managing the application deployment project plan.
·Specifying and maintaining the required deployment and testing
environment.
·Designing and developing test procedures which enumerate the
conditions to be tested.
·Participating in system and acceptance testing and deployment
readiness testing.
·Rolling out the processes and the systems which support them.
·Training
·Evaluating results, correcting problems, and eliminating defects
to ensure adherence to test plan.
·Providing ongoing support for the application.

*Basic Requirements:*
·Bachelor’s Degree in MIS or Finance
·5 years’ experience as a IT Business Analyst or Finance Analyst
·Advanced knowledge in Microsoft Excel, including VBA for Excel
·Experience providing end user support in an IT setting
·Experience with end user training including the preparation/lead
of formal training and information sessions
·Extensive financial process and functional knowledge
·Demonstrated problem solving abilities
·Excellent verbal and written communication skills
·Flexibility in a rapidly changing environment; Ability to work
non-standard hours when required.
·Ability to multitask and handle multiple projects at same time

*Preferred Requirements:*
·Proficient in Hyperion Smart View and Financial Reporting Studio
·Experience working with a geographically distributed team
·Microsoft Office (Word, PowerPoint, EXCEL, Outlook)
·Experience with Hyperion Essbase a plus
·Exposure to Oracle Data Relationship Management (DRM) a plus


Thanks & Regards,
*Mohammad Sazid*

*Email*: saz...@r2techcorp.com

*Direct:* 470-242-7345 ex *301*

*Work*: 248-522-7855|*Fax:* (248) 479-5559
*R2 Technologies GA LLC*
6515 Shiloh Rd, Unit 110, Alpharetta,GA 30005

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, 

$$Excel-Macros$$ Job Offer for Quality Consultant"at Ontario,CA

2017-07-07 Thread Mohammad Sazid
Hi ,

Hope you are doing great,
My Self, *Sazid* from R2 Technologies. We have a requirement for "*Quality
Consultant*"at *Ontario,CA*. Please review the Job description below and if
you’d like to pursue this, please include a word copy of your latest resume
along with a daytime phone number and rate in your response. You can
also reach me at *470-242-7345*301*, Drop the suitable profiles on
*saz...@r2techcorp.com
*


*Quality Consultant*
*Duration:* 7 months
*Location:* Ontario, CA
*Client UHG*
*Local candidates only*
*Need Senior profile.*

*Job Description:*
Responsibilities:
Uses risk based approach to identifying scope of testing. Creates test
plans, identifies test environments, dependencies, constraints, priority of
test cases and scheduled time for testing
Creates and executes complex SQL queries
Responsible for ensuring end to end testing methodology is followed,
including all appropriate documentation and requirements
Sets up or validates the set software and data in the test environment, per
specs
Ensures test results are accurate, thorough and appropriately documented
Communicates results and coordinates with Project Managers, Business and
Systems Analysts, Developers, and other key IT staff and leadership as
appropriate
Documents problems or results inconsistent with expected results
Signs off on application for release to the next testing stage or to the
production environment
Generates and distributes periodic status reports for testing
Sets up and executes complex scripts independently
Writes/coordinates resolution of system defects
Participates in requirements gathering sessions or solicits information on
incomplete requirements
Participates in facilitation and coordination of user acceptance testing
Skills required:
Associates degree in an IT related field or equivalent work experience
A minimum of three years of work experience in business and/or system
testing
Must have strong knowledge of SDLC with an emphasis on testing methodologies
Ability to quickly & thoroughly understand As-Is and To-Be business
processes to understand what's changing
Ability to communicate with the business in business language and with
developers in technical language
Must have strong PC skills and demonstrated proficiency in the MS Office
Suite products
Should have prior work experience with testing management tools and concepts
Ability to read logical and physical data models and understand the
relationship between various tables
Ability to clearly identify data needs and requirements for the respective
test efforts
*Ability to read various system input/output files like XML, Flat files,
ANSI 834, 835 etc. **�*
*Preferred Qualifications:*
*Experience in the healthcare domain with exposure to Claims Processing
applications and business flows*
*Experience with use cases and user stories*
*Exposure to Agile / Lean Methodology*
*Experience participating in Joint Application Design (JAD) sessions*

Thanks & Regards,
*Mohammad Sazid*

*Email*: saz...@r2techcorp.com

*Direct:* 470-242-7345 ex *301*

*Work*: 248-522-7855|*Fax:* (248) 479-5559
*R2 Technologies GA LLC*
6515 Shiloh Rd, Unit 110, Alpharetta,GA 30005

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-07 Thread 'Margareta Tolliver' via MS EXCEL AND VBA MACROS


On Fri, 7/7/17, Puttu *  wrote:

 Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
 To: "MS EXCEL AND VBA MACROS" 
 Date: Friday, July 7, 2017, 2:18 PM
 
 Hi Swapnil,
 
 Just to let you know all your comments
 should be based on the error code.
 
 Error Code column
 1
 2
 3
 
 all these three has
 different error description.
 
 Thanks
 Putta
 
 On Thu, Jul 6, 2017 at 7:14
 PM, Puttu * 
 wrote:
 Hi Swapnil,
 
 Thanks you so much
 appreciate your time and help on getting this macro. I think
 got almost what required, there is only small changes, which
 need to be done. Sorry its my mistake not giving right
 information on that.
 
 The reason I am looking a macro is I
 can't educate others who are very beginning stage of
 learning. Macro will be more easier for them to use than
 conditional formatting.
 
 I have added my comments in Final Tab.
 Please review and let me know if any points are unclear.
 
 Thanks
 Putta
 
 
 On Wed, Jul 5, 2017 at 2:18
 PM, Swapnil Palande 
 wrote:
 Hi,
 
 Why are you not using conditional
 formatting. If your main purpose is to display user
 duplicates and empty cells, conditional formatting is best
 solution.
 
 Have
 applied both solutions (conditional formatting as well as
 macro) in attached excel.
 
 Regards,
 Swapnil.
 
 On Wed, Jul 5, 2017 at
 12:24 AM, Puttu * 
 wrote:
 anyhelp please
 
 On Tue, Jul 4, 2017 at
 12:33 PM, Puttu * 
 wrote:
 Thanks Sir, Formula match exactly my
 requirement, however I have more than 50 columns, quite
 difficult to input formula for every column. Thus the reason
 I am looking for macro.
 
 Please help
 
 On Tue,
 Jul 4, 2017 at 11:21 AM, Swapnil Palande 
 wrote:
 Hi,
 
 No need of macro, you can do it using
 formulas also. Attached is the excel for your reference.
 
 Regards,
 Swapnil
 On Tue, Jul 4, 2017 at
 10:36 AM, Puttu * 
 wrote:
 Experts, Any help on this will be much appreciated
 
 
 On Mon, Jul 3, 2017 at
 10:33 PM, Puttu * 
 wrote:
 Hi Experts
 
 Please help on this.
 
 Thanks
 Putta
 
 On Mon,
 Jul 3, 2017 at 9:42 PM, Puttu * 
 wrote:
 Hi Experts,
 
 I am not a vba expert
 and need your help me on the attached requirement. 
 
 I have list of columns
 and from that I need to know based on the Model No. column
 filter if the other columns have any duplicate values, if
 yes then it should display comments column as Column Name
 + duplicate value (Ex: Category_description having duplicate
 value)
 
 2. If the
 any of the column is blank it should print Column Name is
 blank (Ex: Parent Category ID has blank value).
 
 Attached is the sample
 spread sheet. Please review and help me on it.
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 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) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@googl
 egroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/grou
 p/excel-macros.
 
 For more options, visit https://groups.google.com/d/op
 tout.
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 Putta
 
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discu
 ssexcel
 
  
 
 FORUM RULES
 
  
 
 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) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 

$$Excel-Macros$$ Tableau Developer / Reporting Analyst !! IMMEDIATE NEED !!

2017-07-07 Thread Recruiter@CKI
*Hiring Now  Please Reply ASAP with your consultant
resume to kanahiy...@consultingknights.com
*











*Job Title : Tableau Developer / Reporting Analyst Location : Foster City,
CA (Need Local/Nearby)Duration : 6+Months ContractPhone and Face to Face
InterviewRate : 45/hr on C2CNo visa restrictionsNotes:*
looking for at least 4 years experience using tools like Spotfire or
tableau with these tools
will be working in the QA PDM area so MUST HAVE RECENT pharma (reporting)
experience
must have great communication skills, work in a fast-paced environment
must be able to pick up things quickly

*Qualifications/Skills:*
At least 4 years experience with developing, deploying and maintaining
reports using such tools as: Spotfire or Tableau
Experience in pharmaceutical specific reporting
Excellent IT documentation skills.
Strong troubleshooting skills: logical and creative problem-solving skills.
Strong organizational, communication and documentation skills
Ability to work under pressure, independently or in a group.
Strong technical, customer service and communication skills.
Bachelor's degree or experience will be considered in place of degree.







*Regards,Kanhaiya JaiswalProfessional RecruiterConsulting Knights Inc,
Princeton, New Jersey |08540Phone : 609-423-4355 | Fax:  (609)
228-5321kanahiy...@consultingknights.com
www.consultingknights.com
*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Fwd: Hot List

2017-07-07 Thread raju bakrewar
Hi Friends, Greetings for the day, Please find the list of skilled
R2Technologies LLC consultants who are actively looking for new role and
please share your requirements to ra...@r2techllc.com



S.No CANDIDATE SKILL SET EXPERIENCE  LOCATION RELOCATION
1 Syed  .Net Developer 8+ Plano,TX YES
2 Sushma  Salesforce Administrator 5 Atlanta,GA Yes
3 Venu  UI Developer 5+ Chicago, IL Yes
4 Krishna UI Developer 6 Orlando, FL  Yes
5 Vijaya S Oracle SQL Developer 9 Stamford, CT Yes
6 Bharadwaj UI Developer 6 Atlanta,GA Yes
7 Sriram UI Developer 5 Atlanta,GA Yes
8 Mahendra  Unix/Hadoop Admin 10+ Reston, VA Yes
9 Sandeep .Net developer 10 New York, NY Yes
10 Rohit UI Developer with Quickview 5+ Atlanta, GA Yes
11 Abdul  Java Developer 5+ Nyc,NY Yes
12 Venkata P Devops Developer 8+ Elkridge, MD Yes
19 Venkata T Oracle developer 6 Baltimore, MD Yes
20 Sairam DB2 UDB Developer 8 Phoenix,AZ Yes
21 Prasana   WMB\IIB Developer 8+ Tenesse,NV Yes
22 Ramesh  QA lead  10+ Detroit,MI Yes
23 Kiran  SOA Developer 9+ Altlanta,GA YES
25 Sanjay Java Architect 13+ Philadelphia,PA YES
26 Ashok .Net Developer 9 Mooresville,NC YES
27 Raghu UI Developer 6 Farmington,MI Yes
28 Rajendra Babu Lead/Sr. JAVA_J2EE Developer 10 Chicago, IL YES
29 Bhargavi P UI Developer 7+ New York, NY YES
30 Akshay Ruby on Rails Developer 10+ Nevada,Carsoncity YES
31 Spoorthy IOS Application Developer 6 Dallas,TX YES
32 Padma Oracle DBA 10 New York, NY YES



*Thanks & Regards,*

*Raju | Recruiter *

*Email: ra...@r2techcorp.com Desk:470-242-7345
EXT-305 | Direct:248-522-7855*

*R2 Technologies GA LLC*
*6515 Shiloh Rd, Unit 110, **Alpharetta, GA 30005*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Fwd: Result Based Formula

2017-07-07 Thread Munir Ahmad
Pls find the attached excel file it is self explanatory.

Regards,
Muneer,
CCC...
-- Forwarded message --
From: "Muneer Ahmed" 
Date: Jul 5, 2017 3:35 PM
Subject: Fwd: Result Based Formula
To: "Munir Ahmad" 

Please find the Raw Data available in the sheet.
The sheet itself is self explanatory.

-- Forwarded message --
From: Muneer Ahmed 
Date: Wed, Jul 5, 2017 at 3:31 PM
Subject: Result Based Formula
To: Munir Ahmad 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Result Based Formula.xlsx
Description: MS-Excel 2007 spreadsheet


$$Excel-Macros$$ Result Based Formula

2017-07-07 Thread Munir Ahmad
Pls find the attached excel file it is self explanatory.

I am trying to do the formula still no proper result.

Regards,
Muneer,
CCC...

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-07 Thread Puttu *
Hi Swapnil,

Just to let you know all your comments should be based on the error code.

Error Code column
1
2
3

all these three has different error description.

Thanks
Putta

On Thu, Jul 6, 2017 at 7:14 PM, Puttu *  wrote:

> Hi Swapnil,
>
> Thanks you so much appreciate your time and help on getting this macro. I
> think got almost what required, there is only small changes, which need to
> be done. Sorry its my mistake not giving right information on that.
>
> The reason I am looking a macro is I can't educate others who are very
> beginning stage of learning. Macro will be more easier for them to use than
> conditional formatting.
>
> I have added my comments in Final Tab. Please review and let me know if
> any points are unclear.
>
> Thanks
> Putta
>
>
> On Wed, Jul 5, 2017 at 2:18 PM, Swapnil Palande <
> palande.swapni...@gmail.com> wrote:
>
>> Hi,
>>
>> Why are you not using conditional formatting. If your main purpose is to
>> display user duplicates and empty cells, conditional formatting is best
>> solution.
>>
>> Have applied both solutions (conditional formatting as well as macro) in
>> attached excel.
>>
>> Regards,
>> Swapnil.
>>
>> On Wed, Jul 5, 2017 at 12:24 AM, Puttu *  wrote:
>>
>>> anyhelp please
>>>
>>> On Tue, Jul 4, 2017 at 12:33 PM, Puttu *  wrote:
>>>
 Thanks Sir, Formula match exactly my requirement, however I have more
 than 50 columns, quite difficult to input formula for every column. Thus
 the reason I am looking for macro.

 Please help

 On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande <
 palande.swapni...@gmail.com> wrote:

> Hi,
>
> No need of macro, you can do it using formulas also. Attached is the
> excel for your reference.
>
> Regards,
> Swapnil
>
> On Tue, Jul 4, 2017 at 10:36 AM, Puttu *  wrote:
>
>> Experts, Any help on this will be much appreciated
>>
>> On Mon, Jul 3, 2017 at 10:33 PM, Puttu *  wrote:
>>
>>> Hi Experts
>>>
>>> Please help on this.
>>>
>>> Thanks
>>> Putta
>>>
>>> On Mon, Jul 3, 2017 at 9:42 PM, Puttu *  wrote:
>>>
 Hi Experts,

 I am not a vba expert and need your help me on the attached
 requirement.

 I have list of columns and from that I need to know based on the
 Model No. column filter if the other columns have any duplicate 
 values, if
 yes then it should display comments column as *Column Name +
 duplicate value (Ex: Category_description having duplicate value)*

 2. If the any of the column is blank it should print Column Name is
 blank (*Ex: Parent Category ID has blank value).*

 Attached is the sample spread sheet. Please review and help me on
 it.

 --
 Putta

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
 be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
 forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at https://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not 

$$Excel-Macros$$ TAX IT HERE – Vijayawada

2017-07-07 Thread dileep k


*TAX - IT - HERE *

*MAXIMIZING YOUR INCOME TAX REFUND*

 

We are the first FinTech Start up in the Sunrise State of Andhra Pradesh 
helping individuals and organizations file their IT returns 
 in a seamless way and Hassel 
free manner along with providing financial assistance and unprecedented 
support.

 

*Your friendly neighbourhood Tax expert*

 

Harnessing the talent of highly qualified team of startup enthusiasts, 
Chartered Accountants and Tax Experts 
 we took the bold step to 
launch our operations in Vijayawada and will be growing in other cities and 
metros across the nation.

 

We believe we are paving way to many startups to follow our lead and make 
Andhra Pradesh the next sort out destination for Startups in India.

 

*VALUE PROPOSITION*





 

We help individual tax payers maximize their IT refund while offering the 
convenience of IT filing  and 
tax planning

 

*EFFICIENCY*

 

We ensure to help every individual and organizations maximize on their tax 
refund while helping them file their IT returns 
.

*SUPPORT*

 

We provide free financial guidance on investments round the year.

* SMARTNESS*

 

We help design a consistent investment plan that would be beneficial in 
long term in helping them save and maximize on their investments.

*CONVENIENCE *

 

We arrange for home collection of documents for IT filing.

*MAXIMIZING INCOME TAX RETURNS FOR 3.2 CRORE TAX PAYERS*





-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ TAX IT HERE – Vijayawada

2017-07-07 Thread dileep k


[image: https://taxithere.com/valueproposition.html] 



*TAX - IT - HERE *

*MAXIMIZING YOUR INCOMETAX REFUND 
*

 

We are the first FinTech Start up in the Sunrise State of Andhra Pradesh 
helping individuals and organizations file their IT returns 
 in a seamless way and Hassel 
free manner along with providing financial assistance and unprecedented 
support.

 

*Your friendly neighbourhood Tax expert*

 

Harnessing the talent of highly qualified team of startup enthusiasts, 
Chartered Accountants and Tax Experts we took the bold step to launch our 
operations in Vijayawada and will be growing in other cities and metros 
across the nation.

 

We believe we are paving way to many startups to follow our lead and make 
Andhra Pradesh the next sort out destination for Startups in India.





 

*VALUE PROPOSITION*

 

We help individual tax payers maximize their IT refund 
 while offering the 
convenience of IT filing and tax planning

 

*EFFICIENCY*

 

We ensure to help every individual and organizations maximize on their tax 
refund while helping them file their IT returns. 


*SUPPORT*

 

We provide free financial guidance on investments round the year.

* SMARTNESS*

 

We help design a consistent investment plan that would be beneficial in 
long term in helping them save and maximize on their investments.

*CONVENIENCE *

 

We arrange for home collection of documents for IT filing.


*MAXIMIZING INCOME TAXRETURNS  
FOR 3.2 CRORE TAX PAYERS*






-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.